Re: [libreoffice-users] Question about charts

2024-03-20 Thread Remy Gauthier
Hello, It is not possible to see images on this list. If you e-mail me the image directly, I will see if I can help you. Regards, Rémy. Le mardi 19 mars 2024 à 23:07 -0300, Enzo Hirosse a écrit : > Hello! I was using LibreOffice Writer and got stuck in a problem > while > using the charts, I don't

Re: [libreoffice-users] Re: putting text in 2 or 3 columns on a single page

2024-03-19 Thread Remy Gauthier
Greetings, Your easiest solution is sections. To create them, highlight the text you want to place in columns and then use Format > Columns... Enter the number of columns you want, with optional spacing (I suggest 0,1 cm), and the format of a separator line if you want. Then hit OK. You can force

Re: [libreoffice-users] split a huge table in subtables (say on different sheets) and link some columns between these tables???

2023-10-03 Thread Remy Gauthier
Hi, You can use the SUMIF function to have the ResSh1 and ResSh2 of final to be updated each time you make an entry. If you only have one "Smith" per table, you can use VLOOKUP to fetch the $7 value for Smith. You will use these functions to find the "Smith" values in each of your smaller tables.

Re: [libreoffice-users] after the fact page numbers

2023-09-25 Thread Remy Gauthier
Hi, You can activate the footer in the page style. If you then go in the footer area and insert the page number where you want it (there are also some tab stops on the left, in the middle, and on the right of the page which can help you position your page number easily). As far as having to

Re: [libreoffice-users] Calc: how to auto-increment sheet names in a cell formula?

2023-09-24 Thread Remy Gauthier
Hi, You could name the location of the data on each sheet with a name created in a way that makes it easy to figure out the name from the row number. You can then use the INDIRECT() function to retrieve the information you want. For example, on the second sheet, the name of the range could be

Re: [libreoffice-users] INDEX MATCH to find MAX value?

2022-12-19 Thread Remy Gauthier
Greetings, If you are looking for the maximum value, would the MAXIFS() function work for you? If you are trying to populate the data in your secondary sheet, with date values in column A, the formula to use in column B2 of the secondary sheet would be: =MAXIFS(Sheet1.M:M,Sheet1.C:C,"=") Then

Re: [libreoffice-users] Header beginning on page 2?

2022-11-29 Thread Remy Gauthier
Greetings, You can start on the second page by editing the default page style if your document has consistent page setup. You can do this with Format > Page Style... From there, go on the Footer tab, and select Footer ON (or Header/Header ON if you want to place the page number on the header) and

Re: [libreoffice-users] "Match case" greyed out

