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 2021/01/05 11:07:52 UTC
[Bug 65059] New: wrong evaluation of SUMPRODUCT when nested SUMIFS
use ranges
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.duong@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-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 65059] wrong evaluation of SUMPRODUCT when nested SUMIFS use
ranges
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=65059
gerard.duong@externe.bnpparibas.com changed:
What |Removed |Added
----------------------------------------------------------------------------
Attachment #37689|0 |1
is obsolete| |
--- Comment #4 from gerard.duong@externe.bnpparibas.com ---
Created attachment 37715
--> https://bz.apache.org/bugzilla/attachment.cgi?id=37715&action=edit
simplified test case for bug reproduction
New test case to focus on pure formula evaluation.
--
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
[Bug 65059] wrong evaluation of SUMPRODUCT when nested SUMIFS use
ranges
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=65059
Bug 65059 depends on bug 65058, which changed state.
Bug 65058 Summary: SUMPRODUCT evaluation error with some SUMIFS cases
https://bz.apache.org/bugzilla/show_bug.cgi?id=65058
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution|--- |INFORMATIONPROVIDED
--
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
[Bug 65059] wrong evaluation of SUMPRODUCT when nested SUMIFS use
ranges
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=65059
gerard.duong@externe.bnpparibas.com changed:
What |Removed |Added
----------------------------------------------------------------------------
Component|XSSF |SS Common
--
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
[Bug 65059] wrong evaluation of SUMPRODUCT when nested SUMIFS use
ranges
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=65059
Dominik Stadler <do...@gmx.at> changed:
What |Removed |Added
----------------------------------------------------------------------------
OS| |All
--
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
[Bug 65059] wrong evaluation of SUMPRODUCT when nested SUMIFS use
ranges
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=65059
Dominik Stadler <do...@gmx.at> changed:
What |Removed |Added
----------------------------------------------------------------------------
Depends on| |65058
--- Comment #2 from Dominik Stadler <do...@gmx.at> ---
Is there a difference to this bug-report to bug #65058?
Referenced Bugs:
https://bz.apache.org/bugzilla/show_bug.cgi?id=65058
[Bug 65058] SUMPRODUCT evaluation error with some SUMIFS cases
--
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
[Bug 65059] wrong evaluation of SUMPRODUCT when nested SUMIFS use
ranges
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=65059
--- Comment #3 from gerard.duong@externe.bnpparibas.com ---
Yes.
The bug #65058 is about an error occuring with some parameter management. It
seems that this happens when a criteria range is starting at a different column
*and* row from the initial formula.
This bug is more about the evaluation providing wrong results when we avoid the
above parameters. Having done some more analysis, I have noticed that SUMIFS
evaluations are not providing an array result when some criteria are
multi-valued.
--
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
[Bug 65059] wrong evaluation of SUMPRODUCT when nested SUMIFS use
ranges
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=65059
Dominik Stadler <do...@gmx.at> changed:
What |Removed |Added
----------------------------------------------------------------------------
Blocks| |65231
Referenced Bugs:
https://bz.apache.org/bugzilla/show_bug.cgi?id=65231
[Bug 65231] wrong evaluation of SUMPRODUCT when nested COUNTIF uses ranges
--
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
[Bug 65059] wrong evaluation of SUMPRODUCT when nested SUMIFS use
ranges
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=65059
--- Comment #1 from gerard.duong@externe.bnpparibas.com ---
Created attachment 37690
--> https://bz.apache.org/bugzilla/attachment.cgi?id=37690&action=edit
expected output if workbook written on file system
--
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