[Libreoffice-bugs] [Bug 116258] Severe Bug: Libre Office Calc: csv Import --> correct preview , wrong numbers imported

[bugzilla-daemon at bugs.documentfoundation.org]

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

kontakt_1 at t-online.de changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|RESOLVED                    |REOPENED
         Resolution|NOTABUG                     |---
     Ever confirmed|0                           |1

--- Comment #7 from kontakt_1 at t-online.de ---
(In reply to GerardF from comment #6)
> In DE locale, comma is decimal separator and dot is thousand separator.
> so 0.05 is impoted as text 0.05 and 0.005 (3 digits after dot) is imported
> as 5.
> 
> No bug here.
> Just choose correct locale or English US column type in import dialog.



Ok. the behaviour has something to do with the DE locale.

But your answer did not explain
why 0.05 and 0.00001 gets imported correctly 
(at least looking correctly, even if it is interpreted as text)
and 0.005 becomes read as a number, here as number "5"

In addition to it your answer does not explain why the preview shows the
correct numbers.

It still seems pretty buggy to me.

The behaviour is not predictable for the user.

-- 
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/20180307/35de5db6/attachment.html>