https://bz.apache.org/bugzilla/show_bug.cgi?id=62904
Yegor Kozlov <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution|--- |FIXED --- Comment #3 from Yegor Kozlov <[email protected]> --- I checked in the fix in r1850646. The fix *improves* support for evaluation of array formulas, but full coverage is a long way ahead. What is included in the fix: 1. support for array arguments in the IF function. In a array context IF is rarely used by its own, it is usually nested in another function like {=MIN(IF(logical_test, values))} as in your example. Tests with MIN and MAX all pass. For SUM I have at least one failing test, but it can be related to another issue. 2. Support for array arguments in logical IS*** functions and unary operators. This makes it possible to evaluate formulas like {=SUM( --ISERROR(E6:E11)) }. Previously IS*** and unary operators evaluated to a scalar and the result was wrong. Please open a new ticket or re-open this one if you find more issues with evaluation of array formulas. Regards, Yegor -- You are receiving this mail because: You are the assignee for the bug. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
