https://issues.apache.org/bugzilla/show_bug.cgi?id=56655

            Bug ID: 56655
           Summary: XSSFFormulaEvaluator wrong result for SUMIFS and
                    #VALUE!
           Product: POI
           Version: 3.10
          Hardware: PC
                OS: Linux
            Status: NEW
          Severity: normal
          Priority: P2
         Component: XSSF
          Assignee: [email protected]
          Reporter: [email protected]

Created attachment 31742
  --> https://issues.apache.org/bugzilla/attachment.cgi?id=31742&action=edit
test case

The following fails on 3.10-FINAL. Attached test case.

A1 := #VALUE!
B1 := SUMIFS(A:A,A:A,#VALUE!)

expected

A1 -> #VALUE!
B1 -> #VALUE!

actual

A1 -> #VALUE!
B1 -> 0

-- 
You are receiving this mail because:
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to