DV-0009

excel: function not implemented — DETECTLANGUAGE, EPOCHTODATE, GOOGLEFINANCE (+8 more)

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

Subjects (11)

DETECTLANGUAGE EPOCHTODATE GOOGLEFINANCE GOOGLETRANSLATE ISEMAIL SPARKLINE TO_DATE TO_DOLLARS TO_PERCENT TO_PURE_NUMBER TO_TEXT

Tests (37)

matches canonical diverges no fixture in this DV's cluster

Test	Formula	Canonical	gsheets	excel	lattice	ironcalc	hyperformula	libreoffice	formulas	pycel
`EPOCHTODATE/epochtodate-seconds`	`=EPOCHTODATE(1700000000, 1)`	45244.9	gsheets[object Object]	excel[object Object]	lattice45244.9	ironcalc#NAME?	hyperformula#NAME?	libreoffice—	formulas#NAME?	pycel#NAME?
`EPOCHTODATE/epochtodate-millis`	`=EPOCHTODATE(1700000000000, 2)`	45244.9	gsheets[object Object]	excel[object Object]	lattice45244.9	ironcalc#NAME?	hyperformula#NAME?	libreoffice—	formulas#NAME?	pycel#NAME?
`EPOCHTODATE/epochtodate-default-unit`	`=EPOCHTODATE(1700000000)`	45244.9	gsheets[object Object]	excel[object Object]	lattice45244.9	ironcalc#NAME?	hyperformula#NAME?	libreoffice—	formulas#NAME?	pycel#NAME?
`GOOGLEFINANCE/googlefinance-price-smoke`	`=GOOGLEFINANCE("GOOG", "price")`	—	gsheets[object Object]	excel[object Object]	lattice#NAME?	ironcalc#NAME?	hyperformula#NAME?	libreoffice—	formulas#NAME?	pycel#NAME?
`GOOGLETRANSLATE/googletranslate-en-to-es`	`=GOOGLETRANSLATE("hello", "en", "es")`	Hola	gsheets[object Object]	excel[object Object]	lattice#NAME?	ironcalc#NAME?	hyperformula#NAME?	libreoffice—	formulas#NAME?	pycel#NAME?
`DETECTLANGUAGE/detectlanguage-english`	`=DETECTLANGUAGE("hello world")`	en	gsheets[object Object]	excel[object Object]	lattice#NAME?	ironcalc#NAME?	hyperformula#NAME?	libreoffice—	formulas#NAME?	pycel#NAME?
`SPARKLINE/sparkline-inline-chart`	`=SPARKLINE({1;2;3;4;5})`	—	gsheets[object Object]	excel[object Object]	lattice#NAME?	ironcalc#NAME?	hyperformula#NAME?	libreoffice—	formulas#NAME?	pycel#NAME?
`ISEMAIL/isemail-valid`	`=ISEMAIL("user@example.com")`	true	gsheets[object Object]	excel[object Object]	latticetrue	ironcalc#NAME?	hyperformula#NAME?	libreoffice—	formulas#NAME?	pycel#NAME?
`ISEMAIL/isemail-invalid`	`=ISEMAIL("not-an-email")`	false	gsheets[object Object]	excel[object Object]	latticefalse	ironcalc#NAME?	hyperformula#NAME?	libreoffice—	formulas#NAME?	pycel#NAME?
`ISEMAIL/isemail-of-number`	`=ISEMAIL(42)`	false	gsheets[object Object]	excel[object Object]	latticefalse	ironcalc#NAME?	hyperformula#NAME?	libreoffice—	formulas#NAME?	pycel#NAME?
`ISEMAIL/isemail-of-blank-cell`	`=ISEMAIL(A1)`	false	gsheets[object Object]	excel[object Object]	latticefalse	ironcalc#NAME?	hyperformula#NAME?	libreoffice—	formulas#NAME?	pycel#NAME?
`TO_DATE/to-date-from-serial`	`=TO_DATE(44000)`	44000	gsheets[object Object]	excel[object Object]	lattice44000	ironcalc#NAME?	hyperformula#NAME?	libreoffice—	formulas#NAME?	pycel#NAME?
`TO_DATE/to-date-zero-serial`	`=TO_DATE(0)`	0	gsheets[object Object]	excel[object Object]	lattice0	ironcalc#NAME?	hyperformula#NAME?	libreoffice—	formulas#NAME?	pycel#NAME?
`TO_DATE/to-date-from-text`	`=TO_DATE("2024-01-15")`	2024-01-15	gsheets[object Object]	excel[object Object]	lattice2024-01-15	ironcalc#NAME?	hyperformula#NAME?	libreoffice—	formulas#NAME?	pycel#NAME?
`TO_DATE/to-date-from-boolean`	`=TO_DATE(TRUE)`	true	gsheets[object Object]	excel[object Object]	latticetrue	ironcalc#NAME?	hyperformula#NAME?	libreoffice—	formulas#NAME?	pycel#NAME?
`TO_DATE/to-date-from-invalid-text`	`=TO_DATE("not-a-date")`	not-a-date	gsheets[object Object]	excel[object Object]	latticenot-a-date	ironcalc#NAME?	hyperformula#NAME?	libreoffice—	formulas#NAME?	pycel#NAME?
`TO_DOLLARS/to-dollars-integer`	`=TO_DOLLARS(1234)`	1234	gsheets[object Object]	excel[object Object]	lattice1234	ironcalc#NAME?	hyperformula#NAME?	libreoffice—	formulas#NAME?	pycel#NAME?
`TO_DOLLARS/to-dollars-decimal`	`=TO_DOLLARS(1234.567)`	1234.567	gsheets[object Object]	excel[object Object]	lattice1234.567	ironcalc#NAME?	hyperformula#NAME?	libreoffice—	formulas#NAME?	pycel#NAME?
`TO_DOLLARS/to-dollars-negative`	`=TO_DOLLARS(-42.5)`	-42.5	gsheets[object Object]	excel[object Object]	lattice-42.5	ironcalc#NAME?	hyperformula#NAME?	libreoffice—	formulas#NAME?	pycel#NAME?
`TO_DOLLARS/to-dollars-from-text`	`=TO_DOLLARS("99.99")`	99.99	gsheets[object Object]	excel[object Object]	lattice99.99	ironcalc#NAME?	hyperformula#NAME?	libreoffice—	formulas#NAME?	pycel#NAME?
`TO_DOLLARS/to-dollars-from-boolean`	`=TO_DOLLARS(TRUE)`	true	gsheets[object Object]	excel[object Object]	latticetrue	ironcalc#NAME?	hyperformula#NAME?	libreoffice—	formulas#NAME?	pycel#NAME?
`TO_PERCENT/to-percent-decimal`	`=TO_PERCENT(0.25)`	0.25	gsheets[object Object]	excel[object Object]	lattice0.25	ironcalc#NAME?	hyperformula#NAME?	libreoffice—	formulas#NAME?	pycel#NAME?
`TO_PERCENT/to-percent-whole-number`	`=TO_PERCENT(1)`	1	gsheets[object Object]	excel[object Object]	lattice1	ironcalc#NAME?	hyperformula#NAME?	libreoffice—	formulas#NAME?	pycel#NAME?
`TO_PERCENT/to-percent-zero`	`=TO_PERCENT(0)`	0	gsheets[object Object]	excel[object Object]	lattice0	ironcalc#NAME?	hyperformula#NAME?	libreoffice—	formulas#NAME?	pycel#NAME?
`TO_PERCENT/to-percent-from-text`	`=TO_PERCENT("0.5")`	0.5	gsheets[object Object]	excel[object Object]	lattice0.5	ironcalc#NAME?	hyperformula#NAME?	libreoffice—	formulas#NAME?	pycel#NAME?
`TO_PERCENT/to-percent-negative`	`=TO_PERCENT(-0.1)`	-0.1	gsheets[object Object]	excel[object Object]	lattice-0.1	ironcalc#NAME?	hyperformula#NAME?	libreoffice—	formulas#NAME?	pycel#NAME?
`TO_PURE_NUMBER/to-pure-number-from-percent-literal`	`=TO_PURE_NUMBER(0.25)`	0.25	gsheets[object Object]	excel[object Object]	lattice0.25	ironcalc#NAME?	hyperformula#NAME?	libreoffice—	formulas#NAME?	pycel#NAME?
`TO_PURE_NUMBER/to-pure-number-from-integer`	`=TO_PURE_NUMBER(42)`	42	gsheets[object Object]	excel[object Object]	lattice42	ironcalc#NAME?	hyperformula#NAME?	libreoffice—	formulas#NAME?	pycel#NAME?
`TO_PURE_NUMBER/to-pure-number-from-text`	`=TO_PURE_NUMBER("123.45")`	123.45	gsheets[object Object]	excel[object Object]	lattice123.45	ironcalc#NAME?	hyperformula#NAME?	libreoffice—	formulas#NAME?	pycel#NAME?
`TO_PURE_NUMBER/to-pure-number-from-boolean`	`=TO_PURE_NUMBER(TRUE)`	true	gsheets[object Object]	excel[object Object]	latticetrue	ironcalc#NAME?	hyperformula#NAME?	libreoffice—	formulas#NAME?	pycel#NAME?
`TO_PURE_NUMBER/to-pure-number-from-non-numeric-text`	`=TO_PURE_NUMBER("hello")`	hello	gsheets[object Object]	excel[object Object]	latticehello	ironcalc#NAME?	hyperformula#NAME?	libreoffice—	formulas#NAME?	pycel#NAME?
`TO_TEXT/to-text-integer`	`=TO_TEXT(42)`	42	gsheets[object Object]	excel[object Object]	lattice42	ironcalc#NAME?	hyperformula#NAME?	libreoffice—	formulas#NAME?	pycel#NAME?
`TO_TEXT/to-text-decimal`	`=TO_TEXT(3.14159)`	3.14159	gsheets[object Object]	excel[object Object]	lattice3.14159	ironcalc#NAME?	hyperformula#NAME?	libreoffice—	formulas#NAME?	pycel#NAME?
`TO_TEXT/to-text-boolean`	`=TO_TEXT(TRUE)`	TRUE	gsheets[object Object]	excel[object Object]	latticeTRUE	ironcalc#NAME?	hyperformula#NAME?	libreoffice—	formulas#NAME?	pycel#NAME?
`TO_TEXT/to-text-already-text`	`=TO_TEXT("hello")`	hello	gsheets[object Object]	excel[object Object]	latticehello	ironcalc#NAME?	hyperformula#NAME?	libreoffice—	formulas#NAME?	pycel#NAME?
`TO_TEXT/to-text-from-date-serial`	`=TO_TEXT(A1)`	1/15/2024	gsheets[object Object]	excel[object Object]	lattice1/15/2024	ironcalc#NAME?	hyperformula#NAME?	libreoffice—	formulas#NAME?	pycel#NAME?
`TO_TEXT/to-text-negative-number`	`=TO_TEXT(-1234.5)`	-1234.5	gsheets[object Object]	excel[object Object]	lattice-1234.5	ironcalc#NAME?	hyperformula#NAME?	libreoffice—	formulas#NAME?	pycel#NAME?