DV-0031
excel, formulas, gsheets, libreoffice: different argument interpretation — CLEAN, LEFTB, RIGHTB (+1 more)
Subjects (4)
Tests (6)
matches canonical diverges no fixture in this DV's cluster
| Test | Formula | Canonical | gsheets | excel | lattice | ironcalc | hyperformula | libreoffice | formulas | pycel |
|---|---|---|---|---|---|---|---|---|---|---|
CLEAN/clean-empty |
=CLEAN("") |
gsheets— | excel— | lattice | ironcalc#NAME? | hyperformula | libreoffice— | formulas— | pycel#NAME? | |
LEFTB/leftb-zero |
=LEFTB("hello", 0) |
gsheets— | excel— | lattice | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas— | pycel#NAME? | |
RIGHTB/rightb-zero |
=RIGHTB("hello", 0) |
gsheets— | excel— | lattice | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas— | pycel#NAME? | |
T/t-number |
=T(42) |
gsheets— | excel— | lattice | ironcalc | hyperformula | libreoffice— | formulas— | pycel#NAME? | |
T/t-boolean |
=T(TRUE) |
gsheets— | excel— | lattice | ironcalc | hyperformula#NAME? | libreoffice— | formulas— | pycel#NAME? | |
T/t-empty |
=T("") |
gsheets— | excel— | lattice | ironcalc | hyperformula | libreoffice— | formulas— | pycel#NAME? |