Bug 65059 - wrong evaluation of SUMPRODUCT when nested SUMIFS use ranges
Summary: wrong evaluation of SUMPRODUCT when nested SUMIFS use ranges
Status: NEW
Alias: None
Product: POI
Classification: Unclassified
Component: XSSF (show other bugs)
Version: 4.1.2-FINAL
Hardware: PC All
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on: 65058
Blocks:
  Show dependency tree
 
Reported: 2021-01-05 11:07 UTC by gerard.duong
Modified: 2021-01-23 13:13 UTC (History)
0 users


Attachments
test case for reproduction (1.77 KB, text/plain)
2021-01-05 11:07 UTC, gerard.duong 		Details
expected output if workbook written on file system (10.18 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2021-01-05 11:08 UTC, gerard.duong 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description gerard.duong 2021-01-05 11:07:52 UTC 
Created attachment 37689 [details]
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.
Comment 1 gerard.duong 2021-01-05 11:08:49 UTC 
Created attachment 37690 [details]
expected output if workbook written on file system
Comment 2 Dominik Stadler 2021-01-23 13:13:46 UTC 
Is there a difference to this bug-report to bug #65058?