DV-0254
TODO auto-seeded — excel (error-code) — ARRAYFORMULA, QUERY
Subjects (2)
Tests (3)
matches canonical diverges no fixture in this DV's cluster
| Test | Formula | Canonical | gsheets | excel | lattice | ironcalc | hyperformula | libreoffice | formulas | pycel |
|---|---|---|---|---|---|---|---|---|---|---|
ARRAYFORMULA/arrayformula-multiply-range |
=ARRAYFORMULA({1;2;3} * 2) |
{2; 4; 6} | gsheets{2; 4; 6} | excel#NAME? | lattice{2; 4; 6} | ironcalc#NAME? | hyperformula{2; 4; 6} | libreoffice— | formulas#NAME? | pycel#NAME? |
ARRAYFORMULA/arrayformula-text-concat |
=ARRAYFORMULA({"a";"b"} & "!") |
{a!; b!} | gsheets{a!; b!} | excel#NAME? | lattice{a!; b!} | ironcalc#NAME? | hyperformula{a!; b!} | libreoffice— | formulas#NAME? | pycel#NAME? |
QUERY/query-offset-1 |
=QUERY({0,0;1,2;3,4}, "offset 1") |
{1, 2; 3, 4} | gsheets{1, 2; 3, 4} | excel#NAME? | lattice{1, 2; 3, 4} | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |