https://bugs.documentfoundation.org/show_bug.cgi?id=163681
Mike Kaganski <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|--- |NOTABUG Status|UNCONFIRMED |RESOLVED --- Comment #2 from Mike Kaganski <[email protected]> --- It means that the locale set in the import dialog, used for interpreting the data in the file, is using dot as thousand separator; when it separates the group(s) of three, and expected, the number recognition treats it as thousand separator, and knows that 1.234 is "one thousand two hundred thirty-four". But when the dot doesn't separate three digits, i.e. appears at unexpected places, the parser sees that this "1.23456" string is not a valid number (in this locale), so it keeps it as a string (including all the characters in it, verbatim). If you want to convert the data to numbers, you need to use the locale that fits the data (e.g., English (USA)). If you need to import all the data as text, you need to set the columns' types to text in the import dialog. Closing NOTABUG. -- You are receiving this mail because: You are the assignee for the bug.
