[Libreoffice-bugs] [Bug 133893] : sum function omits one value from list, add two values includes it
https://bugs.documentfoundation.org/show_bug.cgi?id=133893 Buovjaga changed: What|Removed |Added CC||ilmari.lauhakangas@libreoff ||ice.org Status|UNCONFIRMED |RESOLVED Resolution|--- |NOTABUG --- Comment #5 from Buovjaga --- Closing as notabug -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 133893] : sum function omits one value from list, add two values includes it
https://bugs.documentfoundation.org/show_bug.cgi?id=133893 --- Comment #4 from m.a.riosv --- (In reply to Mark Fielden from comment #3) > To me it is a bug. > The problem is inconsistent operation. > a) all the numbers were entered into the text document in the same way Maybe รง > b) the SUM function omitted one of the values without reporting an error Because at least for me it is a text with dot as decimal separator. What kind of error should be reported? > c) the add function accumulated all the values correctly Because only with direct references calc tries to convert numeric text in values when there are no ambiguity. > d) if the user hadn't thought the SUM total wrong, he could have made a bad > decision Like any other stuff users needs to know how to use the tools, and at the contrary that it is a way to avoid a number being taking in account. Use the right arrow on the paste button or go through paste special and paste as non formatted selecting the proper options to get the right values pasted. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 133893] : sum function omits one value from list, add two values includes it
https://bugs.documentfoundation.org/show_bug.cgi?id=133893 Mark Fielden changed: What|Removed |Added Resolution|NOTABUG |--- Status|RESOLVED|UNCONFIRMED --- Comment #3 from Mark Fielden --- To me it is a bug. The problem is inconsistent operation. a) all the numbers were entered into the text document in the same way b) the SUM function omitted one of the values without reporting an error c) the add function accumulated all the values correctly d) if the user hadn't thought the SUM total wrong, he could have made a bad decision -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 133893] : sum function omits one value from list, add two values includes it
https://bugs.documentfoundation.org/show_bug.cgi?id=133893 --- Comment #2 from Mark Fielden --- To me it is a bug. The problem is inconsistent operation. a) all the numbers were entered into the text document in the same way b) the SUM function omitted one of the values without reporting an error c) the add function accumulated all the values correctly d) if the user hadn't thought the SUM total wrong, he could have made a bad decision -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 133893] : sum function omits one value from list, add two values includes it
https://bugs.documentfoundation.org/show_bug.cgi?id=133893 m.a.riosv changed: What|Removed |Added CC||miguelangelrv@libreoffice.o ||rg Status|UNCONFIRMED |RESOLVED Resolution|--- |NOTABUG --- Comment #1 from m.a.riosv --- Range doesn't take in account text numbers, 25.00 is a text number, to me with comma separator the rest of the number are numbers. It is not a bug, LibreOffice it's strict about text number conversion, some options in Menu/Tools/Options/LibreOffe calc/Formula. Please take a look https://bugs.documentfoundation.org/show_bug.cgi?id=133588 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs