Date: prev next · Thread: first prev next last
2020 Archives by date, by thread · List index

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.

Brian Barker

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
Privacy Policy:


Privacy Policy | Impressum (Legal Info) | Copyright information: 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.