[Libreoffice-bugs] [Bug 138537] Import CSV sometimes change delimeted char-values to numbers

[bugzilla-daemon at bugs.documentfoundation.org]

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

Mike Kaganski <mikekaganski at hotmail.com> changed:

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

--- Comment #4 from Mike Kaganski <mikekaganski at hotmail.com> ---
I suppose it's not a bug actually. The "problematic" parts have groups of
exactly three digits, separated by the locale's *thousand separator*. It's
normal that these strings are recognized as valid whole numbers.

All cases where the groups were not three are recognized as not valid numbers,
thus kept as is.

This works as expected. You should mark the columns as string explicitly on
import, and that would disable the number recognition.

-- 
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/20201128/c50a5f72/attachment-0001.htm>