https://bugs.documentfoundation.org/show_bug.cgi?id=148375
Albert <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|NOTABUG |--- Status|RESOLVED |REOPENED Ever confirmed|0 |1 --- Comment #3 from Albert <[email protected]> --- 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? -- You are receiving this mail because: You are the assignee for the bug.
