Bug 128327 - CONFIGURATION, FORMATTING Locale setting does not correctly bring decimal character from Windows Regional settings
Summary: CONFIGURATION, FORMATTING Locale setting does not correctly bring decimal cha...
Status: RESOLVED DUPLICATE of bug 73242
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.1.0.0.alpha1+
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-10-22 16:19 UTC by Gary
Modified: 2020-05-08 18:35 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
CSV to open in Calc with an explanation (392 bytes, text/plain)
2019-10-23 14:53 UTC, Gary
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Gary 2019-10-22 16:19:13 UTC
Description:
My windows regional setting is South Africa. 
Decimal Symbol . (period) Digit Grouping Symbol , (comma)

In Libreoffice Calc, Options | Language Settings | Languages | Decimal Separator key (checked) Same as locale setting (,)  <<--should be (.) period as per windows regional settings.

Similarly, Currency Formats do not correctly use the regional decimal but they do correctly apply the regional goupring digit

Steps to Reproduce:
1. Windows Control Panel | Region | Formats | Format: English (South Africa)
2. Additional Settings | Decimal setting will be a period and Digit Grouping Symbol will be a comma.  ALSO change the currency settings. Set Decimal to period and separator/grouping to Comma.

3. Reboot windows for region settings to take effect
4. In Libreoffice Calc, Options | Language Settings | Languages | Decimal Separator key (checked) Same as locale setting (,) <<--Incorrect!
5. In a new spreadsheet, enter a number greater than 999 and convert to currency


Actual Results:
4. Separator key (checked) Same as locale setting (,)
5. number becomes R 1,000,00


Expected Results:
4. Separator key (checked) Same as locale setting (.)
5. number should be R 1,000.00


Reproducible: Always


User Profile Reset: Yes


OpenGL enabled: Yes

Additional Info:
[Information automatically included from LibreOffice]
Locale: en-GB  *** my windows locale is set to South Africa***
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Windows (All)
OS is 64bit: no ***-my OS is 64 bit***

[Copied From Help / About]
Version: 6.2.7.1 (x64)
Build ID: 23edc44b61b830b7d749943e020e96f5a7df63bf
CPU threads: 4; OS: Windows 10.0; UI render: default; VCL: win; 
Locale: en-ZA (en_ZA); UI-Language: en-GB
Calc: threaded
Comment 1 Xisco Faulí 2019-10-23 13:49:15 UTC
Thank you for reporting the bug.
it seems you're using an old version of LibreOffice.
Could you please try to reproduce it with the latest version of LibreOffice
from https://www.libreoffice.org/download/libreoffice-fresh/ ?
I have set the bug's status to 'NEEDINFO'. Please change it back to
'UNCONFIRMED' if the bug is still present in the latest version.
Comment 2 Gary 2019-10-23 14:53:17 UTC
Created attachment 155264 [details]
CSV to open in Calc with an explanation

comments are within the attached csv
Comment 3 Gary 2019-10-23 14:54:34 UTC
Bug is still present in 
Version: 6.3.2.2 (x64)
Build ID: 98b30e735bda24bc04ab42594c85f7fd8be07b9c
CPU threads: 4; OS: Windows 10.0; UI render: default; VCL: win; 
Locale: en-ZA (en_ZA); UI-Language: en-GB
Calc: threaded
Comment 4 Mike Kaganski 2020-02-11 06:58:31 UTC
This is two different things:

1. LibreOffice does not use custom format settings/codes defined in Windows (tdf#73242);
2. Misconception of what is "Decimal Separator key - Same as locale setting".

The latter option - "Decimal Separator key - Same as locale setting" - does not mean what you want it to mean ("use decimal separator as defined in system"). Instead, it means "when user presses numpad "." button, should LibreOffice insert the character that system sends to the application (option unchecked) or the character defined in the locale *used in LibreOffice* as decimal separator (option checked)" [1]. Note that this results in different *text* being entered into the place where current edit is performed; and what happens with that *text* later is unrelated to the setting: LibreOffice will then treat the string using its normal processing, and if the resulting string does not form a valid number in the locale used in LibreOffice, it will rightfully *not* become a number then.

[1] https://help.libreoffice.org/latest/en-US/text/shared/optionen/01140000.html
Comment 5 Buovjaga 2020-05-08 18:35:01 UTC
Yep, South African official decimal separator is comma as discussed in bug 127602

I guess let's close as dupe of bug 73242

*** This bug has been marked as a duplicate of bug 73242 ***