poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 60848] SUMPRODUCT fails when first arg is of form --(...)
Date Tue, 21 Mar 2017 18:20:50 GMT
https://bz.apache.org/bugzilla/show_bug.cgi?id=60848

--- Comment #6 from mewalig@gmail.com ---
Thank you for the comment

Out of curiosity, why is the processing wrt the first argument different from
that wrt subsequent arguments? Note that if we do:
   =SUMPRODUCT(A5:A20, --(B5:B20))

then even though the problematic argument is still there, it works just be
relegating it to the position of argument 2 instead of argument 1.

Is it possible to take whatever process is being applied to arguments 2+ and
apply that to argument 1?

-- 
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