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 applies to formulas where numbers can be used as arguments in a list, so the argument separator becomes the semicolon.
As John rightfully pointed out, one can change the separator used, but in my case the comma is really not an option. This is purely a display artifact because I can share Calc files regardless of the separator used: if you open one of "my" Calc files, your separator will be used, and vice-versa. I hope this helps. Rémy. Le mardi 15 juin 2021 à 00:02 -0400, John Kaufmann a écrit : > On 2021-06-14 20:25, Thomas Blasejewicz wrote: > > On 2021/06/13 2:55, Johnny Rosenberg wrote: > > > Another way to get around it is to name your range. Then your > > > formula could look something like =VLOOKUP(N76;ZipCodes;2;0) > > > Named ranges are absolute, always. > > ... > > Defining the data range in the sheet "Zip codes", naming it > > "zipcodes" (this setting apparently does not accept spaces), the > > formula seems to be working .. AND .. looks a lot friendlier! > > =VLOOKUP(N79,zipcodes,2,0) > > > > Your idea was VERY helpful! Thank you. > > Even I can understand that formula. > > (You used semicolons in your formula, mine has commas. Is there a > > difference? > > Tools > Options > LibreOffice Calc > Formula > Separators > > -- To unsubscribe e-mail to: [email protected] Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
