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)

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