At 10:02 22/11/2020 -0700, Gilles Noname wrote:
Brian Barker wrote
Yes, if your locale needs semicolons as separators commas will not
do. That is definitely what error 509 will be signalling.
Odd that the locale would change the sign used in functions.
Odd, maybe, but true. Sorry that my formulae did not exactly match your needs.
Brian Barker wrote
That is because you have - weirdly - chosen to mess up my formula,
changing my "E" (for east) into "O" (for west). So *of course* the
longitude signs are now reversed. Reinstate my "E" and everything will work.
Because in the document O = West, not East (which I forgot to point out).
I know that, but it seems you don't! You didn't need to point it out:
I had realised - and explained so in my original message. But you are
still missing the point here. You thought you needed to translate my
formula, but you didn't: I wrote exactly what you needed here. My
test mentions "E" for east (or "est") but properly distinguishes
between "E and "O". By changing "E" to "O" you have not translated
into French but changed east to west. I'm sure east in France is the
same east as anywhere else, and similarly west - no matter that the
names are different! (Or do French compasses point southwards?!) You
need "E" for French "est" in my formula just as you would need "E"
for English "east". Surely you can see that swapping east and west
(as you chose to do) will swap the signs of your longitude values and
introduce the error?
Yes: I based my formulae on that original picture! Note that includes
"E" for east/est.
I trust this helps.
To unsubscribe e-mail to: email@example.com
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy