Bug 155717 - Calc confused when number format set to C in KDE Plasma
Summary: Calc confused when number format set to C in KDE Plasma
Status: RESOLVED DUPLICATE of bug 48043
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.3.7.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-06-07 15:39 UTC by Yann Salmon
Modified: 2023-08-10 11:10 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Yann Salmon 2023-06-07 15:39:44 UTC
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
Comment 1 Eike Rathke 2023-06-07 17:19:15 UTC
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.
Comment 2 Buovjaga 2023-08-10 11:10:57 UTC
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 ***