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 |
|---|---|---|---|---|---|---|---|---|---|---|
info/820ad5 |
=ERROR.TYPE(INDIRECT("ZZZZ99999999")) |
4 | gsheets4 | excel4 | lattice#N/A | ironcalc4 | hyperformula#NAME? | libreoffice4 | formulas4 | pycel#NAME? |
lookup-longtail/4ccf67 |
=INDIRECT("R1C1", FALSE) |
7 | gsheets7 | excel7 | lattice#N/A | ironcalc#N/IMPL! | hyperformula#NAME? | libreoffice7 | formulas#NAME? | pycel7 |