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? |