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.