Description: I discovered this bug on Fedora 33 with LibreOffice 7.0.4.2 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: Version: 7.0.4.2 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
Reproducible with LO 7.1.2.0.0+ 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
*** Bug 156124 has been marked as a duplicate of this bug. ***
As said in bug 156124, reproductible under Debian 12 freshly installed, and LO updated. Version: 7.5.4.2 (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
(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!
I don't think is a KDE bug (in fact, kde apps like KCalc work fine) but of libreoffice-qt integration part. In any case I SOLVED for QT6 and Wayland this way: apt install libreoffice-qt6 apt purge libreoffice-qt5 Now calc works fine with the decimal separator issue, just has a strange "look", that is like an old GTK2 app... maybe is a libreoffice-qt6 bug? In any case it solves this particular issue, maybe KDE-related package manager should do this "upgrade" automatically once QT6 is detected (I upgraded from kde 5.27 to 6.1, probably a distro directly with 6.1 installs libreoffice-qt6 by default)
ehm, I did not noticed that libreoffice-kf5 was automatically removed but libreoffice-kf6 was not installed... Installing libreoffice-kf6 solved the "ugly" (and missing kde integration) look!
ehm, my bad... the decimal separator worked BECAUSE of the missing libreoffice-kf6, now the integration is fine BUT the bug persists. Sorry for the noise, was to happy to have been solved and willing to share :( Unfortunately Bugzilla comments can't be edited nor deleted... Maybe this is a libreoffice-qtx integration with Wayland bug? I hate the situations where 2 projects say that is the other that has to fix a bug, because often will be not fixed by neither...