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.

Reply via email to