Last Updated:
19 Sep 2023 10:32
by ADMIN
SpreadProcessing: DataValidation is incorrect when the same rule is applied on multiple ranges
If the same rule, which uses a formula, is applied on more than one range the result data validation is incorrect, because the formula is translated wrong. E.g. if a custom rule with a formula =IsNumber(A1) is applied on A1:C6 and F1:F6, the rule for cell A1 would be =IsNumber(F1) instead of IsNumber(A1)