https://bz.apache.org/bugzilla/show_bug.cgi?id=60848
--- Comment #10 from mewa...@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-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org