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 |
|---|---|---|---|---|---|---|---|---|---|---|
external/e8510f |
=ARRAYFORMULA({1;2;3} * 2) |
[2, 4, 6] | gsheets[2, 4, 6] | excel#N/A | lattice[2, 4, 6] | ironcalc#NAME? | hyperformula[2, 4, 6] | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
external/8b988c |
=ARRAYFORMULA({"a";"b"} & "!") |
[a!, b!] | gsheets[a!, b!] | excel#N/A | lattice[a!, b!] | ironcalc#NAME? | hyperformula[a!, b!] | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
text-longtail/9006fb |
=SPLIT("a,b,c", ",") |
[a, b, c] | gsheets[a, b, c] | excel#N/A | lattice[a, b, c] | ironcalc#NAME? | hyperformula#VALUE! | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
text-longtail/4d1bcd |
=SPLIT("a-b_c", "-_") |
[a, b, c] | gsheets[a, b, c] | excel#N/A | lattice[a, b, c] | ironcalc#NAME? | hyperformula#VALUE! | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
text-longtail/0a0a13 |
=SPLIT("hello", ",") |
hello | gsheetshello | excel#N/A | latticehello | ironcalc#NAME? | hyperformula#VALUE! | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
text-longtail/669bc2 |
=SPLIT("a,,b", ",", TRUE, FALSE) |
[a, , b] | gsheets[a, , b] | excel#N/A | lattice[a, , b] | ironcalc#NAME? | hyperformula#N/A | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |