Bug 155717

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