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
https://issues.apache.org/bugzilla/show_bug.cgi?id=56655

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
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


Mime
View raw message