[Issue 125978] Result of (114,48-112,49) is not 1,99 but 1,99000000000001000000

[bu...@apache.org]

https://issues.apache.org/ooo/show_bug.cgi?id=125978

--- Comment #1 from Boudewijn OVERGAAUW <b....@isisia.fr> ---
The sum of the numbers 114,48 and -112,49 is systematically
1,99000000000001000000 instead of 1,99. To see this error, one may have to
change the cell format to show the appropriate amount of decimals.

The issue occurs when entering "=114,48-112,49" in a cell, as well as when
adding the contents of two cells containing the values 114,48 and -112,49

Checked with:

OpenOffice 4.0.1 under Windows 7
OpenOffice 4.1.1 under Windows 7
OpenOffice 4.1.1 under Windows XP

and, for what it is worth:

OpenOffice.org 2.4.1 under openSUSE Linux 10.1

BTW, Excel 2007 under Windows 7 seems to make the same error...

-- 
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.