Bug 136892 - Symbol ' inserted before number when changing language in number formating screen
Summary: Symbol ' inserted before number when changing language in number formating sc...
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.3.5.2 release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-09-19 13:50 UTC by Mantas
Modified: 2020-09-19 21:04 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Mantas 2020-09-19 13:50:35 UTC
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
Comment 1 Mike Kaganski 2020-09-19 14:31:16 UTC
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.
Comment 2 Mantas 2020-09-19 18:23:08 UTC
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 ...
Comment 3 Mike Kaganski 2020-09-19 21:04:34 UTC
(In reply to Mantas from comment #2)

This is *exactly the opposite*. This is about *formatting will never modify the data*.