DV-0021

formulas: function not implemented — OFFSET, SUBTOTAL

Cause: missing-function
Category: value
Diverging engines: formulas
Behavior signature: {"error":"#NAME?"}
Test count: 11
Seeded: 2026-04-25
Last confirmed: 2026-04-25

Subjects (2)

OFFSET SUBTOTAL

Tests (11)

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-sum-height-width`	`=SUM(OFFSET(A1,0,0,2,2))`	10	gsheets10	excel10	lattice10	ironcalc10	hyperformula10	libreoffice—	formulas#NAME?	pycel0
`OFFSET/offset-sum-shifted-range`	`=SUM(OFFSET(A1,1,0,3,1))`	30	gsheets30	excel30	lattice30	ironcalc30	hyperformula30	libreoffice—	formulas#NAME?	pycel0
`OFFSET/offset-negative-rows`	`=OFFSET(A3,-2,0)+0`	1	gsheets1	excel1	lattice1	ironcalc#N/IMPL!	hyperformula1	libreoffice—	formulas#NAME?	pycel#NAME?
`SUBTOTAL/subtotal-average`	`=SUBTOTAL(1, A1:A3)`	20	gsheets20	excel20	lattice20	ironcalc20	hyperformula20	libreoffice—	formulas#NAME?	pycel20
`SUBTOTAL/subtotal-count`	`=SUBTOTAL(2, A1:A3)`	3	gsheets3	excel3	lattice3	ironcalc3	hyperformula3	libreoffice—	formulas#NAME?	pycel3
`SUBTOTAL/subtotal-max`	`=SUBTOTAL(4, A1:A3)`	30	gsheets30	excel30	lattice30	ironcalc30	hyperformula30	libreoffice—	formulas#NAME?	pycel30
`SUBTOTAL/subtotal-min`	`=SUBTOTAL(5, A1:A3)`	10	gsheets10	excel10	lattice10	ironcalc10	hyperformula10	libreoffice—	formulas#NAME?	pycel10
`SUBTOTAL/subtotal-sum`	`=SUBTOTAL(9, A1:A3)`	60	gsheets60	excel60	lattice60	ironcalc60	hyperformula60	libreoffice—	formulas#NAME?	pycel60