2022-10-27 Thread Remy Gauthier
Greetings Thomas, On Linux, I can duplicate this behaviour when I select the "Cell Styles" box on the dialog. Is yours selected? I hope this helps. Rémy. Le jeudi 27 octobre 2022 à 18:49 +0900, Thomas Blasejewicz a écrit : > Good evening > I just came across something I do not understand (and

Re: [libreoffice-users] [more] Vlookup, and other Help

2022-10-12 Thread Remy Gauthier
Greetings, You can do this with a set of VLOOKUP() functions. I started by creating a table of values like so: Ref Value B C D E F G H I 1 6 10 16 28 38 46 60 80 2 12 20 32 56 76 92 120 160 3

Re: [libreoffice-users] Special Character - checkmark

2021-10-22 Thread Remy Gauthier
Greetings, To insert a character using a number sequence requires the use of the ALT+code combination, not the CTRL+code combination. In WORD, typing ALT+61692 does insert a checkmark. However, in most other applications (such as Notepad, Excel, WRITER) typing this sequence is identical to typing

Re: [libreoffice-users] extracting cell values

2021-09-25 Thread Remy Gauthier
Hello, You can convert the formulas to only keep the values by doing a copy/paste special where what you will keep are only the numbers. To do: select the cells, copy (CTRL-C or Edit > Copy) and then paste special (Edit > Paste Special), and select to keep only the numbers. You may be prompted to

Re: [libreoffice-users] Consolidating values from multiple sheets

2021-08-20 Thread Remy Gauthier
Hello, There are ways of doing this without scripting, but if your entries contain text, then scripting may be required, because my method of sorting/removing duplicates requires the RANK() function and this function only works with numbers. If your cells do contain text and the lengths are short

Re: [libreoffice-users] Regular expressions

2021-07-09 Thread Remy Gauthier
Hello, Regular expressions are a shorthand way of specifying strings against which to match an input. In the COUNTIF(), MATCH(), VLOOKUP(), etc. functions, when you provide a regular expression, you are asking to compare your input to a summary version of what you are looking for. For example, the

Re: [libreoffice-users] specify an absolute sheet address (SOLVED)

2021-06-15 Thread Remy Gauthier
Greetings, The semicolon is used as my separator because my locale (Canadian French) wants decimal commas. In such a case, the list separator is changed to the semicolon to remove the chance of conflict between a number (1 1/2 is written as 1,5 and not 1.5) and its position in the list. The same

Re: [libreoffice-users] specify an absolute sheet address

2021-06-12 Thread Remy Gauthier
Greetings, The management of sheet names works in the same way as cell addresses. Whenever you give a cell address (like A3), a copy/paste of the cell to the next cell to the right will transform A3 into B3. To prevent that, you place a "$" sign in front of the column address, like: $A3. You can

Re: [libreoffice-users] Calc Formula confusion an understanding needed Index/Match

2021-05-29 Thread Remy Gauthier
Hello, I created something that ressembles what Johnny created, and I understand your data is formatted like so: Data1 Data2 blank Data3 Data4 blank Data5 Data6 You want Data6 to be the maximum of Data2 and Data4 (and possibly more columns as well), and you want to have Data5 equal to the date on

Re: [libreoffice-users] Align left side of fraction in math

2021-03-29 Thread Remy Gauthier
Greetings, Not sure I understood exactly what you want, but this is the best I can come up with (2 possible options): f = { alignl { phantom { h } ` v phantom { %pi } } } over { { h } times { %pi } times { { DAP^2 } over { 4 } } } newline f = matrix { v # phantom { a } # phantom { a } } over {

Re: [libreoffice-users] Cannot delete single comment

2021-02-10 Thread Remy Gauthier
Hi, The comment probably has been deleted with "Track Changes" ON (record mode). The X on top of it indicates the comment is actually not there anymore. You can select it (click on it), then go to the Edit menu > Track changes > Accept and that should delete the comment. I hope this helps. Rémy.

Re: [libreoffice-users] lowriter does not handle emoji's properly

2021-01-25 Thread Remy Gauthier
Hi,I don't know if it is significant, but on Fedora 32 (LO7.0), I get the same behaviour. I was able to trace this back to the font Noto Emoji Color (this is the font reported in the PDF document) which, though installed correctly, does not show in any output document, nor does it display in the

Re: [libreoffice-users] calc chart problems

2021-01-19 Thread Remy Gauthier
Greetings Marianne,Things have changed a lot since the version you are using, and it may be difficult to provide the information you are looking for. I did a bit of digging, and I managed to find this document: https://wiki.documentfoundation.org/images/b/bb/CG3403-ChartsAndGraphs.pdf which comes

Re: [libreoffice-users] Re: Calc calendar in xlsx file format - day numbers disappeared suddenly

2021-01-12 Thread Remy Gauthier
Hi Regina,I found your issue: the indent on your cells (like F3) is 223pt which places the text more or less 3 inches (7.9cm) to the right of the cell. This seems to be something that was done as formatting to the cells individually because the Default style calls for a zero indent. Looking at

Re: [libreoffice-users] Calc calendar in xlsx file format - day numbers disappeared suddenly

2021-01-12 Thread Remy Gauthier
Hi,It is a bit hard to guess what is going on without actually seeing the file. Can you e-mail it to me?Two things come to mind:- Calculations are in manual mode and the cells are not re-calculated. You can see the status in Data > Calculate (or try F9 to force recalculation)- Conditional

Re: [libreoffice-users] If-exist condition for conditional text or section

2021-01-01 Thread Remy Gauthier
Greetings, You can use a section to do that in WRITER. The easy way to start is to highlight the text and then Insert > Section. In the section configuration, there is a conditional "Hide" you can use. For example, I created my wide's course material using WRITER and I use a variable named "User";

Re: [libreoffice-users] Row height in Writer tables

2020-12-29 Thread Remy Gauthier
Greetings, I do this to get my tables the way I want them to be. 1) Normally, table content has the style "Table Contents" assigned to it. Edit that style (View > Styles, then right click on Table Contents and select Modify... in the style list) and make sure the spacing before and after the

Re: [libreoffice-users] Date number has 5 digits

2020-12-29 Thread Remy Gauthier
Hi,Even more simple:Just create a number format equal to 'nnn" "d' (without the single quotes) and set the content of the cell to $January.A5. The nnn is the day of the week and the d is the day in the month in a date format. The only thing to remember is that the "d" is valid for English-similar

Re: [libreoffice-users] Easily format cells to bold and a certain background color

2020-11-19 Thread Remy Gauthier
. Le jeudi 19 novembre 2020 à 12:59 +1000, Michael D. Setzer II a écrit : > On 18 Nov 2020 at 19:23, Remy Gauthier wrote: > > > > Subject: Re: [libreoffice-users] Easily format cells to > bold and a > certain >

Re: [libreoffice-users] Easily format cells to bold and a certain background color

2020-11-18 Thread Remy Gauthier
Hi, I am assuming your dates are in column "A", and the data in columns B and next. You can easily do this with conditional formatting: 1) Select your dates and data 2) From the Format menu > Conditional 3) On the Conditional Formatting panel, in the first drop-down, select "Formula is" 4) Enter

Re: [libreoffice-users] finding duplicates in a column in Calc

2020-11-12 Thread Remy Gauthier
Hello. You can highlight the column and select Format > Conditional > Condition > [Cell Value] [is duplicate] (from the drop downs) and select a style to apply (Warning is probably a good one). This will set all duplicate entries in that style (if you selected Warning, the text will be red). You

Re: [libreoffice-users] Writer Tab Stops

2020-11-05 Thread Remy Gauthier
Hello, Really interesting. For me (LO 7.0.2.2 on F32), a right-click in the ruler brings up a menu allowing the selection of the measurement units (or change the type of stop when I click directly on a tab stop), and I always needed to use left-click to insert a tab stop - never right- click.

Re: [libreoffice-users] Conditional Formatting Problem After Copy Sheet

2020-10-25 Thread Remy Gauthier
Greetings, This is something LO does differently from Excel. When you copy a sheet in Excel that references another sheet, the source sheet used for calculations (like Sheet2!A3) remains the same. However, in LO, the sheet reference is converted in a way similar to copying a formula on a sheet: a

Re: [libreoffice-users] Libre Office 7 -vs- Office 2019

2020-09-28 Thread Remy Gauthier
Hi, We used Scribus for a newsletter. Only complaint: we found Scribus had a rather steep learning curve. Rgds, Rémy. Le dimanche 27 septembre 2020 à 17:36 -0400, charles meyer a écrit : > This would suggest that Libre Office 7 supplants MS Office 2019. > > But, what LO application does what MS

Re: [libreoffice-users] Graphics with Libre Draw or Writer

2020-09-21 Thread Remy Gauthier
Hi, In the Drawing Toolbar of Draw, there is something called the "Explosion" in the "Stars and Banners" which you can use as starburst. For the thought baloon, there is a "Cloud" in the Callouts. You can access those from the toolbar or from Shape > Insert > Callouts > Cloud; and Shape > Insert

Re: [libreoffice-users] [Calc] Keyboard shortcut to delete current row when focus on one of its cells?

2020-09-21 Thread Remy Gauthier
Hi, You need to add a new keyboard shortcut. To add, go Tools > Customize... > Keyboard tab. In the bottom portion of the panel, select the Edit Category, and then the "Delete Rows" line in the Function list. Then highlight a suitable keyboard shortcut in the Shortcut Keys area (maybe

Re: [libreoffice-users] Create a relative hyperlink to file?

2020-09-19 Thread Remy Gauthier
Hi, Does not seem to work with something like file://./abc.xyz either.Rémy. Le samedi 19 septembre 2020 à 15:33 +0100, Dave Barton a écrit : > I am trying to create a Writer document with a number of links to > filesin the same directory as the odt file itself. Using absolute > pathseverything

[libreoffice-users] Writer: Master/Sub documents - Placing references

2020-09-17 Thread Remy Gauthier
Hi, I have a master document that contains 9 sub-documents and various text sections. In one of the text sections of the master document, I need to reference a table located in one of the sub-documents. Since the text section is in the master document, as I edit the master document, I just insert

Re: [libreoffice-users] LO 6.4.6.2 CALC : Appropriate formula?

2020-09-15 Thread Remy Gauthier
Hello, An answer your V/HLOOKUP question: HLOOKUP searches for a value on a row (Horizontally) and then goes down to fetch the corresponding entry on a lower rowVLOOKUP searches for a value in a column (Vertically) and then goes across to fetch the corresponding entry on a column to the right In

Re: [libreoffice-users] Libre Draw - create black background with white lettering and import jpgs

2020-08-15 Thread Remy Gauthier
Hi, You can set the black background on the page itself. To set that: Page -> Properties -> Background tab. You can also set the black background on shapes. To set globally, the easy way is to edit the "Graphic" style. Format -> Styles -> Manage Styles, right-click on the Graphic style, select

Re: [libreoffice-users] Libre Writer - Spell Check Auto - gone

2020-08-04 Thread Remy Gauthier
Hello, Some things to check: - The style you are using has spell checking enabled (the language is on the font selection tab) - The font you have selected also enabled spell checking (same thing: font selector panel) - In the options, spell check is enabled to check as you type - In the Tools

Re: [libreoffice-users] [Calc] Good way to turn hours+minutes into minutes?

2020-07-17 Thread Remy Gauthier
Hi, If it's just showing, using a numbers format defined as [m] ("m" between square brackets) will do the job. Since it is time, there should be no decimal minutes to show and this format should work out. Using this format will also allow you to continue making operations with the time values

Re: [libreoffice-users] [6.4.2.2] How to set same font + size for all Text Body paragraphs?

2020-07-12 Thread Remy Gauthier
Hello, First you must make sure your "Text Body" style is configured with Liberation Serif 12. Then you have a few options: Option 1: Select the text in Arial Unicode MS 11 and remove the direct formatting (Format -> Clear Direct Formatting). If you are brave enough, you can select the entire text

Re: [libreoffice-users] Position of caption

2020-07-01 Thread Remy Gauthier
You can find an image by using the navigator (the compass-shaped icon on the side bar). There is an "Images" selection that opens, and you get the list of inserted images in your document. Double-clicking on an entry selects the image and brings you there. The funky behaviour you are describing

Re: [libreoffice-users] Position of caption

2020-07-01 Thread Remy Gauthier
Hello, Not sure on how to reproduce what you see in your environment. We are, however, using versions that are not that far apart (6.4.4.2 on Fedora downloaded from LO). I did the following: - Insert an image - Set the anchor to "Anchor as character" - Right-click on the image, then select

Re: [libreoffice-users] Inverting a whole column

2020-06-29 Thread Remy Gauthier
Hi, If your goal is to only display the values according to a uniform convention, you can define a cell numbering format that reverses the display when compared to a "normal" display for the cells that contain reverse-convention values. Something like this: [<=0]# ##0;[>0]-# ##0;Standard This

Re: [libreoffice-users] Repeat a footnote

2020-06-14 Thread Remy Gauthier
Hi, Instead of just putting a superscript 1 to refer to the footnote, use Insert -> Cross-Reference -> Cross-Reference, then Type is Footnotes, Insert reference to is Reference, and then select your footnote. Using this method, your text will be correct if the footnote number changes. And apply

Re: [libreoffice-users] Printing on Circular CD labels - How to Format

2020-06-12 Thread Remy Gauthier
Hi, You could overlay a circle (Insert -> Shapes -> Basic Shapes) of the correct size over the form and delete it before you print. Just make sure you write in the frame and not in the circle. I hope this helps. Rémy. Le jeudi 11 juin 2020 à 09:41 +0100, Budge a écrit : > I am trying to print

Re: [libreoffice-users] Printing 18 labels per sheet on Avery A4 sheet L7161

2020-06-08 Thread Remy Gauthier
Hi, Not sure if that will work for you, but you can try this: 1) Create your new document2) Select the top-left frame (single click on the border)3) Go Format -> Frame -> properties4) Go to the Borders tab, and then set the internal border to 0,1cm on all sides In my version, this sets the border

Re: [libreoffice-users] Logic of headers (and footers) or my lack of it!

2020-05-30 Thread Remy Gauthier
Hi, The header is attached to the page style you are using. For a given page style, the header will be the same. I think you are looking for a function similat to MS-WORD where you can link consecutive headers and footers to have them "copied" from one section to the other, when pages are

Re: [libreoffice-users] Re: sum text column of common unit of measure numbers

2020-05-07 Thread Remy Gauthier
Hello, I just realised I messed up since I did not think about the units.Considering: 1 GB = 1024 MB1 MB = 1024 KB you can change the formula like this: =SUM(IFERROR(VALUE(SUBSTITUTE(A2:A29," KB","")),0),IFERROR(VALUE(SUBSTITUE(A2:A29," MB",""));0)*1024,IFERROR(VALUE(SUBSTITUE(A2:A29,"

Re: [libreoffice-users] sum text column of common unit of measure numbers

2020-05-07 Thread Remy Gauthier
Hi, If your values takes up, for instance the range A2 to A29, you can enter this formula as an array formula: =SUM(VALUE(SUBSTITUTE(SUBSTITUTE(A2:A29," KB","")," MB",""))) The only trick is to hit CTRL-SHIFT-ENTER instead of just ENTER at the end of the formula entry: if you only use ENTER, this

Re: [libreoffice-users] Calc Question

2020-04-22 Thread Remy Gauthier
Hello Steve, You cannot attach files to your emails to this group since they do not get relayed. Your only option is to attach it to a topic on LO's nabble site ( http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html ). You could also send it to me directly and I'll have

Re: [libreoffice-users] Capital letters in dates (in calc)

2020-01-23 Thread Remy Gauthier
Greetings, I do not know how to achieve what you are looking for directly. However, you can use something like this, supposing you want to display the date of January 21, 2020: Content of call A1: =DATE(2020;1;21) - cell format is "J "Content of cell B1: =SUBSTITUTE(TEXT(A1;"J

Re: [libreoffice-users] font formats

2020-01-12 Thread Remy Gauthier
Hi, Just a thought: are the fonts that are defined in the styles installed? It sounds a lot like font substitution playing tricks on you. This would explain how you try to apply a style and nothing happens. I hope this helps. Rémy.Le vendredi 10 janvier 2020 à 12:29 +0100, Pieter van Oostrum a

Re: [libreoffice-users] impress - slide transitions not working

2019-12-16 Thread Remy Gauthier
Hi, I tried the slide transitions you mention (dissolve - both fine and standard, and fade - with both offered variants) and I cannot see the effect you are describing. If it can help, this is my running environment: Libre Office Version: 6.3.3.2, installed from the LO Web site - not the

Re: [libreoffice-users] Problem with text formatting in Report.

2019-05-15 Thread Remy Gauthier
Greetings, I tried this in calc (which I am assuming you are using), and it seems to work for what you describe: [<>""]-@ The interesting thing is that calc changed it afterwards to [<>0]-@;Standard but it still seems to work. I hope this helps. Rémy. Le mercredi 15 mai 2019 à 15:17 -0700,

Re: [libreoffice-users] percent to whole fraction

2019-04-25 Thread Remy Gauthier
Hi, I am assuming you are using Calc. There is no formula to do this: it is a cell formatting accessible via Format -> Cells... -> Numbers Tab, then go to the "Fraction" category. There you can select the # ???/??? format which will do what you are looking for. I hope this helps. R??my. Le

Re: [libreoffice-users] Libreoffice corrupted by Ubuntu failed upgrade

2019-04-21 Thread Remy Gauthier
Hi, I opened a bug about this yesterday (bug 124864). I have been experiencing this since 6.2.2 on Linux Fedora, and the only possible resolution I found was to stick with using 6.2.1, downloaded from the LO site. Hopefully this will work for you as well. Rémy. Le dimanche 21 avril 2019 à

Re: [libreoffice-users] Adding events into a libreoffice calc graphic

2019-04-13 Thread Remy Gauthier
Hi, I never was able to mix text and numbers on a single graph, so placing the event as part of the data may not work. There is a workaround, though. Plot your data points without placing the event text in the data, but a corresponding event value (or some acceptable in-between value). Then, go

Re: [libreoffice-users] Transparency in Write

2019-04-13 Thread Remy Gauthier
Hi, I am using 6.2.1 and, like you, Format > Image > Properties > Transparency does nothing to the picture. However, if you go on the side pane, select the properties and play with the Image (not area) transparency there, it works fine. Note that Format > Image > Properties > Transparency brings

Re: [libreoffice-users] Re: how to reformat this?

2019-04-13 Thread Remy Gauthier
Hi, Instead of using text marks, you can also do the search and replace and after place your cursor where you want the line breaks to be and type Enter. This will cut the line without inserting an end of paragraph. Rémy. Le vendredi 12 avril 2019 à 20:50 -0700, V Stuart Foote a écrit : > If you

Re: [libreoffice-users] Calc: moving/sorting rows on Sheet1 don't update formulas on Sheet2 that refer to them

2019-04-10 Thread Remy Gauthier
Hi, There are two ways to fix your problem: 1) Insert cells to place the new entries at the top, above cells A2-B2 , which will move down the reference of the last cell automatically. The new cells must be in the range of the search array (if you insert above A1, the search array reference will

[libreoffice-users] Templates and version 6.2.2

2019-04-04 Thread Remy Gauthier
Hello, I installed the latest version (6.2.2) of LO taken from the LO WEB site (6.2.2) on a Fedora 28 desktop last week. I downloaded the RPMS for the version itself, the French language pack and the online help for both English and French and installed everything. Since then, whenever I would

Re: [libreoffice-users] saving a calc spreadsheet as template with its functions?

2019-02-24 Thread Remy Gauthier
Hello, A template contains the starting point of a document (or spreadsheet): anything in the template will be copied to the new document (or spreadsheet) when you create it - this is why you see the WCA numbers in new spreadsheets created from that template. You should update your template to

Re: [libreoffice-users] Page number format in 6.2

2019-02-18 Thread Remy Gauthier
Hi, Not sure for 6.2 (I am currently using 6.1), but you can set the page numbering like this: - Insert Field -> Other fields -> Document Tab -> Select page and its format on the right - Styles -> Manage Styles -> Page Styles -> Select the current page style, then right-click -> Modify -> Page

Re: [libreoffice-users] Removing ink

2019-01-07 Thread Remy Gauthier
Hi, I am assuming you want ot use the pen during a slideshow. To clear the pen marks on a slide, there is a selection when you right-click on the slide (Erase all ink on slide), but to my knowledge, to erase the ink from all slides at the same time, you must end/restart the slideshow. I hope

Re: [libreoffice-users] what's the best way to make charts of spreadsheet data

2019-01-04 Thread Remy Gauthier
Hi, You could also have a look here: https://www.linuxlinks.com/plottingtools/ Rémy. Le vendredi 04 janvier 2019 à 22:05 +, Dave Howorth a écrit : > On Fri, 4 Jan 2019 18:54:47 +0100 > Regina Henschel wrote: > > > Hi Dave, > > Dave Howorth schrieb am 02-Jan-19 um 18:12: > > [..] > >

Re: [libreoffice-users] Edit a style

2019-01-01 Thread Remy Gauthier
Hi, I can edit styles in Writer, Calc, and Impress without problems, both from the side panel or from the style name drop-down. Version: 6.1.4.2 Fedora 28 Sorry! Rémy. Le mardi 01 janvier 2019 à 19:03 +0100, Johnny Rosenberg a écrit : > Am I the only one who can't edit styles? > I right

Re: [libreoffice-users] LibreOffice 6.0.7.3 (stable): Units and Sizes

2018-12-19 Thread Remy Gauthier
Hello, I do not seem to see this problem with LO 6.1.3 (on F28). However, please note that in DRAW there is a scaling setting (Tools > Options > LibreOffice Draw > General that changes the units of the ruler and position of objects. Could that be set to something else besides 1:1? I hope this

Re: [libreoffice-users] corrupt letter

2018-11-25 Thread Remy Gauthier
Hi, It almost looks like if the "Monthly car payment" string was displayed using the date format of the A1 cell. What are the language and formats used in the A1 and B1 cells? Rémy. Le mercredi 21 novembre 2018 à 20:05 -0500, James a écrit : > I use lubuntu-18.10. > Sometimes, a letter gets

Re: [libreoffice-users] [SOLVED] Re: Calc 6.0.6.2 IF criteria statement help

2018-11-17 Thread Remy Gauthier
Hi, To answer your question about the CONCATENATE("<>","Y"), I am looking for something that is not explicitly marked as reconciled (not "Y"). This test will mark as not reconciled all entries having an "N" (or anything else for that matter) and all blank entries (a blank cell obviously not being

Re: [libreoffice-users] Calc 6.0.6.2 IF criteria statement help

2018-11-10 Thread Remy Gauthier
Hi, I believe you had a similar (if not identical question) which you posted back on September 27th (topic: IF doesn't respect AND - http://d ocument-foundation-mail-archive.969070.n3.nabble.com/IF-doesn-t- respect-AND-td4249584.html). At the time you had uploaded a file to Google and I had

Re: [libreoffice-users] Writer: Using “spell out” chapter numbering styles

2018-10-31 Thread Remy Gauthier
Hi, Thank you all. I will wait for the next version. Regards, Rémy. Le mercredi 31 octobre 2018 à 16:20 +0100, Ricardo Berlasso a écrit : > El mié., 31 oct. 2018 a las 13:40, t.com> > escribió: > > > Remy Gauthier wrote: > > > Hi, > > > > > > I h

[libreoffice-users] Writer: Using “spell out” chapter numbering styles

2018-10-29 Thread Remy Gauthier
Hi, I have been trying to experiment with the "spell out" numbering styles in Writer. To setup my document, I went to Tools -> Chapter Numbering, and selected "One, two, three..." for Numbering with Heading 1 at level 1, and "First, Second, Third" for Numbering with Heading 2 at level 2. I then

Re: [libreoffice-users] Help! Can't delete floating frame!

2018-10-15 Thread Remy Gauthier
Hi, n the Drwing toolbar, there is a select tool (white arrow). Select that and draw a selection area around your floating frame (click-drag). This should select the frame; at that point, hit "Delete". I hope this helps. Rémy. Le lundi 15 octobre 2018 à 15:44 -0700, John Jason Jordan a écrit :

Re: [libreoffice-users] Using VLOOKUP with concatenated values.

2018-10-10 Thread Remy Gauthier
Hi, The most simple approach is to have another sheet where you perform the actual match of room and code. You then concatenate the results of the multiple (or single) matches and display that result on your page. You would need to know in advance what is the maximum number of room references

Re: [libreoffice-users] auto capitalizing after quotes.

2018-10-10 Thread Remy Gauthier
Hi, Not really a fix, but something you could try... You can add an auto correct entry that will transform a sequence of, for example "a to "A (you would also need to add all the letters). For the closing quote, the sequence would be ." a which would become ." A. Since it is auto correct, you

Re: [libreoffice-users] How to get max date < today from list

2018-10-06 Thread Remy Gauthier
Hi, If you can sort your data, you can use the "MATCH()" function to look for that date. If column "A" contains the dates sorted in ascending order, this formula will return the latest date which is less than "TODAY" (if you remove the "-1", then it will be for less than or equal to "TODAY"):

Re: [libreoffice-users] Page numbering issue

2018-10-01 Thread Remy Gauthier
Hello, Your «Titre 3» style has a forced page break before, with a setting of the page number to 5. Removing the setting makes the page number correct again. The setting is part of the style, so Display Styles (F11) > Find «Titre 3» in the paragraph styles > Text Flow (Enchaînements) > Unset the

Re: [libreoffice-users] IF doesn't respect AND?

2018-09-27 Thread Remy Gauthier
Hi Hylton, You can transform your fomula in C3 of your Summary sheet like this: =SUMIFS(Data.C$3:Data.C$1000,Data.$A$3:Data.$A$1000,CONCATENATE("=",$A3 ,"*"),Data.$F$3:Data.$F$1000,CONCATENATE("<>","Y")) This formula will add the values in the data column, provided the RECON is not "Y" (which is

Re: [libreoffice-users] Great File size problem

2018-09-24 Thread Remy Gauthier
Hi, I have a spreadsheet that contains Canadian weather data since 1953 (more or less) for 25 weather stations. For each station, there are 28 columns and about 11000 rows of data, with one station per sheet. On top of that, there are some other sheets that I use to mine into the data. For good

Re: [libreoffice-users] Can't save Font changes to my template (or any template)

2018-09-23 Thread Remy Gauthier
Le dimanche 23 septembre 2018 à 16:14 +0200, Ricardo Berlasso a écrit : > El dom., 23 sept. 2018 a las 16:07, Peggy (<33mar...@gmail.com>) > escribió: > > > I've tried several ways after searching, including one that's > > supposed to > > be for the latest LibreOffice. It's writer I want to

Re: [libreoffice-users] Prompt On Replace

2018-09-07 Thread Remy Gauthier
Hello, I am not sure I understand your question. However, when you open the Find and Replace panel, there are a "Find Next", "Find Previous" and "Replace" buttons that enable you to locate the next instance of the string to replace (or the previous); if you hit "Replace" at that point, the

Re: [libreoffice-users] JRE help please

2018-08-31 Thread Remy Gauthier
Hi, Did you "add" the Java JRE in LO? You need to go to Tools -> Options -> Advanced and add the path to the JRE there. I hope this helps. Rémy. Le vendredi 31 août 2018 à 18:31 -0400, Peggy a écrit : > I installed JRE several days ago and have closed Libre Office, but I still > get this

Re: [libreoffice-users] Question about tables and page margins in Writer

2018-08-12 Thread Remy Gauthier
Hi, You could insert a 1-inch header that is empty. You can alter the page style or directly format the page: Format -> Page -> Header, then: - Header ON - Autofit height: OFF - Height: 1 inch Note that I am using LO 6.0, so it might be slightly different for you but I think that those

Re: [libreoffice-users] Spellchecker not working

2018-06-24 Thread Remy Gauthier
Hi, The language is taken from the language associated with your character formatting (Format -> Character). In my version (LO 6), when the language on the font tab is set to None, I get the behaviour you are describing. You can change this by editing the associated style(s) and set the language

Re: Re: [libreoffice-users] Writer paragraph numbered list issue

2018-06-06 Thread Remy Gauthier
Hi, There seems to be an initialization problem with your chapter numbering. In Writer, chapter levels and their numbering are defined in Tools -> Chapter Numbering. On that panel, you can define the style of the paragraph level (usually Heading 1 to Heading 10 or whatever works in your language)

Re: [libreoffice-users] Long comments in calc?

2018-06-02 Thread Remy Gauthier
Le samedi 02 juin 2018 à 11:34 +0200, David Rakidzija a écrit : > Hi, > > what's the best way to insert long comments into calc? A floating window that > does not interfere with the spreadsheet itself would be best. > 1. the built in commentary for cells seems to be buggy, sometimes wound't >

Re: [libreoffice-users] difference in hours between two times

2018-05-24 Thread Remy Gauthier
Hi, If it is pure display you are looking for, then the difference in days is: =INT((A2+B2)-(A1+B1)) with a numbers display format (such as # ##0) the difference in hours is: =(A2+B2)-(A1+B1) with a display format set to [h] You can be a bit fancy and set the # days format to be # ##0" days" and

Re: [libreoffice-users] How many of you deal with the Linux Users Group [Facebook]?

2018-04-30 Thread Remy Gauthier
Le lundi 30 avril 2018 à 21:53 +, Virgil Arrington a écrit : > On 04/30/2018 05:49 PM, Ben Oliver wrote: > > On 18-04-30 21:43:00, Virgil Arrington wrote: > > > This is intriguing. I just looked over my options with LO 6.0.3 > > > in > > > saving as a PDF and I don't easily see any method of

Re: [libreoffice-users] Calc: Calculate number of days until yesterday IE TODAY-1 to assist in array determination for COUNTIF?

2018-04-28 Thread Remy Gauthier
Hi, If I understand your question correctly, you need to be able to "automatically" index in your data matrix, for total sum and number of days. To achieve this, I would change the worksheet in the following manner: Formula in D2: =SUM(OFFSET(D3;0;0;MATCH(TODAY()-1;$C$3:$C$368;0);1)) This formula

Re: [libreoffice-users] please help ...

2018-03-31 Thread Remy Gauthier
Hi, Would this be the Slide... Insert Slide from file? I hope this helps. Rémy Gauthier.PS: Not sure my last message went through (mixup of sender address). Sorry if it came twice. Le samedi 31 mars 2018 à 22:04 +0200, Regina Henschel a écrit : > Hi, > > some feature have moved. Do you remember,

Re: [libreoffice-users] Comments buggy in Calc (tested 5.3.7 and 5.4.4)

2018-02-03 Thread Remy Gauthier
Have you tried using Right-click -> Edit comment? When you do this, the cursor is placed inside the comment and you can easily navigate in it. At that point entering CTRL-A will select the entire comment text. I tend to agree with you that accessing the comment text by clicking in the comment when

Re: [libreoffice-users] Re: Database corruption since LO 5.7.3 installed

2018-01-07 Thread Remy Gauthier
Hi, This problem seems to have been observed not so long ago: https://ask.libreoffice.org/en/question/63369/repair-corrupt-odb-file/ The fix that is mentioned in that post is there: https://forum.openoffice.org/en/forum/viewtopic.php?f=83=17567 Not sure if the proposed solution will help, but it

Re: [libreoffice-users] installed disc usage for LO

2018-01-03 Thread Remy Gauthier
Le mercredi 03 janvier 2018 à 12:17 +0100, Philip Jackson a écrit : > > Those were the days !! > Philip > Hi, Yes, you are right. But apparently, you can't stop "progress". This link shows a nice visualization of what this thread has been talking about (there is also a link at the bottom of

Re: [libreoffice-users] installed disc usage for LO

2018-01-01 Thread Remy Gauthier
Hi, As an FYI, on Fedora 25, the 64-bit version of 5.4.4-2 comes in at 879MB (result of the command "dnf erase libreoffice*" for a French/English installation with local help in both languages installed). Interestingly, LO 5.4.4.2 on my Windows 10 platform (64- bit, VmWare WS player 14) uses

Re: [libreoffice-users] Embedding Fonts

2017-12-02 Thread Remy Gauthier
Hi, Have you tried File -> Properties -> Font Tab -> Embed fonts in the document (available in Writer, Calc, Impress, Draw - did not try Base). Rémy Gauthier. Le samedi 02 décembre 2017 à 11:31 -0700, arakish a écrit : > Did a search and all I found was some mumbo jumbo about legality. > >

Re: [libreoffice-users] Formula and text in same cell?

2017-11-21 Thread Remy Gauthier
Greetings, You can also create a custom number format to place text around the value if you only want to show a single value. For example, you can assign this number format to a cell: "Jane bought "0" apples." If you then set the value of the cell to 2, the cell will display: Jane bought 2 apples.

Re: [libreoffice-users] Create scan button?

2017-11-19 Thread Remy Gauthier
Hi, I tried to insert the button (using the icon you found), but the only thing I was able to get is text describing the function of the button. Never was able to get the icon only. Looks like a bug. I'm on LO 5.4.2.2, on Linux/Fedora 25. Rémy Gauthier. Le dimanche 19 novembre 2017 à 14:55 -0500,

Re: [libreoffice-users] Calc 5.x Mac - syntax to link cells in two spreadsheets?

2017-10-29 Thread Remy Gauthier
Hello, This is not a MAC reference (it is a Linux reference), but this syntax (LO 5.4.2.2 Linux/Fedora 64-bit) works well for me: ='file:///mnt/public/Documents/Global/List of CDs.ods'#$Sheet1.C11 The link was inserted as per the instructions in the help (https://help

Re: [libreoffice-users] External Hard Drives - to save my LO and other content

2017-10-18 Thread Remy Gauthier
> than trying to ascertain that with WD? > > Thank you so much, > > Charles. > > From: Remy Gauthier <remygauth...@yahoo.com> > To: charles meyer <reachmepl...@gmail.com>, "users@global.libreoffice.org" < > users@global.libreoffice.org> > D

Re: [libreoffice-users] External Hard Drives - to save my LO and other content

2017-10-16 Thread Remy Gauthier
Hi, Hard drives will die (even SSDs). While MTBF indicates long periods of time, some will still experience drive failures with corresponding loss of data (been there, done that). If you want to use something external to store your data while still having very low probability of data loss, I

  1   2   >