DV-0015

hyperformula, libreoffice: function not implemented — CONCAT, IFS, XOR

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

Subjects (3)

Tests (17)

matches canonical diverges no fixture in this DV's cluster

Test	Formula	Canonical	gsheets	excel	lattice	ironcalc	hyperformula	libreoffice	formulas	pycel
`divergences/15880e`	`=CONCAT("a", "b", "c")`	abc	gsheets#N/A	excelabc	latticeabc	ironcalcabc	hyperformula#NAME?	libreoffice#NAME?	formulasabc	pycelabc
`logical/1e40de`	`=XOR(TRUE, TRUE, TRUE)`	true	gsheetstrue	exceltrue	latticetrue	ironcalctrue	hyperformula#NAME?	libreoffice#NAME?	formulastrue	pycel1
`logical/06fb8b`	`=XOR(TRUE, TRUE)`	false	gsheetsfalse	excelfalse	latticefalse	ironcalcfalse	hyperformula#NAME?	libreoffice#NAME?	formulasfalse	pycel0
`logical/608087`	`=XOR(FALSE, FALSE)`	false	gsheetsfalse	excelfalse	latticefalse	ironcalcfalse	hyperformula#NAME?	libreoffice#NAME?	formulasfalse	pycel0
`logical/da13f1`	`=IFS(TRUE, "a", TRUE, "b")`	a	gsheetsa	excela	latticea	ironcalca	hyperformula#NAME?	libreoffice#NAME?	formulasa	pycela
`logical/833378`	`=IFS(FALSE, "a", TRUE, "b")`	b	gsheetsb	excelb	latticeb	ironcalcb	hyperformula#NAME?	libreoffice#NAME?	formulasb	pycelb
`logical/5de080`	`=IFS(FALSE, "a", FALSE, "b")`	#N/A	gsheets#N/A	excel#N/A	lattice#N/A	ironcalc#N/A	hyperformula#NAME?	libreoffice#NAME?	formulas#N/A	pycel#N/A
`operator/c3302a`	`=CONCAT("hello", " ", "world")`	hello world	gsheets#N/A	excelhello world	latticehello world	ironcalchello world	hyperformula#NAME?	libreoffice#NAME?	formulashello world	pycelhello world
`operator/f319fc`	`=CONCAT("foo", "bar")`	foobar	gsheetsfoobar	excelfoobar	latticefoobar	ironcalcfoobar	hyperformula#NAME?	libreoffice#NAME?	formulasfoobar	pycelfoobar
`operator/0a2660`	`=CONCAT(1, 2)`	12	gsheets12	excel12	lattice12	ironcalc12	hyperformula#NAME?	libreoffice#NAME?	formulas12	pycel12
`operator/5ef694`	`=CONCAT("x=", 42)`	x=42	gsheetsx=42	excelx=42	latticex=42	ironcalcx=42	hyperformula#NAME?	libreoffice#NAME?	formulasx=42	pycelx=42
`operator/5afaaf`	`=CONCAT(TRUE, FALSE)`	TRUEFALSE	gsheetsTRUEFALSE	excelTRUEFALSE	latticeTRUEFALSE	ironcalcTRUEFALSE	hyperformula#NAME?	libreoffice#NAME?	formulasTRUEFALSE	pycelTRUEFALSE
`operator/52041c`	`=CONCAT(1.5, 2.25)`	1.52.25	gsheets1.52.25	excel1.52.25	lattice1.52.25	ironcalc1.52.25	hyperformula#NAME?	libreoffice#NAME?	formulas1.52.25	pycel1.52.25
`operator/172694`	`=CONCAT("", "abc")`	abc	gsheetsabc	excelabc	latticeabc	ironcalcabc	hyperformula#NAME?	libreoffice#NAME?	formulasabc	pycelabc
`operator/296636`	`=CONCAT("a", "b")="a"&"b"`	true	gsheetstrue	exceltrue	latticetrue	ironcalctrue	hyperformula#NAME?	libreoffice#NAME?	formulastrue	pyceltrue
`text/621ba3`	`=CONCAT("hello", " world")`	hello world	gsheetshello world	excelhello world	latticehello world	ironcalchello world	hyperformula#NAME?	libreoffice#NAME?	formulashello world	pycelhello world
`text/2cae7b`	`=CONCAT("value:", 42)`	value:42	gsheetsvalue:42	excelvalue:42	latticevalue:42	ironcalcvalue:42	hyperformula#NAME?	libreoffice#NAME?	formulasvalue:42	pycelvalue:42