[Libreoffice-bugs] [Bug 148375] CALC FORMATTING False information concerning setting for decimal separator, calculating not possible because numbers are treated as text.
https://bugs.documentfoundation.org/show_bug.cgi?id=148375 --- Comment #6 from Albert --- Created attachment 179335 --> https://bugs.documentfoundation.org/attachment.cgi?id=179335&action=edit Problem with dot as decimal-separator -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 148375] CALC FORMATTING False information concerning setting for decimal separator, calculating not possible because numbers are treated as text.
https://bugs.documentfoundation.org/show_bug.cgi?id=148375 --- Comment #5 from Albert --- 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.
[Libreoffice-bugs] [Bug 148375] CALC FORMATTING False information concerning setting for decimal separator, calculating not possible because numbers are treated as text.
https://bugs.documentfoundation.org/show_bug.cgi?id=148375 --- Comment #4 from m.a.riosv --- 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. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 148375] CALC FORMATTING False information concerning setting for decimal separator, calculating not possible because numbers are treated as text.
https://bugs.documentfoundation.org/show_bug.cgi?id=148375 Albert changed: What|Removed |Added Resolution|NOTABUG |--- Status|RESOLVED|REOPENED Ever confirmed|0 |1 --- Comment #3 from Albert --- 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.
[Libreoffice-bugs] [Bug 148375] CALC FORMATTING False information concerning setting for decimal separator, calculating not possible because numbers are treated as text.
https://bugs.documentfoundation.org/show_bug.cgi?id=148375 m.a.riosv changed: What|Removed |Added Status|UNCONFIRMED |RESOLVED Resolution|--- |NOTABUG CC||miguelangelrv@libreoffice.o ||rg --- Comment #2 from m.a.riosv --- 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. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 148375] CALC FORMATTING False information concerning setting for decimal separator, calculating not possible because numbers are treated as text.
https://bugs.documentfoundation.org/show_bug.cgi?id=148375 Albert changed: What|Removed |Added CC||albert.clae...@telenet.be --- Comment #1 from Albert --- Created attachment 179310 --> https://bugs.documentfoundation.org/attachment.cgi?id=179310&action=edit Effect of error CALC sees text instead of numbers -- You are receiving this mail because: You are the assignee for the bug.