assay

DV-0029

formulas, ironcalc, libreoffice, pycel: function not implemented — ARRAYFORMULA, SPLIT

Cause
missing-function
Category
value
Diverging engines
formulasironcalclibreofficepycel
Behavior signature
{"error":"#NAME?"}
Test count
6
Seeded
2026-04-25
Last confirmed
2026-04-25

Subjects (2)

ARRAYFORMULA SPLIT

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{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?
SPLIT/split-comma =SPLIT("a,b,c", ",") {a, b, c} gsheets{a, b, c} 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{a, b, c} excel— lattice{a, b, c} ironcalc#NAME? hyperformula#VALUE! libreoffice— formulas#NAME? pycel#NAME?
SPLIT/split-single-token =SPLIT("hello", ",") hello gsheetshello excel— latticehello ironcalc#NAME? hyperformula#VALUE! libreoffice— formulas#NAME? pycel#NAME?
SPLIT/split-empty-tokens =SPLIT("a,,b", ",", TRUE, FALSE) {a, , b} gsheets{a, , b} excel— lattice{a, , b} ironcalc#NAME? hyperformula#N/A libreoffice— formulas#NAME? pycel#NAME?