DV-0033
formulas, hyperformula, lattice, pycel: function not implemented — CELL
Subjects (1)
Tests (5)
matches canonical diverges no fixture in this DV's cluster
| Test | Formula | Canonical | gsheets | excel | lattice | ironcalc | hyperformula | libreoffice | formulas | pycel |
|---|---|---|---|---|---|---|---|---|---|---|
CELL/cell-address |
=CELL("address", A1) |
$A$1 | gsheets$A$1 | excel$A$1 | lattice#NAME? | ironcalc$A$1 | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
CELL/cell-contents |
=CELL("contents", A1) |
42 | gsheets42 | excel42 | lattice#NAME? | ironcalc42 | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
CELL/cell-row |
=CELL("row", B3) |
3 | gsheets3 | excel3 | lattice#NAME? | ironcalc3 | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
CELL/cell-col |
=CELL("col", B3) |
2 | gsheets2 | excel2 | lattice#NAME? | ironcalc2 | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
CELL/cell-type-text |
=CELL("type", A1) |
l | gsheetsl | excell | lattice#NAME? | ironcalcl | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |