[Libreoffice-bugs] [Bug 135847] FILEOPEN: csv autoimport not woking for values 1>x>0

[bugzilla-daemon at bugs.documentfoundation.org]

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

Ming Hua <ming.v.hua at qq.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |ming.v.hua at qq.com

--- Comment #2 from Ming Hua <ming.v.hua at qq.com> ---
(In reply to Phillip Sz from comment #0)
> Additional Info:
> Version: 6.4.4.2
> Build-ID: 1:6.4.4-0ubuntu0.20.04.1
> CPU-Threads: 8; BS: Linux 5.4; UI-Render: Standard; VCL: gtk3; 
> Gebietsschema: de-DE (de_DE.UTF-8); UI-Sprache: de-DE
> Calc: threaded
German locale uses comma (,) as the decimal point symbol instead of period (.),
and period (.) is used as separator in long numbers, such as 1.000.000.000 for
a (US) billion.  So in your case values like 0.234 are intepreted as integer
0234 instead of 234/1000.

To import CSV files with period as decimal point, you probably need to change
"Decimal separator key" to period in Tool > Options > Language Settings >
Languages, and unselect "Same as locale setting".  Maybe there is a setting in
the CSV import dialog, but my cursory search didn't find anything.

-- 
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/20200817/43ebd8b4/attachment.htm>