[Libreoffice-bugs] [Bug 128327] New: CONFIGURATION, FORMATTING Locale setting does not correctly bring decimal character from Windows Regional settings

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=128327

            Bug ID: 128327
           Summary: CONFIGURATION, FORMATTING Locale setting does not
                    correctly bring decimal character from Windows
                    Regional settings
           Product: LibreOffice
           Version: 6.2.7.1 release
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: garyatom8 at gmail.com

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

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20191022/32d35ab9/attachment.html>