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

Reply via email to