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/07/02 21:47:10 UTC

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

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