Date: prev next · Thread: first prev next last
2019 Archives by date, by thread · List index

IMHO the issue could be related to the cell format, either to the number
of decimals or to the thousands separator. In any case, the cell format
can be tweaked.

On 23/04/19 17:06, Andrea Venturoli wrote:

I'm producing a CSV for a customer of mine, which will import it with
LibreOffice 6.2 on a Mac.

If LibreOffice locale (from Options menu item) is set to English,
everything is fine; if it's set to Italian there are problems with numbers:
_ 123.45 gets correctly read as 123,45 (we use comma for decimals in
_ 123.456 is read as 123456, when it should be 123,456.

So my customer has to switch global locale, import the file and switch
back (not sure if she also needs to restart LO).

What puzzles me is that she's also asked the locale in the import
dialog, but what she chooses here doesn't seem to matter.

Is this a bug or am I overlooking something?

 bye & Thanks

Italo Vignoli -
mobile/signal +39.348.5653829 - skype italovignoli
GPG Key ID - 0xAAB8D5C0
DB75 1534 3FD0 EA5F 56B5 FDA6 DE82 934C AAB8 D5C0

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
Privacy Policy:


Privacy Policy | Impressum (Legal Info) | Copyright information: 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.