https://bugs.documentfoundation.org/show_bug.cgi?id=148822
Mike Kaganski <mikekagan...@hotmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Resolution|--- |NOTABUG
Status|UNCONFIRMED |RESOLVED
--- Comment #1 from Mike Kaganski <mikekagan...@hotmail.com> ---
It is not a bug. Your locale uses dot as thousand separator, and hence, when it
matches the thousand position, the string "0.117" is interpreted as "zero
thousand one hundred seventeen". When its position is not the correct thousand
position (on 5th position from right, as in "0.0577"), it is not possible to
convert such a string into a number, and the string is kept as string.
You need to either define the correct locale for the data, or to define en-US
for the specific columns (if you use scripting, you would need to define filter
settings, as described at [1]).
[1] https://help.libreoffice.org/latest/en-US/text/shared/guide/csv_params.html
--
You are receiving this mail because:
You are the assignee for the bug.
