https://bz.apache.org/ooo/show_bug.cgi?id=126992
Issue ID: 126992
Issue Type: DEFECT
Summary: Function ABS returning wrong result
Product: Calc
Version: 4.1.2
Hardware: PC
OS: Windows 7
Status: UNCONFIRMED
Severity: Major
Priority: P5 (lowest)
Component: programming
Assignee: [email protected]
Reporter: [email protected]
In cell A1 put 4000.93
In cell A2 put 4000.94
In cell A3 put =IF(ABS(A1-A2)<=0.01)
You get FALSE while it should be TRUE.
The bug seems to be related to the float representation of numbers because, for
instance, using 4000.03 and 4000.04 you get the correct answer (TRUE).
(note: I made tests with Openoffice italian version, using italian formulas -
IF=SE, ABS=ASS)
--
You are receiving this mail because:
You are the assignee for the issue.
