DV-0089
formulas: different argument interpretation — SUMPRODUCT
Subjects (1)
Tests (1)
matches canonical diverges no fixture in this DV's cluster
| Test | Formula | Canonical | gsheets | excel | lattice | ironcalc | hyperformula | libreoffice | formulas | pycel |
|---|---|---|---|---|---|---|---|---|---|---|
SUMPRODUCT/double-unary-coerces-boolean-row-to-numeric |
=SUMPRODUCT(--({1,2,3}>1)) |
2 | gsheets2 | excel2 | lattice2 | ironcalc#NAME? | hyperformula2 | libreoffice— | formulas0 | pycel#NAME? |