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

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.


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).

https://postimg.cc/QH0q5qmn <https://postimg.cc/QH0q5qmn>  

Thank you.



--
Sent from: http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html

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