poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 56655] XSSFFormulaEvaluator wrong result for SUMIFS and #VALUE!
Date Wed, 02 Jul 2014 19:47:10 GMT

Dominik Stadler <dominik.stadler@gmx.at> changed:

           What    |Removed                     |Added
             Status|NEW                         |NEEDINFO

--- Comment #1 from Dominik Stadler <dominik.stadler@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

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

View raw message