Description: The ThousandSeparator and DecimalSeparator has been updated for the en_ZA locale in CLDR v43.1. See: - https://unicode-org.atlassian.net/browse/CLDR-16247 - https://cldr.unicode.org/index/downloads/cldr-43#h.qobmda543waj Actual Results: en_ZA locale is not up-to-date with CLDR data. <ThousandSeparator> </ThousandSeparator> <DecimalSeparator>,</DecimalSeparator> Expected Results: en_ZA locale is up-to-date with CLDR data. <ThousandSeparator>,</ThousandSeparator> <DecimalSeparator>.</DecimalSeparator> Reproducible: Always User Profile Reset: No Additional Info: Version: 24.2.0.3 (X86_64) / LibreOffice Community Build ID: da48488a73ddd66ea24cf16bbc4f7b9c08e9bea1 CPU threads: 20; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win Locale: en-ZA (en_ZA); UI: en-ZA Calc: threaded
Hello Eike, I thought you might be interested in this issue
Please see bug 119613 for why LO uses the current separators.
Eike, I understand that, but even though these are the "official" separators, they are very seldom used. Have a look at this: https://unicode-org.atlassian.net/browse/CLDR-14707?focusedCommentId=161272 All 4 of the top banks, the largest retailers, and even the SA Revenue Service (tax authority). The CLDR has been updated to follow widespread usage, and I hope that you will do the same. If you like, I can try to get in touch with the OP of that issue, to see if he is in agreement.
I'm inclined to follow CLDR here, with what we already had before their switch, even if contradictory to official style guides. Meanwhile I just learned today that there seems to be a 3rd mix in the wild, group separator _space_ and decimal separator _period_ https://ask.libreoffice.org/t/tricky-almost-impossible-csv-import-due-to-thousands-separator-and-decimal-symbol/104593 Anyway, CLDR with that reference list switching is a good argument.
Eike Rathke committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/92ea59703da91771ca78ade82ca796077c066da8 Resolves: tdf#159829 DecimalSeparator '.' period, ThousandSeparator ',' comma It will be available in 24.8.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Added to release notes https://wiki.documentfoundation.org/ReleaseNotes/24.8#Changes_to_locale_data