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[object Object] | excel[object Object] | lattice— | ironcalc— | hyperformula— | libreoffice— | formulas— | pycel— | |
LEFTB/leftb-zero |
=LEFTB("hello", 0) |
gsheets[object Object] | excel[object Object] | lattice— | ironcalc— | hyperformula— | libreoffice— | formulas— | pycel— | |
RIGHTB/rightb-zero |
=RIGHTB("hello", 0) |
gsheets[object Object] | excel[object Object] | lattice— | ironcalc— | hyperformula— | libreoffice— | formulas— | pycel— | |
T/t-number |
=T(42) |
gsheets[object Object] | excel[object Object] | lattice— | ironcalc— | hyperformula— | libreoffice— | formulas— | pycel— | |
T/t-boolean |
=T(TRUE) |
gsheets[object Object] | excel[object Object] | lattice— | ironcalc— | hyperformula— | libreoffice— | formulas— | pycel— | |
T/t-empty |
=T("") |
gsheets[object Object] | excel[object Object] | lattice— | ironcalc— | hyperformula— | libreoffice— | formulas— | pycel— |