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 Fri, 21 Apr 2017 21:43:21 GMT
https://bz.apache.org/bugzilla/show_bug.cgi?id=60848

--- Comment #10 from mewalig@gmail.com ---
the plot thickens.

Using the below example, when cell A3 is changed to be:
    =SUMPRODUCT(--(B4:B6))

then, as before, evaluation of that throws an error.

However, when cell A3 contains
    =SUMPRODUCT(--(B3:B5))

then, unlike before, no error is thrown, but the resulting value is not correct
and only appears to consider the cell B3.

Not sure if this indicates two separate issues that need to be fixed, but it
seems odd that one throws an error and the other does not just by moving the
referenced range up or down a row.

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