[Libreoffice-bugs] [Bug 123869] import .csv with floats and delimiter=pipe is wrong

[bugzilla-daemon at bugs.documentfoundation.org]

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

Mike Kaganski <mikekaganski at hotmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|---                         |NOTABUG
             Status|NEW                         |RESOLVED

--- Comment #10 from Mike Kaganski <mikekaganski at hotmail.com> ---
Oh, but it is not a bug. The "problem" is that in the third row, the "0.025" is
detected as a number 25; and that is correct, according to the "Danish" locale
chosen in the "Language" selector (see tdf#138748 for the terminology issue).
Danish locale uses dot as thousand separator; so the text where three decimal
digits are separated by the dot are identified as integer values, and where
different number of digits is separated by dot is correctly not detected as a
valid number. The file does *not* use Danish locale conventions, so it should
either be imported using English (USA) selected as "Language", or the column
itself should be marked as "US English".

-- 
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/20210521/14763310/attachment.htm>