You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2017/07/15 21:48:09 UTC
[Issue 127477] New: Zero is not Zero
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: issues@openoffice.apache.org
Reporter: hshaw@pobox.com
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.
[Issue 127477] Zero is not Zero
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127477
--- Comment #5 from hshaw@pobox.com ---
Let me put it a different way
D16=D15+A16+B16
calculated value is
-4.5475E-013
E16=D15+(A16+B16)
calculated value is
0
E16=0 is the correct value. D16 and E16 are the exact same formula, just
changed the order of the addition (associative property of addition)
I can only duplicate this problem when the answer is supposed to be zero. Any
other source data that leads to non-zero answer does not exhibit the buggy
behavior.
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127477] Zero is not Zero
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127477
hshaw@pobox.com changed:
What |Removed |Added
----------------------------------------------------------------------------
OS|All |Windows 10
Hardware|All |PC
--- Comment #1 from hshaw@pobox.com ---
This is on Windows 10 64-bit.
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127477] Zero is not Zero
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127477
Peter <le...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Resolution|--- |NOT_AN_ISSUE
Status|UNCONFIRMED |RESOLVED
--- Comment #6 from Peter <le...@gmail.com> ---
This is a floating point inpresition is caused by your cpu.
I am not sure but if you set the field only to show 2 digits it should round
down.
It works as designed. I am sorry.
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127477] Zero is not Zero
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127477
--- Comment #4 from hshaw@pobox.com ---
(In reply to Peter from comment #3)
> You are sure?
> Maybe I am sleepy, midnight here, but I read your formula points to d15
> which results exactly to 0. :)
I think you misread what I wrote. Look at the screenshot.
D16 SHOULD be 0.
Instead it is -4.5475E-013
In E16, I entered the same formula as D16, just used parentheses to change the
order of the addition. That comes out as 0.
The whole spreadsheet uses only numbers with at most 2 decimal points. How did
-4.5475E-013 get introduced?
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127477] Zero is not Zero
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127477
Marcus <ma...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Severity|Major |Normal
Status|RESOLVED |CLOSED
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127477] Zero is not Zero
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127477
hshaw@pobox.com changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |hshaw@pobox.com
--- Comment #2 from hshaw@pobox.com ---
Created attachment 86178
--> https://bz.apache.org/ooo/attachment.cgi?id=86178&action=edit
screenshot showing that zero is not zero
I added a screenshot showing the issue, in case spreadsheet does not show
problem on your system.
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127477] Zero is not Zero
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127477
Peter <le...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |leginee@gmail.com
--- Comment #3 from Peter <le...@gmail.com> ---
You are sure?
Maybe I am sleepy, midnight here, but I read your formula points to d15 which
results exactly to 0. :)
--
You are receiving this mail because:
You are the assignee for the issue.