https://bz.apache.org/ooo/show_bug.cgi?id=126758
Issue ID: 126758
Issue Type: DEFECT
Summary: CURRENT() only evaluates first occurrence
Product: Calc
Version: 4.1.1
Hardware: Mac
OS: Mac OS X 10.10
Status: UNCONFIRMED
Severity: Blocker
Priority: P5 (lowest)
Component: ui
Assignee: [email protected]
Reporter: [email protected]
The CURRENT() function seems to only evaluate the first occurrence.
EX:
enter the following in a cell:
=0.5+IF(AND(NOT(CURRENT()>=1);NOT(CURRENT()>=1);NOT(CURRENT()>=1);1;0))
Evaluates to .5 rather than 1.5
EX2:
=0.5+IF(OR(CURRENT()>=0.1;CURRENT()>=1;CURRENT()>= 1);1;0)
Correctly Evaluates to 1.5
=0.5+IF(OR(CURRENT()>=1;CURRENT()>=0.1;CURRENT()>= 1);1;0)
Evaluates to .5
=0.5+IF(OR(CURRENT()>=1;CURRENT()>=1;CURRENT()>= 0.1);1;0)
Evaluates to .5
--
You are receiving this mail because:
You are the assignee for the issue.