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.
To unsubscribe e-mail to: email@example.com
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Impressum (Legal Info)
: 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