https://bugs.documentfoundation.org/show_bug.cgi?id=157799
--- Comment #3 from Mike Kaganski <[email protected]> --- (In reply to Jens-D Doll from comment #2) > your answer is nonsense. Do you say that every time you do not understand anything, instead of asking others to re-phrase the idea in a simpler words that you can comprehend? > The first 9 lines also contain the dots and are not recognized as numers. 9? You never provided a screenshot of what you actually see; but I guess that the first "problematic" result would appear at row 10, with previous *8* lines having the expected result (and the line 1 would contain column names, so no "dots recognized as numbers"). Now try to look at the data, and re-read what I wrote. In row 2, the text of the second column in CSV is "101.91.148". It has three digits in the leftmost group, then a dot, then *two* digits in the middle group, then dot, and then three digits in the rightmost group. I explained, that when the data does not match the "numeric digits in groups of three, separated by dots", it would not get converted into a number. And here, the middle group does not consist of *thee* digits. What is unclear here? The whole data of the cell does not match the number recognition pattern -> it does not get converted. Same for rows 3 to 9. And row 10 has "149.154.159". It is the first row that contains data that matches the rule. It is considered "one hundred forty nine million one hundred fifty four thousand one hundred fifty nine" Indeed, the leftmost group could also be less than 3 digits (say, "9.154.159" would also match as nine million one hundred fifty four thousand one hundred fifty nine). > Also would a conversion to a number yield the wrong value. It would bring a number, which then would be displayed according to the *default* format rules, which don't include thousand separators. > Are you a saboteur? Did you like my words hinting that you are unable to comprehend simple things? If not, then why do you think it's OK to personally attack someone trying to help you by explaining things? -- You are receiving this mail because: You are the assignee for the bug.
