assay

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
OFFSET/offset-down-one =OFFSET(A1,1,0)+0 20 gsheets[object Object] excel[object Object] lattice20 ironcalc#N/IMPL! hyperformula20 libreoffice— formulas#NAME? pycel#NAME?
OFFSET/offset-right-one =OFFSET(A1,0,2)+0 3 gsheets[object Object] excel[object Object] lattice3 ironcalc#N/IMPL! hyperformula3 libreoffice— formulas#NAME? pycel#NAME?
OFFSET/offset-zero =OFFSET(A1,0,0)+0 42 gsheets[object Object] excel[object Object] lattice42 ironcalc#N/IMPL! hyperformula42 libreoffice— formulas#NAME? pycel#NAME?
OFFSET/offset-negative-rows =OFFSET(A3,-2,0)+0 1 gsheets[object Object] excel[object Object] lattice1 ironcalc#N/IMPL! hyperformula1 libreoffice— formulas#NAME? pycel#NAME?