Description: french keyboard numpad dot instead comma. I stay in France. Since an update of Ubuntu 20.04.3 LTS who include a Libreoffice update, in Calc when I type on the keyboard in the numpad the dot it write a dot instead of a comma. Calc interpret this as a text and not as a num. Steps to Reproduce: 1.Select a french keyboard in Ubuntu. 2.Open Calc 3.In a cell write 2,5 with the numkeypad Actual Results: If the result is 2.5 and if the cell shows it like a text, it is the bug. Expected Results: With a french keyboard selected on Ubuntu, the result is 2,5 and in Calc it is a number and not a text. Reproducible: Always User Profile Reset: No Additional Info: Thank you for your help.
What is the state of "Decimal separator key" checkbox under Options/Language Settings/Languages? In its checked state, it *should* make the button in question to result in your locale's separator. If your locale is correctly set in LibreOffice to use comma as decimal separator (which is OK, as you say that dot is not recognized as part of a number), and the checkbox is set, then failure to have comma from the key would mean something preventing LibreOffice to recognize that the key is actually the numpad key.
(In reply to Mike Kaganski from comment #1) > What is the state of "Decimal separator key" checkbox under Options/Language > Settings/Languages? In its checked state, it *should* make the button in > question to result in your locale's separator. > > If your locale is correctly set in LibreOffice to use comma as decimal > separator (which is OK, as you say that dot is not recognized as part of a > number), and the checkbox is set, then failure to have comma from the key > would mean something preventing LibreOffice to recognize that the key is > actually the numpad key. Thanks for the answer. The linguistic parameter/decimal separator is "," the comma in LibreOffice. The problem appears after an Ubuntu update that include an LibreOffice update. Since years the dot on the numpad is reconized as a comma with my french keyboard.
I get a comma inserted as expected with French keyboard layout + locale, both with latest of 7.2 and in a current 7.5 build. Please update to a more recent LO version and check again.
*** This bug has been marked as a duplicate of bug 143540 ***