Unplanned
Last Updated: 14 Jul 2020 07:25 by Naveen
Naveen
Created on: 14 Jul 2020 07:25
Category: Spreadsheet
Type: Bug Report
2
AND formula, when used as part of an array formula, does not evaluate the whole array

Bug report

The AND formula, when used as part of an array formula, does not evaluate the whole array.

{=AND(A1:D1="")} would return TRUE if a value is entered in the range B1:D1 and FALSE only if value is entered in A1
=IF(AND(A1="",B1="",C1="",D1=""),TRUE,FALSE) would return FALSE if value is entered in any cell in range A1:D1

Reproduction of the problem

  1. Run this dojo
  2. Select cell E1, press F2 to edit formula and press Ctrl+Shift+Enter to enter as an array formula

Current behavior

  1. Enter a value in cell B1 - Array formula evaluates as TRUE, Non-array formula as FALSE
  2. Only if a value is entered in A1 the Array formula will evaluate as FALSE

Expected/desired behavior

Array formula should be evaluated correctly and return FALSE when a value is entered in any cell in range A1:D1.

Environment

  • Kendo UI version: 2020.2.617
  • Browser: [all]
0 comments