Bug 140104 - The localisation of the decimal separator does not work for every type a French keyboard in LibreOffice Calc
Summary: The localisation of the decimal separator does not work for every type a Fren...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All Linux (All)
: medium normal
Assignee: Not Assigned
: 156124 (view as bug list)
Depends on:
Blocks: Decimal-Separator-Key
  Show dependency treegraph
Reported: 2021-02-02 18:24 UTC by ildegarde59@mailo.com
Modified: 2024-03-23 21:32 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description ildegarde59@mailo.com 2021-02-02 18:24:58 UTC
I discovered this bug on Fedora 33 with LibreOffice set on the French/France Localisation. If we set the default keyboard as "French (alt.)" or as another alternative French keyboard than "French" or "French (AZERTY)", LibreOffice Calc does not apply the localisation of the decimal separator whereas it works with the "French" or the "French (AZERTY) keyboard". For information, in France the decimal separator is not a point but a coma. For example, the number 2,121.25 (US disposition) is written 2 121,25 in France. It is very problematic because the "French (alt.)" keyboard disposition is set as default on many Linux distros for the French/France localisation because it enables to type all the characters of the French language (such as œ or Œ or É or Ç) whereas "French" or "French (AZERTY)" don’t enable it at all.

Steps to Reproduce:
You have to use a computer with French/France Localisation with the "French (alt.)" disposition ("Français (variante)" in French language).
1. Open a new file in LibreOffice Calc (with setting to make the decimal separator same as the localisation system preferences enabled).
2. Try to type a decimal number using the button of the decimal separator on the numeric keypad.

Actual Results:
A point will appear on the screen instead of a coma and the number typed won’t be recognised by LibreOffice Calc as a number but as text.

Expected Results:
The expected result is a coma when we press the button of the decimal separator on the numeric keypad of the keyboard.

Reproducible: Always

User Profile Reset: No

Additional Info:
Build ID: 00(Build:2)
CPU threads: 8; OS: Linux 5.10; UI render: default; VCL: gtk3
Locale: fr-FR (fr_FR.UTF-8); Langue IHM : fr-FR
Calc: threaded
Comment 1 Jean-Baptiste Faure 2021-03-06 21:41:40 UTC
Reproducible with LO built at home under Ubuntu 18.04 x86-64.

It works as expected with keyboard layout Français (AltGr+O -> ø) and does not work with Français (variante) (AltGr+O -> œ), Français (variante obsolète) and Français (azerty).

Set status as NEW

Best regards. JBF
Comment 2 Stéphane Guillou (stragu) 2023-07-05 15:04:32 UTC
*** Bug 156124 has been marked as a duplicate of this bug. ***
Comment 3 mazzhe 2023-07-05 20:33:10 UTC
As said in bug 156124, reproductible under Debian 12 freshly installed, and LO updated.
  Version: (X86_64) / LibreOffice Community
  Build ID: 36ccfdc35048b057fd9854c757a8b67ec53977b6
  CPU threads: 8; OS: Linux 6.1; UI render: default; VCL: kf5 (cairo+wayland)
  Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR
The keyboard layout used is Français (BÉPO, AFNOR).

A french user tested several layouts and posted his comment on linuxfr: https://linuxfr.org/nodes/131678/comments/1928573
Comment 4 Stéphane Guillou (stragu) 2024-03-23 21:32:34 UTC
(In reply to mazzhe from comment #3)
>   CPU threads: 8; OS: Linux 6.1; UI render: default; VCL: kf5 (cairo+wayland)
For kf5/kf6 + Wayland users, please see bug 143540, which is an issue on KDE's side.

For gtk3 users, it would be good to check again if things have improved since the fix for bug 154623.

Thank you!