https://bz.apache.org/bugzilla/show_bug.cgi?id=60848
Bug ID: 60848
Summary: SUMPRODUCT fails when first arg is of form --(...)
Product: POI
Version: 3.15-FINAL
Hardware: All
OS: All
Status: NEW
Severity: normal
Priority: P2
Component: SS Common
Assignee: dev@poi.apache.org
Reporter: mewa...@gmail.com
Target Milestone: ---
The following formula works fine in POI (using version 3.15):
=SUMPRODUCT(X17:X1048576,--(O17:O1048576>=30))
However, reversing the order of the args, it fails with "Invalid arg type
for SUMPRODUCT: (org.apache.poi.ss.formula.eval.ErrorEval)":
=SUMPRODUCT(--(O17:O1048576>=30),X17:X1048576)
Either way works fine in Excel.
Also described at https://lists.apache.org/list.html?dev@poi.apache.org:2017-03
--
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
