DV-0048
formulas, hyperformula: function not implemented — INDIRECT
Subjects (1)
Tests (3)
matches canonical diverges no fixture in this DV's cluster
| Test | Formula | Canonical | gsheets | excel | lattice | ironcalc | hyperformula | libreoffice | formulas | pycel |
|---|---|---|---|---|---|---|---|---|---|---|
INDIRECT/indirect-concatenated |
=INDIRECT("A" & 5) |
99 | gsheets99 | excel99 | lattice99 | ironcalc99 | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
INDIRECT/indirect-bad-ref |
=INDIRECT("not a ref") |
#REF! | gsheets#REF! | excel#REF! | lattice#REF! | ironcalc#REF! | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#REF! |
INDIRECT/indirect-r1c1-style |
=INDIRECT("R1C1", FALSE) |
7 | gsheets7 | excel7 | lattice#N/A | ironcalc#N/IMPL! | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel7 |