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

Mike Kaganski <[email protected]> changed:

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

--- Comment #2 from Mike Kaganski <[email protected]> ---
This is not a bug.

You are importing the text using a locale that uses comma as thousand
separator. That means that *when a text looks like 0 followed by comma followed
by exactly three digits* - e.g., "0,036", it's recognized as number 0036. In
other locales using different thousand separators, it could look like "0 036",
or "0'036".

Use a correct locale ("language" - see bug 138748 for the term ambiguity) when
you import the data, to correctly treat comma as decimal separator; or mark the
column as text, to avoid its interpretation altogether.

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to