assay

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
ISDATE/isdate-of-number =ISDATE(42) false gsheets[object Object] excel[object Object] latticefalse ironcalc#NAME? hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?
ISDATE/isdate-of-text =ISDATE("hello") false gsheets[object Object] excel[object Object] latticefalse ironcalc#NAME? hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?
ISDATE/isdate-of-date-call =ISDATE(DATE(2024,1,15)) true gsheets[object Object] excel[object Object] latticetrue ironcalc#NAME? hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?
JOIN/join-basic =JOIN("-", {"a","b","c"}) a-b-c gsheets[object Object] excel[object Object] latticea-b-c ironcalc#NAME? hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?
JOIN/join-with-numbers =JOIN(",", {1,2,3}) 1,2,3 gsheets[object Object] excel[object Object] lattice1,2,3 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?
JOIN/join-empty-delim =JOIN("", {"a","b","c"}) abc gsheets[object Object] excel[object Object] latticeabc ironcalc#NAME? hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?
JOIN/join-single-element =JOIN("-", {"solo"}) solo gsheets[object Object] excel[object Object] latticesolo ironcalc#NAME? hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?