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+unsubscr...@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
