poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From MA LIG <mewa...@gmail.com>
Subject sumproduct bug (arg order) in POI formula eval
Date Sun, 12 Mar 2017 06:33:33 GMT
 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)

I have an interest, but not the coding chops myself, to see this fixed
quickly. It seems like it should be easy since it already works for f(x,y)
and just needs to work for f(y,x). I may be able to scrounge up some $ for
this, if that helps. Any suggestions on how I might prod this to a quick
resolution?

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message