DV-0024
formulas, hyperformula, ironcalc, libreoffice, pycel: function not implemented — ISDATE, JOIN
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? |