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
`SINGLE/single-explicit-top-left`	`=SINGLE({10,20,30})`	10	gsheets10	excel10	lattice10	ironcalc#NAME?	hyperformula#NAME?	libreoffice—	formulas10	pycel#NAME?
`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?
`QUERY/query-select-all`	`=QUERY({1,"a";2,"b";3,"c"}, "select *")`	[3×2]	gsheets[3×2]	excel#NAME?	lattice[3×2]	ironcalc#NAME?	hyperformula#NAME?	libreoffice—	formulas#NAME?	pycel#NAME?
`QUERY/query-select-col`	`=QUERY({1,"a";2,"b";3,"c"}, "select Col2")`	{a; b; c}	gsheets{a; b; c}	excel#NAME?	lattice{a; b; c}	ironcalc#NAME?	hyperformula#NAME?	libreoffice—	formulas#NAME?	pycel#NAME?
`ISDATE/isdate-of-number`	`=ISDATE(42)`	false	gsheetsfalse	excel#NAME?	latticefalse	ironcalc#NAME?	hyperformula#NAME?	libreoffice—	formulas#NAME?	pycel#NAME?
`ISDATE/isdate-of-text`	`=ISDATE("hello")`	false	gsheetsfalse	excel#NAME?	latticefalse	ironcalc#NAME?	hyperformula#NAME?	libreoffice—	formulas#NAME?	pycel#NAME?
`ISDATE/isdate-of-date-call`	`=ISDATE(DATE(2024,1,15))`	true	gsheetstrue	excel#NAME?	latticetrue	ironcalc#NAME?	hyperformula#NAME?	libreoffice—	formulas#NAME?	pycel#NAME?
`JOIN/join-basic`	`=JOIN("-", {"a","b","c"})`	a-b-c	gsheetsa-b-c	excel#NAME?	latticea-b-c	ironcalc#NAME?	hyperformula#NAME?	libreoffice—	formulas#NAME?	pycel#NAME?
`JOIN/join-with-numbers`	`=JOIN(",", {1,2,3})`	1,2,3	gsheets1,2,3	excel#NAME?	lattice1,2,3	ironcalc#NAME?	hyperformula#NAME?	libreoffice—	formulas#NAME?	pycel#NAME?
`JOIN/join-empty-delim`	`=JOIN("", {"a","b","c"})`	abc	gsheetsabc	excel#NAME?	latticeabc	ironcalc#NAME?	hyperformula#NAME?	libreoffice—	formulas#NAME?	pycel#NAME?
`JOIN/join-single-element`	`=JOIN("-", {"solo"})`	solo	gsheetssolo	excel#NAME?	latticesolo	ironcalc#NAME?	hyperformula#NAME?	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?