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
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.
Created attachment 155264 [details] CSV to open in Calc with an explanation comments are within the attached csv
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
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
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 ***