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 |
|---|---|---|---|---|---|---|---|---|---|---|
lookup-longtail/3e0cc4 |
=INDIRECT("A" & 5) |
99 | gsheets99 | excel99 | lattice99 | ironcalc99 | hyperformula#NAME? | libreoffice99 | formulas#NAME? | pycel99 |
lookup-longtail/2ee44a |
=INDIRECT("not a ref") |
#REF! | gsheets#REF! | excel#REF! | lattice#REF! | ironcalc#REF! | hyperformula#NAME? | libreoffice#REF! | formulas#NAME? | pycel#REF! |
lookup-longtail/4ccf67 |
=INDIRECT("R1C1", FALSE) |
7 | gsheets7 | excel7 | lattice#N/A | ironcalc#N/IMPL! | hyperformula#NAME? | libreoffice7 | formulas#NAME? | pycel7 |