DV-0047
hyperformula: different argument interpretation — ISLOGICAL, ISODD
Subjects (2)
Tests (3)
matches canonical diverges no fixture in this DV's cluster
| Test | Formula | Canonical | gsheets | excel | lattice | ironcalc | hyperformula | libreoffice | formulas | pycel |
|---|---|---|---|---|---|---|---|---|---|---|
ISLOGICAL/islogical-of-true |
=ISLOGICAL(TRUE) |
true | gsheetstrue | exceltrue | latticetrue | ironcalctrue | hyperformulafalse | libreoffice— | formulastrue | pyceltrue |
ISLOGICAL/islogical-of-false |
=ISLOGICAL(FALSE) |
true | gsheetstrue | exceltrue | latticetrue | ironcalctrue | hyperformulafalse | libreoffice— | formulastrue | pyceltrue |
ISODD/isodd-negative-odd |
=ISODD(-3) |
true | gsheetstrue | exceltrue | latticetrue | ironcalctrue | hyperformulafalse | libreoffice— | formulastrue | pycel#NAME? |