DV-0010

formulas, hyperformula, ironcalc, lattice, libreoffice, pycel: function not implemented — DETECTLANGUAGE, EPOCHTODATE, GOOGLEFINANCE (+8 more)

Cause
missing-function
Category
value
Diverging engines
formulashyperformulaironcalclatticelibreofficepycel
Behavior signature
{"error":"#NAME?"}
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
date/7c97b9 =EPOCHTODATE(1700000000, 1) 45244.9 gsheets45244.9 excel#N/A lattice#NAME? ironcalc#NAME? hyperformula#NAME? libreoffice#NAME? formulas#NAME? pycel#NAME?
date/57b878 =EPOCHTODATE(1700000000000, 2) 45244.9 gsheets45244.9 excel#N/A lattice#NAME? ironcalc#NAME? hyperformula#NAME? libreoffice#NAME? formulas#NAME? pycel#NAME?
date/788942 =EPOCHTODATE(1700000000) 45244.9 gsheets45244.9 excel#N/A lattice#NAME? ironcalc#NAME? hyperformula#NAME? libreoffice#NAME? formulas#NAME? pycel#NAME?
external/b2be2b =GOOGLEFINANCE("GOOG", "price") 319.21 gsheets319.21 excel#N/A lattice#NAME? ironcalc#NAME? hyperformula#NAME? libreoffice#NAME? formulas#NAME? pycel#NAME?
external/726dd4 =GOOGLETRANSLATE("hello", "en", "es") Hola gsheetsHola excel#N/A lattice#NAME? ironcalc#NAME? hyperformula#NAME? libreoffice#NAME? formulas#NAME? pycel#NAME?
external/86dc5a =DETECTLANGUAGE("hello world") en gsheetsen excel#N/A lattice#NAME? ironcalc#NAME? hyperformula#NAME? libreoffice#NAME? formulas#NAME? pycel#NAME?
external/0180e6 =SPARKLINE({1;2;3;4;5}) — gsheets— excel#N/A lattice#NAME? ironcalc#NAME? hyperformula#NAME? libreoffice#NAME? formulas#NAME? pycel#NAME?
info/c45267 =ISEMAIL("user@example.com") true gsheetstrue excel#N/A lattice#NAME? ironcalc#NAME? hyperformula#NAME? libreoffice#NAME? formulas#NAME? pycel#NAME?
info/5b80a8 =ISEMAIL("not-an-email") false gsheetsfalse excel#N/A lattice#NAME? ironcalc#NAME? hyperformula#NAME? libreoffice#NAME? formulas#NAME? pycel#NAME?
info/436206 =ISEMAIL(42) false gsheetsfalse excel#N/A lattice#NAME? ironcalc#NAME? hyperformula#NAME? libreoffice#NAME? formulas#NAME? pycel#NAME?
info/ae5ba5 =ISEMAIL(A1) false gsheetsfalse excel#N/A lattice#NAME? ironcalc#NAME? hyperformula#NAME? libreoffice#NAME? formulas#NAME? pycel#NAME?
parser/b6afb1 =TO_DATE(44000) 44000 gsheets44000 excel#N/A lattice#NAME? ironcalc#NAME? hyperformula#NAME? libreoffice#NAME? formulas#NAME? pycel#NAME?
parser/559669 =TO_DATE(0) 0 gsheets0 excel#N/A lattice#NAME? ironcalc#NAME? hyperformula#NAME? libreoffice#NAME? formulas#NAME? pycel#NAME?
parser/d9785e =TO_DATE("2024-01-15") 2024-01-15 gsheets2024-01-15 excel#N/A lattice#NAME? ironcalc#NAME? hyperformula#NAME? libreoffice#NAME? formulas#NAME? pycel#NAME?
parser/75dec7 =TO_DATE(TRUE) true gsheetstrue excel#N/A lattice#NAME? ironcalc#NAME? hyperformula#NAME? libreoffice#NAME? formulas#NAME? pycel#NAME?
parser/82780c =TO_DATE("not-a-date") not-a-date gsheetsnot-a-date excel#N/A lattice#NAME? ironcalc#NAME? hyperformula#NAME? libreoffice#NAME? formulas#NAME? pycel#NAME?
parser/020da0 =TO_DOLLARS(1234) 1234 gsheets1234 excel#N/A lattice#NAME? ironcalc#NAME? hyperformula#NAME? libreoffice#NAME? formulas#NAME? pycel#NAME?
parser/43c179 =TO_DOLLARS(1234.567) 1234.567 gsheets1234.567 excel#N/A lattice#NAME? ironcalc#NAME? hyperformula#NAME? libreoffice#NAME? formulas#NAME? pycel#NAME?
parser/ad81c7 =TO_DOLLARS(-42.5) -42.5 gsheets-42.5 excel#N/A lattice#NAME? ironcalc#NAME? hyperformula#NAME? libreoffice#NAME? formulas#NAME? pycel#NAME?
parser/456aa0 =TO_DOLLARS("99.99") 99.99 gsheets99.99 excel#N/A lattice#NAME? ironcalc#NAME? hyperformula#NAME? libreoffice#NAME? formulas#NAME? pycel#NAME?
parser/d1d2b2 =TO_DOLLARS(TRUE) true gsheetstrue excel#N/A lattice#NAME? ironcalc#NAME? hyperformula#NAME? libreoffice#NAME? formulas#NAME? pycel#NAME?
parser/386552 =TO_PERCENT(0.25) 0.25 gsheets0.25 excel#N/A lattice#NAME? ironcalc#NAME? hyperformula#NAME? libreoffice#NAME? formulas#NAME? pycel#NAME?
parser/8d92d1 =TO_PERCENT(1) 1 gsheets1 excel#N/A lattice#NAME? ironcalc#NAME? hyperformula#NAME? libreoffice#NAME? formulas#NAME? pycel#NAME?
parser/a687b5 =TO_PERCENT(0) 0 gsheets0 excel#N/A lattice#NAME? ironcalc#NAME? hyperformula#NAME? libreoffice#NAME? formulas#NAME? pycel#NAME?
parser/1ee896 =TO_PERCENT("0.5") 0.5 gsheets0.5 excel#N/A lattice#NAME? ironcalc#NAME? hyperformula#NAME? libreoffice#NAME? formulas#NAME? pycel#NAME?
parser/e3efd5 =TO_PERCENT(-0.1) -0.1 gsheets-0.1 excel#N/A lattice#NAME? ironcalc#NAME? hyperformula#NAME? libreoffice#NAME? formulas#NAME? pycel#NAME?
parser/cf307f =TO_PURE_NUMBER(0.25) 0.25 gsheets0.25 excel#N/A lattice#NAME? ironcalc#NAME? hyperformula#NAME? libreoffice#NAME? formulas#NAME? pycel#NAME?
parser/3a7578 =TO_PURE_NUMBER(42) 42 gsheets42 excel#N/A lattice#NAME? ironcalc#NAME? hyperformula#NAME? libreoffice#NAME? formulas#NAME? pycel#NAME?
parser/377e5a =TO_PURE_NUMBER("123.45") 123.45 gsheets123.45 excel#N/A lattice#NAME? ironcalc#NAME? hyperformula#NAME? libreoffice#NAME? formulas#NAME? pycel#NAME?
parser/36eab0 =TO_PURE_NUMBER(TRUE) true gsheetstrue excel#N/A lattice#NAME? ironcalc#NAME? hyperformula#NAME? libreoffice#NAME? formulas#NAME? pycel#NAME?
parser/d2159b =TO_PURE_NUMBER("hello") hello gsheetshello excel#N/A lattice#NAME? ironcalc#NAME? hyperformula#NAME? libreoffice#NAME? formulas#NAME? pycel#NAME?
parser/175a5b =TO_TEXT(42) 42 gsheets42 excel#N/A lattice#NAME? ironcalc#NAME? hyperformula#NAME? libreoffice#NAME? formulas#NAME? pycel#NAME?
parser/6d5ac5 =TO_TEXT(3.14159) 3.14159 gsheets3.14159 excel#N/A lattice#NAME? ironcalc#NAME? hyperformula#NAME? libreoffice#NAME? formulas#NAME? pycel#NAME?
parser/b5c613 =TO_TEXT(TRUE) TRUE gsheetsTRUE excel#N/A lattice#NAME? ironcalc#NAME? hyperformula#NAME? libreoffice#NAME? formulas#NAME? pycel#NAME?
parser/609e8b =TO_TEXT("hello") hello gsheetshello excel#N/A lattice#NAME? ironcalc#NAME? hyperformula#NAME? libreoffice#NAME? formulas#NAME? pycel#NAME?
parser/78d5d6 =TO_TEXT(A1) 1/15/2024 gsheets1/15/2024 excel#N/A lattice#NAME? ironcalc#NAME? hyperformula#NAME? libreoffice#NAME? formulas#NAME? pycel#NAME?
parser/5ae574 =TO_TEXT(-1234.5) -1234.5 gsheets-1234.5 excel#N/A lattice#NAME? ironcalc#NAME? hyperformula#NAME? libreoffice#NAME? formulas#NAME? pycel#NAME?