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+unsubscribe@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