https://bugs.documentfoundation.org/show_bug.cgi?id=158073
Mike Kaganski <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |RESOLVED Resolution|--- |NOTABUG --- Comment #1 from Mike Kaganski <[email protected]> --- This is not a bug, and works correctly, according to the selected import settings. As you correctly mentioned, your locale uses decimal comma. What you didn't mention was that your locale also uses dot as thousands separator. Since your data uses decimal dot, you need to configure your import accordingly, so that it knows how to process what character. On your "Img 2", it is evident that you didn't change the locale of the import (second dropdown from top); and also you didn't select en-US type for specific columns. In this mode, import would use German locale to process the data; and every text that consists of groups of three digits separated by dots would be considered thousands. So a text "54.782" means in Germany "fifty four thousand seven hundred eighty two". This number gets imported; and then it is displayed in cells using a default number format, which doesn't show thousand separators. Note that "All the dots in place" in the import dialog is just because the import dialog is designed to show you which text will go to which cell; it doesn't show you a result of *processing* that text (number recognition). Either set the whole import locale to en-US, or set it for the selected columns that contain numbers with decimal dot. Note that the documentation for the import dialog [1] explains this; see "Language" section discussing the effect of that field on number recognition, and "Column Type" section for information about how to set it selectively. [1] https://help.libreoffice.org/latest/en-US/text/shared/00/00000208.html?&DbPAR=CALC -- You are receiving this mail because: You are the assignee for the bug.
