DV-0024

formulas, hyperformula, ironcalc, libreoffice, pycel: function not implemented — ISDATE, JOIN

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

Subjects (2)

ISDATE JOIN

Tests (7)

matches canonical diverges no fixture in this DV's cluster

Test Formula Canonical gsheets excel lattice ironcalc hyperformula libreoffice formulas pycel
info/f67c20 =ISDATE(42) false gsheetsfalse excel#N/A latticefalse ironcalc#NAME? hyperformula#NAME? libreoffice#NAME? formulas#NAME? pycel#NAME?
info/78c5b1 =ISDATE("hello") false gsheetsfalse excel#N/A latticefalse ironcalc#NAME? hyperformula#NAME? libreoffice#NAME? formulas#NAME? pycel#NAME?
info/373619 =ISDATE(DATE(2024,1,15)) true gsheetstrue excel#N/A latticetrue ironcalc#NAME? hyperformula#NAME? libreoffice#NAME? formulas#NAME? pycel#NAME?
text-longtail/8632a3 =JOIN("-", {"a","b","c"}) a-b-c gsheetsa-b-c excel#N/A latticea-b-c ironcalc#NAME? hyperformula#NAME? libreoffice#NAME? formulas#NAME? pycel#NAME?
text-longtail/498f7c =JOIN(",", {1,2,3}) 1,2,3 gsheets1,2,3 excel#N/A lattice1,2,3 ironcalc#NAME? hyperformula#NAME? libreoffice#NAME? formulas#NAME? pycel#NAME?
text-longtail/ab8f6f =JOIN("", {"a","b","c"}) abc gsheetsabc excel#N/A latticeabc ironcalc#NAME? hyperformula#NAME? libreoffice#NAME? formulas#NAME? pycel#NAME?
text-longtail/e5def8 =JOIN("-", {"solo"}) solo gsheetssolo excel#N/A latticesolo ironcalc#NAME? hyperformula#NAME? libreoffice#NAME? formulas#NAME? pycel#NAME?