assay

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 gsheets45244.9 excel#NAME? lattice45244.9 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?
EPOCHTODATE/epochtodate-millis =EPOCHTODATE(1700000000000, 2) 45244.9 gsheets45244.9 excel#NAME? lattice45244.9 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?
EPOCHTODATE/epochtodate-default-unit =EPOCHTODATE(1700000000) 45244.9 gsheets45244.9 excel#NAME? lattice45244.9 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?
GOOGLEFINANCE/googlefinance-price-smoke =GOOGLEFINANCE("GOOG", "price") — gsheets397.05 excel#N/A lattice#NAME? ironcalc#NAME? hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?
GOOGLETRANSLATE/googletranslate-en-to-es =GOOGLETRANSLATE("hello", "en", "es") Hola gsheetsHola excel#N/A lattice#NAME? ironcalc#NAME? hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?
DETECTLANGUAGE/detectlanguage-english =DETECTLANGUAGE("hello world") en gsheetsen excel0 lattice#NAME? ironcalc#NAME? hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?
SPARKLINE/sparkline-inline-chart =SPARKLINE({1;2;3;4;5}) — gsheets— excel#N/A lattice#NAME? ironcalc#NAME? hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?
ISEMAIL/isemail-valid =ISEMAIL("[email protected]") true gsheetstrue excel#NAME? latticetrue ironcalc#NAME? hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?
ISEMAIL/isemail-invalid =ISEMAIL("not-an-email") false gsheetsfalse excel#NAME? latticefalse ironcalc#NAME? hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?
ISEMAIL/isemail-of-number =ISEMAIL(42) false gsheetsfalse excel#NAME? latticefalse ironcalc#NAME? hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?
ISEMAIL/isemail-of-blank-cell =ISEMAIL(A1) false gsheetsfalse excel#NAME? latticefalse ironcalc#NAME? hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?
TO_DATE/to-date-from-serial =TO_DATE(44000) 44000 gsheets44000 excel#NAME? lattice44000 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?
TO_DATE/to-date-zero-serial =TO_DATE(0) 0 gsheets0 excel#NAME? lattice0 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?
TO_DATE/to-date-from-text =TO_DATE("2024-01-15") 2024-01-15 gsheets2024-01-15 excel#NAME? lattice2024-01-15 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?
TO_DATE/to-date-from-boolean =TO_DATE(TRUE) true gsheetstrue excel#NAME? 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 gsheetsnot-a-date excel#NAME? latticenot-a-date ironcalc#NAME? hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?
TO_DOLLARS/to-dollars-integer =TO_DOLLARS(1234) 1234 gsheets1234 excel#NAME? lattice1234 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?
TO_DOLLARS/to-dollars-decimal =TO_DOLLARS(1234.567) 1234.567 gsheets1234.567 excel#NAME? lattice1234.567 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?
TO_DOLLARS/to-dollars-negative =TO_DOLLARS(-42.5) -42.5 gsheets-42.5 excel#NAME? lattice-42.5 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?
TO_DOLLARS/to-dollars-from-text =TO_DOLLARS("99.99") 99.99 gsheets99.99 excel#NAME? lattice99.99 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?
TO_DOLLARS/to-dollars-from-boolean =TO_DOLLARS(TRUE) true gsheetstrue excel#NAME? latticetrue ironcalc#NAME? hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?
TO_PERCENT/to-percent-decimal =TO_PERCENT(0.25) 0.25 gsheets0.25 excel#NAME? lattice0.25 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?
TO_PERCENT/to-percent-whole-number =TO_PERCENT(1) 1 gsheets1 excel#NAME? lattice1 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?
TO_PERCENT/to-percent-zero =TO_PERCENT(0) 0 gsheets0 excel#NAME? lattice0 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?
TO_PERCENT/to-percent-from-text =TO_PERCENT("0.5") 0.5 gsheets0.5 excel#NAME? lattice0.5 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?
TO_PERCENT/to-percent-negative =TO_PERCENT(-0.1) -0.1 gsheets-0.1 excel#NAME? 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 gsheets0.25 excel#NAME? lattice0.25 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?
TO_PURE_NUMBER/to-pure-number-from-integer =TO_PURE_NUMBER(42) 42 gsheets42 excel#NAME? 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 gsheets123.45 excel#NAME? lattice123.45 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?
TO_PURE_NUMBER/to-pure-number-from-boolean =TO_PURE_NUMBER(TRUE) true gsheetstrue excel#NAME? 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 gsheetshello excel#NAME? latticehello ironcalc#NAME? hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?
TO_TEXT/to-text-integer =TO_TEXT(42) 42 gsheets42 excel#NAME? lattice42 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?
TO_TEXT/to-text-decimal =TO_TEXT(3.14159) 3.14159 gsheets3.14159 excel#NAME? lattice3.14159 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?
TO_TEXT/to-text-boolean =TO_TEXT(TRUE) TRUE gsheetsTRUE excel#NAME? latticeTRUE ironcalc#NAME? hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?
TO_TEXT/to-text-already-text =TO_TEXT("hello") hello gsheetshello excel#NAME? latticehello ironcalc#NAME? hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?
TO_TEXT/to-text-from-date-serial =TO_TEXT(A1) 1/15/2024 gsheets1/15/2024 excel#NAME? 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-1234.5 excel#NAME? lattice-1234.5 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?