https://bugs.documentfoundation.org/show_bug.cgi?id=148375
--- Comment #5 from Albert <albert.clae...@telenet.be> --- 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. -- You are receiving this mail because: You are the assignee for the bug.
