[Libreoffice-bugs] [Bug 146741] Importing csv removes dot in some numbers and not in other numbers

2022-01-13 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=146741

Eike Rathke  changed:

   What|Removed |Added

 Status|RESOLVED|CLOSED

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

[Libreoffice-bugs] [Bug 146741] Importing csv removes dot in some numbers and not in other numbers

2022-01-13 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=146741

Eike Rathke  changed:

   What|Removed |Added

 Status|UNCONFIRMED |RESOLVED
 Resolution|--- |NOTABUG

--- Comment #1 from Eike Rathke  ---
Make sure that in the CSV Import dialog you set the proper import locale, i.e.
here an English (probably English-US) locale. For your Dutch locale has ','
comma decimal separator and '.' group separator, the dot in the numbers is
taken as group separator (if thousands separator, thus multiple of three digits
to the right) else the character sequence is imported as text instead of
numeric value.

Another possibility is, again in the import dialog, to set specific column
types to English-US.

Not a bug.

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