DV-0040

pycel: different error code — OFFSET

Cause
error-code
Category
value
Diverging engines
pycel
Behavior signature
{"error":"#VALUE!"}
Test count
4
Seeded
2026-04-25
Last confirmed
2026-04-25

Subjects (1)

OFFSET

Tests (4)

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!