[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

--- Comment #8 from GerardF <gerard.fargeot at orange.fr> ---
> 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"

dots with group(s) of 3 digits are imported as numbers.
Example 123.456 or .005

Without group of 3, example 0.1 or 0.05 it is text.

> 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.

I can agree with this part. Preview should shows text and numbers in the way
they will be imported.

-- 
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/7846e300/attachment.html>