DV-0030
ironcalc: different error code — INDIRECT, OFFSET, lit:array
Subjects (3)
Tests (6)
matches canonical diverges no fixture in this DV's cluster
| Test | Formula | Canonical | gsheets | excel | lattice | ironcalc | hyperformula | libreoffice | formulas | pycel |
|---|---|---|---|---|---|---|---|---|---|---|
OFFSET/offset-down-one |
=OFFSET(A1,1,0)+0 |
20 | gsheets20 | excel20 | lattice20 | ironcalc#N/IMPL! | hyperformula20 | libreoffice— | formulas#NAME? | pycel#NAME? |
OFFSET/offset-right-one |
=OFFSET(A1,0,2)+0 |
3 | gsheets3 | excel3 | lattice3 | ironcalc#N/IMPL! | hyperformula3 | libreoffice— | formulas#NAME? | pycel#NAME? |
OFFSET/offset-zero |
=OFFSET(A1,0,0)+0 |
42 | gsheets42 | excel42 | lattice42 | ironcalc#N/IMPL! | hyperformula42 | libreoffice— | formulas#NAME? | pycel#NAME? |
OFFSET/offset-negative-rows |
=OFFSET(A3,-2,0)+0 |
1 | gsheets1 | excel1 | lattice1 | ironcalc#N/IMPL! | hyperformula1 | libreoffice— | formulas#NAME? | pycel#NAME? |
INDIRECT/indirect-r1c1-style |
=INDIRECT("R1C1", FALSE) |
7 | gsheets7 | excel7 | lattice#N/A | ironcalc#N/IMPL! | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel7 |
lit:array/array-literal-row |
={1, 2, 3} |
{1, 2, 3} | gsheets{1, 2, 3} | excel{1, 2, 3} | lattice{1, 2, 3} | ironcalc#N/IMPL! | hyperformula{1, 2, 3} | libreoffice— | formulas{1, 2, 3} | pycel1 |