Re: [libreoffice-users] Re: [Calc] Convert GPS coords from DMS to decimals?

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?

> https://postimg.cc/QH0q5qmn

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: 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