You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2014/06/21 22:04:11 UTC

[Bug 56655] New: XSSFFormulaEvaluator wrong result for SUMIFS and #VALUE!

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: dev@poi.apache.org
          Reporter: adek336+asf@gmail.com

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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

[Bug 56655] XSSFFormulaEvaluator wrong result for SUMIFS and #VALUE!

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=56655

Dominik Stadler <do...@gmx.at> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |NEEDINFO

--- Comment #1 from Dominik Stadler <do...@gmx.at> ---
Did some analysis: Sumifs implementation validates the input-ranges, but not
the PredicateMatcher. In this case the PredicateMatcher is ErrorMatcher and
thus does not match anything, but also does not lead to InvalidValue being
reported. 

We should first verify how Excel handles this, i.e. does it report #VALUE! when
the matcher is reporting #VALUE!

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

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

[Bug 56655] XSSFFormulaEvaluator wrong result for SUMIFS and #VALUE!

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=56655

Dominik Stadler <do...@gmx.at> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEEDINFO                    |NEW

--- Comment #2 from Dominik Stadler <do...@gmx.at> ---
Excel reports these as "#VALUE!".

There is now a reproducing unit test in class TestUnfixedXSSFBugs

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

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org