Description: I open CSV file where decimal symbol is ".". Then I change language of number formatting to English (USA) or any other where decimal symbol is ".". After change symbol ' inserted before number. Steps to Reproduce: 1.Ensure that your default locale is with decimal symbol ",". 2.Open CSV file with numbers where decimal symbol is "." 3.Set cell formatting to number and select language where decimal point is "." Actual Results: Cell content is modified by inserting symbol ' Expected Results: Cell content must be not modified Reproducible: Always User Profile Reset: No Additional Info: [Information automatically included from LibreOffice] Locale: lt Module: SpreadsheetDocument [Information guessed from browser] OS: Windows (All) OS is 64bit: no
This is not a bug. When you are opening a CSV, you may fine-tune how the characters there should be treated; which locale to use to decide if cells contain numbers or texts. If your CSV had numbers using dots as decimal separators, you should either chose respective language in the CSV import dialog, or set column types explicitly. If you had imported your CSV using wrong settings, and your data could not be converted to numbers because of those wrong settings, the data is of course textual. From now on, it will stay textual, no matter how you reformat your cells, unless you re-enter the data (e.g., convert it using Data->Text to Columns). When you change the language of the cells that already contain text into en-US, those cells that contain text that *looks* like numbers in that language gets a hint - the leading apostrophe - to show you that the cell has *text* that would otherwise be handled as number, if you re-enter it into this cell. This is works as expected.
By being lead of developers team myself, I can tell you, that no user expect that this data will be modified by just changing language. So good luck presenting bugs as features ...
(In reply to Mantas from comment #2) This is *exactly the opposite*. This is about *formatting will never modify the data*.