DV-0062
lattice: different error code — ERROR.TYPE, INDIRECT
Subjects (2)
Tests (2)
matches canonical diverges no fixture in this DV's cluster
| Test | Formula | Canonical | gsheets | excel | lattice | ironcalc | hyperformula | libreoffice | formulas | pycel |
|---|---|---|---|---|---|---|---|---|---|---|
ERROR.TYPE/error-type-of-ref-error |
=ERROR.TYPE(INDIRECT("ZZZZ99999999")) |
4 | gsheets4 | excel4 | lattice#N/A | ironcalc4 | hyperformula#NAME? | libreoffice— | formulas4 | pycel#NAME? |
INDIRECT/indirect-r1c1-style |
=INDIRECT("R1C1", FALSE) |
7 | gsheets7 | excel7 | lattice#N/A | ironcalc#N/IMPL! | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel7 |