https://issues.apache.org/ooo/show_bug.cgi?id=124613
Issue ID: 124613
Issue Type: DEFECT
Summary: IF returning Otherwisevalue when Thenvalue expected
Product: Calc
Version: 4.0.1
Hardware: PC
OS: Windows Vista
Status: UNCONFIRMED
Severity: normal
Priority: P3
Component: code
Assignee: [email protected]
Reporter: [email protected]
Created attachment 83106
--> https://issues.apache.org/ooo/attachment.cgi?id=83106&action=edit
The last line is the IF function.
=IF(I7=I13;"Balanced";I7-I13)
Cells I7 and I13 are apparently equal but the Otherwisevalue is returned and
displayed as 0.00.
This spreadsheet has not exhibited this problem before. Thus I suspect the
data.
When the data in the attachment below was first used the displayed value was
-0.0 (negative zero). After re-keying some data (with the same values as
before), positive zero has been displayed ever afterwards.
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
