Description: In South Africa it standard to have a point (.) in a number to divide an integer from its fraction, not a comma (,). This works in the Ubuntu default install of LibreOffice but not if you install directly from the LibreOffice website. Steps to Reproduce: 1.Install LibreOffice from the official website 2.Install and turn on the South African language pack 3.In Libre Calc type a number with a fraction in a cell. Actual Results: 1,1 Expected Results: 1.1 Reproducible: Always User Profile Reset: Yes OpenGL enabled: Yes Additional Info:
According to https://en.wikipedia.org/wiki/Decimal_separator + https://sadev.co.za/content/how-correctly-format-currency-south-africa + https://limn.co.za/2013/05/south-african-number-formats/, decimal separator is a comma. Even if with the time, "." may become the standard. Decimal separator for South Africa seems defined here: https://opengrok.libreoffice.org/xref/core/i18npool/source/localedata/data/en_ZA.xml?r=fbc6415b
I am struggling to find any reference except for the normal message boards complaining about the use of commas as they are not standard in South Africa for daily use.
Unfortunately, it appears that a "decimal comma" is "more correct", despite widespread usage to of the "decimal point" https://en.wikipedia.org/wiki/Decimal_separator#cite_note-17 https://laws.parliament.na/cms_documents/gg-4326-a7726e51e7.pdf
Fwiw, bug 119613 requested this change.
Note also https://github.com/unicode-cldr/cldr-numbers-modern/blob/master/main/en-ZA/numbers.json From http://cldr.unicode.org/ Unicode Common Locale Data Repository If you want to advocate changing this globally in software, the most efficient way would be to approach CLDR. Let's close.
Libre Office seems to IGNORE the default installed locale settings regarding decimal point is a ".". The resolved "wontfix" status of this ticket does not seem to address this issue. I've been living in South Africa for 53 years and I can promise you we ALWAYS use dot as a decimal point. The WIKIpedia entry is based on an old huge-ly outdated lie. on a fresh KDE Neon 5.27 install: at /etc/default/locale LANG=en_ZA.UTF-8 LC_ADDRESS=en_ZA.UTF-8 LC_IDENTIFICATION=en_ZA.UTF-8 LC_MEASUREMENT=en_ZA.UTF-8 LC_MONETARY=en_ZA.UTF-8 LC_NAME=en_ZA.UTF-8 LC_NUMERIC=en_ZA.UTF-8 LC_PAPER=en_ZA.UTF-8 LC_TELEPHONE=en_ZA.UTF-8 LC_TIME=en_ZA.UTF-8 In /usr/share/i18n/locales/en_ZA % Country name in English country_name "South Africa" % ISO 4217 Currency and fund codes % http://www.bsi-global.com/Technical+Information/Publications/_Publications/tig90.xalter int_curr_symbol "ZAR " currency_symbol "R" mon_decimal_point "." mon_thousands_sep "," mon_grouping 3;3 LC_NUMERIC decimal_point "." thousands_sep "," grouping 3;3 END LC_NUMERIC Please if you cannot fix it, at least give an option to specify decimal point as a dot via a checkbox somewhere. Hope you can help.
That's the long standing bug 46448 needing a reimplementation of how system settings, current locale, locale data and locale datas' number formats interact.