[Libreoffice-bugs] [Bug 104970] CSV "Text Import" dialog configuration issues with OS local and LibreOffice local

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=104970

--- Comment #15 from Buovjaga <todventtu at suomi24.fi> ---
(In reply to Buovjaga from comment #14)
> Created attachment 135672 [details]
> CSV with decimal separators corrected to commas
> 
> In the F column the values are numbers, but with incorrect decimal separator
> for German locale. They should be using commas. Now as they are detected to
> be "Number" format, the import treats 2.544 as two thousand five hundred and
> forty four due to German locale using period as the thousands separator.

In another report, I bumped into a more elegant way that does not require
changing the .csv: https://wiki.documentfoundation.org/Faq/Calc/136/fr
So in the import dialog, change the columns with the period decimal to type
"English (US)". Note that Shift and Ctrl keys work when selecting the columns
in the dialog.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20170821/58ca10ca/attachment.html>