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

At 06:48 22/11/2020 -0700, Gilles Noname wrote:
> The issue with Error 509 was apparently due to 
> columns being of the wrong type (source should 
> be text, and target should be number), ...

No, it will not be that.

> ... and using "," instead of ";" in Left() and Mid().

Yes, if your locale needs semicolons as 
separators commas will not do. That is definitely 
what error 509 will be signalling.

> ... it's working… but the West/East isn't: Even 
> when LO finds "O" ("ouest" for West) in the 
> source, I'm not getting a negative as expected:

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.

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