DV-0030

ironcalc: different error code — INDIRECT, OFFSET, lit:array

Cause
error-code
Category
value
Diverging engines
ironcalc
Behavior signature
{"error":"#N/IMPL!"}
Test count
6
Seeded
2026-04-25
Last confirmed
2026-04-25

Subjects (3)

INDIRECT OFFSET lit:array

Tests (6)

matches canonical diverges no fixture in this DV's cluster

Test Formula Canonical gsheets excel lattice ironcalc hyperformula libreoffice formulas pycel
lookup-longtail/43b667 =OFFSET(A1,1,0)+0 20 gsheets20 excel20 lattice20 ironcalc#N/IMPL! hyperformula20 libreoffice20 formulas#NAME? pycel#VALUE!
lookup-longtail/2987c1 =OFFSET(A1,0,2)+0 3 gsheets3 excel3 lattice3 ironcalc#N/IMPL! hyperformula3 libreoffice3 formulas#NAME? pycel#VALUE!
lookup-longtail/fecead =OFFSET(A1,0,0)+0 42 gsheets42 excel42 lattice42 ironcalc#N/IMPL! hyperformula42 libreoffice42 formulas#NAME? pycel#VALUE!
lookup-longtail/3aa075 =OFFSET(A3,-2,0)+0 1 gsheets1 excel1 lattice1 ironcalc#N/IMPL! hyperformula1 libreoffice1 formulas#NAME? pycel#VALUE!
lookup-longtail/4ccf67 =INDIRECT("R1C1", FALSE) 7 gsheets7 excel7 lattice#N/A ironcalc#N/IMPL! hyperformula#NAME? libreoffice7 formulas#NAME? pycel7
spill/4bc9da ={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] libreoffice1 formulas[1, 2, 3] pycel1