https://bz.apache.org/ooo/show_bug.cgi?id=127477
Issue ID: 127477
Issue Type: DEFECT
Summary: Zero is not Zero
Product: Calc
Version: 4.1.3
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: Major
Priority: P5 (lowest)
Component: code
Assignee: [email protected]
Reporter: [email protected]
Target Milestone: ---
Created attachment 86177
--> https://bz.apache.org/ooo/attachment.cgi?id=86177&action=edit
Shows bug where zero is not zero. Pay attention to cells D16, E16, F16
I was entering some data in a spreadsheet and realized some calculations which
should be zero are not zero. I know this is not just a display problem because
I took the cell and did more calculations on it which should also have been
zero and they also were not zero. Further the calculation is simple addition
of 3 cells. If I use parentheses to change the order of the additions, the
value does become zero. Also if I just make a .01 change in the source data,
the calculations are correct.
I am listing the Severity as Major because addition of cells is a very basic
calculation and if there is a problem with addition, that could easily
propogate further into much more complex spreadsheets, unbeknownst to the
users.
I have tried the problem spreadsheet on 2 different installations of 4.1.3
I've narrowed down the problem section somewhat and have attached the sample
spreadsheet showing the bug.
Pay attention to cells D16, E16, F16.
D16 - original bug where zero is not zero
E16 - changes the order of addition resulting in zero
F16 - shows that D16 is not a display error, the value is actually as displayed
--
You are receiving this mail because:
You are the assignee for the issue.
