[Libreoffice-bugs] [Bug 156571] Perculiar addition error resulting in erronious additional decimal (specifically x.xx99999999999)
https://bugs.documentfoundation.org/show_bug.cgi?id=156571 --- Comment #4 from xyhfna --- Having read the linked document, I understand that this is a representation issue, however, complicating a users calculations to simplify an internal representation issue is frankly not good. Almost every other calculation system on the planet performs the action of simple addition without slowing down significantly or without needing user intervention. If the system must use a single representation that is incapable of accuracy, it should be able to flag those representations, and take mitigating actions. Fixed value double integer calculation and other solutions are available to aleviate the floating point issue. Forcing a rounding calculation potentially introduces errors on the user side. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 156571] Perculiar addition error resulting in erronious additional decimal (specifically x.xx99999999999)
https://bugs.documentfoundation.org/show_bug.cgi?id=156571 xyhfna changed: What|Removed |Added Resolution|NOTABUG |--- Ever confirmed|0 |1 Status|CLOSED |REOPENED --- Comment #3 from xyhfna --- There is no point using any form of rounding if the values do not ever have any additional digits! You cannot mark as resolved just because there is a work around. The issue should not be occuring in the first instance. 1.11 + 2.22 should always equal 3.33 without any need for rounding. The Calc application is performing some function on the values resulting in 1.11 + 2.22 being evaluated to 3.3299. This is clearly an internal error! Do your users a favour and dont jump to conclusions. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 156571] Perculiar addition error resulting in erronious additional decimal (specifically x.xx99999999999)
https://bugs.documentfoundation.org/show_bug.cgi?id=156571 Eike Rathke changed: What|Removed |Added Status|RESOLVED|CLOSED -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 156571] Perculiar addition error resulting in erronious additional decimal (specifically x.xx99999999999)
https://bugs.documentfoundation.org/show_bug.cgi?id=156571 Eike Rathke changed: What|Removed |Added Status|UNCONFIRMED |RESOLVED Resolution|--- |NOTABUG --- Comment #2 from Eike Rathke --- Expected. See https://help.libreoffice.org/7.6/en-GB/text/scalc/01/calculation_accuracy.html?DbPAR=CALC and https://wiki.documentfoundation.org/Faq/Calc/Accuracy Use proper rounding in calculation steps, in this case to 2 decimals. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 156571] Perculiar addition error resulting in erronious additional decimal (specifically x.xx99999999999)
https://bugs.documentfoundation.org/show_bug.cgi?id=156571 --- Comment #1 from xyhfna --- An update to LibreOffice is being installed. Another test will be performed to test if the issue has already been addressed. -- You are receiving this mail because: You are the assignee for the bug.