You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@openoffice.apache.org by bu...@apache.org on 2014/04/01 22:19:00 UTC

[Issue 124576] Open CSV file converts numeric cells incorrectly

https://issues.apache.org/ooo/show_bug.cgi?id=124576

mroe <mr...@gmx.net> changed:

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

--- Comment #1 from mroe <mr...@gmx.net> ---
It is a duplicate of issue 87885.

But it isn't a real bug. With the right Locale (like en-GB) where "." is
defined as decimal point all values are treated right as decimal values.

With the "wrong" Locale where "," is defined as decimal point values with a
count of decimals unequal to 3 are treated as strings/text.
But with exact 3 decimals the "." becomes the meaning of a Thousends Separator.

0.667 = 0.667,00 = 667

If you want that all values are treated as strings then on import select "Text"
for this column.

*** This issue has been marked as a duplicate of issue 87885 ***

-- 
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.