Description: I am using Windows 10/11 and LibreOffice CALC 7.3.2. The language setting of the userinterface is 'Standaard-Nederlands (NL)' Because I live in Belgium the keyboard is AZERTY with a dot (.) on the numeric keyboard. Therefore My local setting is 'Standaard-Nederlands (België)' My keyboard setting is 'Belgisch punt'. The language-settings in CALC let me choose the decimal separator (selected) as 'X Equal to locale setting (,)' for the Dutch (NL) QWERTY-keyboard OR (unselected) as 'O Equal to locale setting (,)' for the Belgian (BE) AZERTY-keyboard (.). This setting works fine, my decimal-key on my numeric keyboard changes from (,) into (.). The big problem is that CALC not recognized the point (.) as decimal separator but treats the numbers with a dot as normal text, so the calculation does not work! Steps to Reproduce: 1.Goto 'Options'-'Language settings'-'Languages' 2.Unselect 'Decimal separator sign' => 'O Equal to local setting (,)' => symbol becomes a decimal point (.) when key is touched on numeric keyboard, this is OK. 3.Try to make a calculation: see attached picture :numbers are treated as text instead of number! This is NOT OK! Actual Results: Calculation not possible. Numbers with decimal separator (.) are seen as text. Expected Results: CALC has to recognize the dot (.) as a decimal separator! Reproducible: Always User Profile Reset: Yes Additional Info: Decimal separator key - Same as country setting Specifies how the decimal separator key, this is "." on the numeric keypad and set in your country settings, should be applied when you press that key. If this check box is selected, the character displayed after "Same as country setting" is inserted when you press the key on the numeric keypad. If that check box is not selected, then the character specified in your keyboard driver is inserted. Translated with www.DeepL.com/Translator (free version)
Created attachment 179310 [details] Effect of error CALC sees text instead of numbers
How an introduced number it's interpreted has nothing to do with the setting about decimal separator on the numeric keyboard. Calc recognizes the numbers, with the decimal separator of the language in the cell style. Changing the language on default cell style, could solve your problem, and can be changed as many times you need, numbers are remained fine in the cells.
Sorry, but I think there is a misunderstanding. I've copied a part of the help-text in de 'Additional Info'. "... If that check box is NOT selected, then the character specified IN YOUR KEYBOARD DRIVER is inserted...." I think here is the misunderstanding! CALC does recognize only the language-setting but not the keyboarddriver? In the Dutch language are two different Keyboards used: - Dutch NL (= The Netherlands) uses the Dutch language but a QWERTY-keyboarddriver which has no accents and a comma as separator key on the numeric keyboard. - Dutch BE (= Belgium) uses (almost) the same Dutch language but has normaly an AZERTY-keyboard which has a dot (.) as separatorkey on the numeric keyboard. In my attached picture, you can see the check box is NOT selected. I wrote that I am using Windows 10 and Windows 11 and the 'character specified in my keyboard driver (the dot . ) is inserted' This is working fine. The character, when I use the decimal separator key of my numeric keyboard shows a dot (.). The problem comes when I type decimal numbers in Calc, the dot (and not a comma) is placed but Calc does not recognise the numbers as decimal but places the numbers as text, to the left side in the column, and can not calculate while it sees only text. In my opinion, the problem is that it does not matter if the check box is selected or not, Calc places yes a dot but does not looks to the KEYBOARD setting and stil needs a comma to see the difference between text and number?
The checkbox only matters on how the key is taken, but has nothing to do on how the input value is introduced in the cell, this last depends on the language of cell's style.
I completely agree when you say: "The checkbox only matters on how the key is taken, but has nothing to do on how the input value is introduced in the cell, this last depends on the language of cell's style." It definitely should be like that. A comma or a dot are the only signs that could be a decimal separator in a number. So when the check or uncheck of the checkbox only changes the symbol dot or comma, it is OK. The problem is that not only the comma becomes a dot, but when it becomes a dot then CALC thinks the nummers that will be entered in a cell becomes text although my local settings do not change. I'll have a last try to show you my problem with another picture in attach. I will use numbers between ( ) in this text and in the attached picture: "languages-comma-dot.jpg" trying to show it more clearly in the picture what happens. (1) In Windows 10 (and 11) I have the language of my region: 'Nederlands (België)' with an AZERTY-keyboard and a dot as decimal key on the numeric keybord. (2) My Decimal-separator = dot (.); (3) The groupingsymbol (thousends) = space. (4) An example of the local settings of my numbers in Windows. Then I put the two options for my Standard local settings in CALC. (5) On the left: 'Standard-Nederlands (België)'. (6) On the right: 'Standard-Nederlands (België)', exactly the same. (7) On the left sample with the checkbox checked. (8) I can input numbers in A1 and A2 with my numeric keyboard but my dot-key of the numeric keyboard shows the decimal-separator a comma ( , ) and makes a correct sum. (9) On the right sample with the checkbox UNchecked (10) With the checkbox UNchecked and the same Local Settings, I type the same numbers in A1 and A2. Now the dot of my numeric keyboard is correctly shown but Calc does not recognize it as numbers but as text! So I can not calculate the sum! So, on my opinion, the checkbox is not usable because the simple change of the decimal separator, changes the numbers that I enter, directly in text and that should in my opinion NOT happen! If I'm wrong in my conclusion, so please explane me the correct use of the checkbox. PS. I couldn't find a setting for the separating of the Thousands. Normally (in our system) the standard herefore is a space.
Created attachment 179335 [details] Problem with dot as decimal-separator