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 |
|---|---|---|---|---|---|---|---|---|---|---|
text-longtail/ebc46f |
=CLEAN("") |
gsheets— | excel— | lattice | ironcalc#NAME? | hyperformula | libreoffice— | formulas— | pycel#NAME? | |
text-longtail/95e173 |
=LEFTB("hello", 0) |
gsheets— | excel— | lattice | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas— | pycel#NAME? | |
text-longtail/faad2c |
=RIGHTB("hello", 0) |
gsheets— | excel— | lattice | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas— | pycel#NAME? | |
text-longtail/772f7c |
=T(42) |
gsheets— | excel— | lattice | ironcalc | hyperformula | libreoffice— | formulas— | pycel#NAME? | |
text-longtail/f985ab |
=T(TRUE) |
gsheets— | excel— | lattice | ironcalc | hyperformula#NAME? | libreoffice— | formulas— | pycel#NAME? | |
text-longtail/d3fea8 |
=T("") |
gsheets— | excel— | lattice | ironcalc | hyperformula | libreoffice— | formulas— | pycel#NAME? |