Re: [libreoffice-users] specify an absolute sheet address (SOLVED)
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: users+unsubscr...@global.libreoffice.org 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
Re: [libreoffice-users] specify an absolute sheet address (SOLVED)
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: users+unsubscr...@global.libreoffice.org 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
Re: [libreoffice-users] specify an absolute sheet address (SOLVED)
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. Kind regards Johnny Rosenberg After futile efforts to make all those symbols work somehow, I recalled you mentioning "naming a range". Since I did not know, there is such a concept, I did some reading and after a few experiments - I hope! - I may actually have solved my problem. 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? Greetings from Japan where it is sunny (and rather hot) today, but we are about to enter the rainy season ... Thomas Blasejewicz -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org 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