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

On 24-4-2019 05:43, Drew Jensen wrote:
> Howdy,
>
> Well, I'm using LibreOffice 6.2.3 (with Ubuntu) and have created a csv file
> with two data rows
> 12.12
> 12.123
>
> Then set my global locale to Italian(Italy) and try to open the csv file.
> (which is using a tab to separate values btw)
> If in the dialog box I change the defaulted Italian(Italy) locale to
> English(USA) everything works as expected, with the data in the now
> Italian(Italy) local file:
> 12,12
> 12,123
>
> If I do not set the locale in the import dialog to a locale which used the
> '.' for decimal it does not work properly.
>
> But if doing it in that order does is not working on the MAC then I would
> say yes you should open an issue in the bug tracker.
>
> Best wishes,
>
> drew
After opening a CSV file, The 'column type' can be set (see atached 
picture.)

The data in the columns (12.12 and 12.123) is imported using the decimal 
separator of the language of you locale, in my case 'Dutch' (=decimal ",")

test.csv

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