https://bugs.documentfoundation.org/show_bug.cgi?id=155717
Bug ID: 155717
Summary: Calc confused when number format set to C in KDE
Plasma
Product: LibreOffice
Version: 7.3.7.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
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
--
You are receiving this mail because:
You are the assignee for the bug.
