https://bz.apache.org/bugzilla/show_bug.cgi?id=65231
Bug ID: 65231
Summary: wrong evaluation of SUMPRODUCT when nested COUNTIF use
ranges
Product: POI
Version: 4.1.2-FINAL
Hardware: All
OS: All
Status: NEW
Severity: normal
Priority: P2
Component: SS Common
Assignee: [email protected]
Reporter: [email protected]
Target Milestone: ---
Created attachment 37804
--> https://bz.apache.org/bugzilla/attachment.cgi?id=37804&action=edit
test case for reproduction
I'm managing an XSSF workbook within which I have a formula cell with a COUNTIF
inside a SUMPRODUCT. But its evaluation gives a bad result: it is different
from Excel of Office 365.
The nested COUNTIF uses ranges as criteria. For example:
SUMPRODUCT(COUNTIF(B1:B3, C1:C3))
The evaluation is done via FormulaEvaluator.evaluate(Cell).
I'm providing a test case for more details.
This bug is similar to 65059, but I'm not sure if it is really a duplicate: My
work-in-progress fixes of the 65059 do not apply to this bug.
--
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]
