DV-0019

excel: different error code — ARRAYFORMULA, ISDATE, JOIN (+3 more)

Cause
error-code
Category
value
Diverging engines
excel
Behavior signature
{"error":"#N/A"}
Test count
15
Seeded
2026-04-25
Last confirmed
2026-04-25

Subjects (6)

ARRAYFORMULA ISDATE JOIN QUERY SINGLE SPLIT

Tests (15)

matches canonical diverges no fixture in this DV's cluster

Test Formula Canonical gsheets excel lattice ironcalc hyperformula libreoffice formulas pycel
broadcasting/2143d9 =SINGLE({10,20,30}) 10 gsheets10 excel#N/A lattice10 ironcalc#NAME? hyperformula#NAME? libreoffice#NAME? formulas10 pycel#NAME?
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?
external/c94b38 =QUERY({1,"a";2,"b";3,"c"}, "select *") #NAME? gsheets[3×2] excel#N/A lattice#NAME? ironcalc#NAME? hyperformula#NAME? libreoffice#NAME? formulas#NAME? pycel#NAME?
external/1c884b =QUERY({1,"a";2,"b";3,"c"}, "select Col2") #NAME? gsheets[a, b, c] excel#N/A lattice#NAME? ironcalc#NAME? hyperformula#NAME? libreoffice#NAME? formulas#NAME? pycel#NAME?
info/f67c20 =ISDATE(42) false gsheetsfalse excel#N/A latticefalse ironcalc#NAME? hyperformula#NAME? libreoffice#NAME? formulas#NAME? pycel#NAME?
info/78c5b1 =ISDATE("hello") false gsheetsfalse excel#N/A latticefalse ironcalc#NAME? hyperformula#NAME? libreoffice#NAME? formulas#NAME? pycel#NAME?
info/373619 =ISDATE(DATE(2024,1,15)) true gsheetstrue excel#N/A latticetrue ironcalc#NAME? hyperformula#NAME? libreoffice#NAME? formulas#NAME? pycel#NAME?
text-longtail/8632a3 =JOIN("-", {"a","b","c"}) a-b-c gsheetsa-b-c excel#N/A latticea-b-c ironcalc#NAME? hyperformula#NAME? libreoffice#NAME? formulas#NAME? pycel#NAME?
text-longtail/498f7c =JOIN(",", {1,2,3}) 1,2,3 gsheets1,2,3 excel#N/A lattice1,2,3 ironcalc#NAME? hyperformula#NAME? libreoffice#NAME? formulas#NAME? pycel#NAME?
text-longtail/ab8f6f =JOIN("", {"a","b","c"}) abc gsheetsabc excel#N/A latticeabc ironcalc#NAME? hyperformula#NAME? libreoffice#NAME? formulas#NAME? pycel#NAME?
text-longtail/e5def8 =JOIN("-", {"solo"}) solo gsheetssolo excel#N/A latticesolo ironcalc#NAME? hyperformula#NAME? 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?