[Libreoffice-bugs] [Bug 135994] Offer an optional target locale for export to CSV

[bugzilla-daemon at bugs.documentfoundation.org]

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

Eike Rathke <erack at redhat.com> 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 <erack at redhat.com> ---
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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200821/3c25fbac/attachment.htm>