Re: [libreoffice-users] CSV import trouble (numbers & locale)

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:
> Hello.
>
> 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
> Italian);
> _ 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
>     av.

-- 
Italo Vignoli - italo@italovignoli.com
mobile/signal +39.348.5653829 - skype italovignoli
hangout/jabber italo.vignoli@gmail.com
GPG Key ID - 0xAAB8D5C0
DB75 1534 3FD0 EA5F 56B5 FDA6 DE82 934C AAB8 D5C0

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