Description: In the French locale, the traditional decimal separator is the comma. However, it is also very frequent to use the dot as well, especially when spreadsheets are generated from computer programs. Opening such documents in Calc is a nightmare, because there is no option to set the decimal separator specifically. I read that LO gets that parameter from the locale, so I used my OS configuration to set the number format to C : KDE allows to change it without changing the whole locale. However, this seems to get Calc confused : pressing the dot key on the keyboard does produce a dot (and not a comma), but such an input is not recognised as a number. Also (and this is what bugs me the most), in documents that I get from elsewhere, numbers that are written with a dot are treated as text. Steps to Reproduce: 1. In KDE configuration settings, go to Regional settings, Language. 2. Set Region to fr_FR.UTF8. 3. Set Numbers to C. 4. Log out then back in. 5. Run Calc. 6. Type in 23.4. Actual Results: 23.4 is in the cell, but is treated as text. Expected Results: 23.4 should be recognised as a number. Reproducible: Always User Profile Reset: No Additional Info: Version: 7.3.7.2 / LibreOffice Community Build ID: 30(Build:2) CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: kf5 (cairo+xcb) Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR Ubuntu package version: 1:7.3.7-0ubuntu0.22.04.3 Calc: threaded
LibreOffice doesn't support the fine-grained LC_... locale settings. If you "set Numbers to C" in KDE what probably is set is LC_NUMERIC, but that is not evaluated, all LibreOffice locale settings (number, date, calendar, ...) follow LC_CTYPE instead. You can set that in your environment to any locale supported by LibreOffice, like LC_CTYPE=en_CA.UTF-8 en_CA as example here because that uses '.' dot decimal separator and a sensible ISO 8601 date format.
Sounds like closing as duplicate of bug 48043 is the right thing to do. *** This bug has been marked as a duplicate of bug 48043 ***