https://bugs.documentfoundation.org/show_bug.cgi?id=104970
--- Comment #15 from Buovjaga <[email protected]> ---
(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.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
