https://bz.apache.org/bugzilla/show_bug.cgi?id=65907
Bug ID: 65907
Summary: implementation of SUMPRODUCT function cannot handle
case where operators appear between ranges
Product: POI
Version: 5.2.0-FINAL
Hardware: All
OS: All
Status: NEW
Severity: normal
Priority: P2
Component: SS Common
Assignee: [email protected]
Reporter: [email protected]
Target Milestone: ---
https://support.microsoft.com/en-us/office/sumproduct-function-16753e75-9f68-4874-94ac-4d2145a2fd2e
-- current code does not support example 3 (it does support example 1 though)
SUMPRODUCT((B2:B9=B12)*(C2:C9=C12)*D2:D9)
the current function evaluator tries to apply the multiplies before the
SUMPRODUCT function implementation is called
Leads to an exception like:
java.lang.RuntimeException: Invalid arg type for SUMPRODUCT:
(org.apache.poi.ss.formula.eval.ErrorEval)
at
org.apache.poi.ss.formula.functions.Sumproduct.evaluate(Sumproduct.java:85)
--
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]
