DV-0029
formulas, ironcalc, libreoffice, pycel: function not implemented — ARRAYFORMULA, SPLIT
Subjects (2)
Tests (6)
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{[object Object]; [object Object]; [object Object]} | excel[object Object] | 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{[object Object]; [object Object]} | excel[object Object] | lattice{a!; b!} | ironcalc#NAME? | hyperformula{a!; b!} | libreoffice— | formulas#NAME? | pycel#NAME? |
SPLIT/split-comma |
=SPLIT("a,b,c", ",") |
{a, b, c} | gsheets{[object Object], [object Object], [object Object]} | excel— | lattice{a, b, c} | ironcalc#NAME? | hyperformula#VALUE! | libreoffice— | formulas#NAME? | pycel#NAME? |
SPLIT/split-multi-delim |
=SPLIT("a-b_c", "-_") |
{a, b, c} | gsheets{[object Object], [object Object], [object Object]} | excel— | lattice{a, b, c} | ironcalc#NAME? | hyperformula#VALUE! | libreoffice— | formulas#NAME? | pycel#NAME? |
SPLIT/split-single-token |
=SPLIT("hello", ",") |
hello | gsheets[object Object] | excel— | latticehello | ironcalc#NAME? | hyperformula#VALUE! | libreoffice— | formulas#NAME? | pycel#NAME? |
SPLIT/split-empty-tokens |
=SPLIT("a,,b", ",", TRUE, FALSE) |
{a, , b} | gsheets{[object Object], [object Object], [object Object]} | excel— | lattice— | ironcalc— | hyperformula— | libreoffice— | formulas— | pycel— |