https://bugs.documentfoundation.org/show_bug.cgi?id=135994
Eike Rathke <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Hardware|x86-64 (AMD64) |All
Severity|normal |enhancement
Version|7.0.0.0.beta1+ |Inherited From OOo
Summary|Calc changes dots into |Offer an optional target
|commas |locale for export to CSV
Ever confirmed|0 |1
Status|UNCONFIRMED |NEW
--- Comment #1 from Eike Rathke <[email protected]> ---
Imported numbers and dates are displayed with the formats of the current
locale, which for you is Swedish (sv-SE) that uses comma as decimal separator.
This is expected and normal behaviour. Saving to CSV uses the locale settings
of the cells, which normally is expected by users.
To force a dot decimal separator you can assign number formats of a locale that
uses dot as decimal separator, for example English-UK (en-GB), to the data
after import. Or before or after import set the overall locale to an English
one under Tools -> Options -> Language Settings -> Languages, Locale setting;
which switches all display formats' default locale.
However, I agree that when exporting to CSV an optional target locale could be
offered to override the cells' number format locale(s).
--
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
