poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 60848] New: SUMPRODUCT fails when first arg is of form --(...)
Date Sun, 12 Mar 2017 18:33:59 GMT
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: mewalig@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-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


Mime
View raw message