lookup-longtail

`500e03`

Subject: OFFSET
Category: value
Formula: =SUM(OFFSET(A1,1,0,3,1))
Canonical: 30

Owning divergences (2)

DV-0021 formulas: function not implemented — OFFSET, SUBTOTAL
missing-function formulas
DV-0034 pycel: different argument interpretation — INDIRECT, OFFSET, XOR
arg-semantics pycel

Per-engine results

matches canonical diverges no fixture

Engine	Verdict	Value
gsheets	match	30
excel	match	30
lattice	match	30
ironcalc	match	30
hyperformula	match	30
libreoffice	match	30
formulas	diverge	#NAME?
pycel	diverge	0