https://bz.apache.org/bugzilla/show_bug.cgi?id=65059
Bug ID: 65059
Summary: wrong evaluation of SUMPRODUCT when nested SUMIFS use
ranges
Product: POI
Version: 4.1.2-FINAL
Hardware: PC
Status: NEW
Severity: normal
Priority: P2
Component: XSSF
Assignee: dev@poi.apache.org
Reporter: gerard.du...@externe.bnpparibas.com
Target Milestone: ---
Created attachment 37689
--> https://bz.apache.org/bugzilla/attachment.cgi?id=37689&action=edit
test case for reproduction
I'm managing an XFFS workflow within which I have a formula cell with a SUMIFS
nside a SUMPRODUCT. But its evaluation give a bad result: it is different from
Excel of Office 365.
The nested SUMIFS uses ranges as criteria. For example:
SUMPRODUCT(SUMIFS(B1:B3, C1:C3, D1:D3))
The evaluation is done via FormulaEvaluator.evaluateAll().
I'm providing a test case for more details.
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org
