`arrayformula-text-concat`

Subject: ARRAYFORMULA
Category: value
Formula: =ARRAYFORMULA({"a";"b"} & "!")
Canonical: {a!; b!}

Owning divergences (3)

DV-0019 excel: different error code — ARRAYFORMULA, ISDATE, JOIN (+3 more)
error-code excel
DV-0029 formulas, ironcalc, libreoffice, pycel: function not implemented — ARRAYFORMULA, SPLIT
missing-function formulasironcalclibreofficepycel
DV-0254 TODO auto-seeded — excel (error-code) — ARRAYFORMULA, QUERY
error-code excel

Per-engine results

matches canonical diverges no fixture

Engine	Verdict	Value
gsheets	match	{a!; b!}
excel	diverge	#NAME?
lattice	match	{a!; b!}
ironcalc	diverge	#NAME?
hyperformula	match	{a!; b!}
libreoffice	diverge	—
formulas	diverge	#NAME?
pycel	diverge	#NAME?