You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@poi.apache.org by bu...@apache.org on 2023/08/09 07:34:21 UTC

[Bug 65907] implementation of SUMPRODUCT function cannot handle case where operators appear between ranges

https://bz.apache.org/bugzilla/show_bug.cgi?id=65907

--- Comment #3 from RouSi <60...@qq.com> ---
我在E28有一个公式=SUMPRODUCT(($N$6:$N$26="镀锌板")*($M$6:$M$26)),代码在OperandResolver.chooseSingleElementFromAreaInternal(AreaEval
ae,
            int srcCellRow, int
srcCellCol)方法执行中有一个这个判断if(!ae.containsRow(srcCellRow)) {
                throw EvaluationException.invalidValue();
            }导致我公式无法执行报错

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