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
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/67be54 =SUM(OFFSET(A1,0,0,2,2)) 10 gsheets10 excel10 lattice10 ironcalc10 hyperformula10 libreoffice10 formulas#NAME? pycel0
lookup-longtail/500e03 =SUM(OFFSET(A1,1,0,3,1)) 30 gsheets30 excel30 lattice30 ironcalc30 hyperformula30 libreoffice30 formulas#NAME? pycel0
lookup-longtail/3aa075 =OFFSET(A3,-2,0)+0 1 gsheets1 excel1 lattice1 ironcalc#N/IMPL! hyperformula1 libreoffice1 formulas#NAME? pycel#VALUE!
math-longtail/adeb26 =SUBTOTAL(1, A1:A3) 20 gsheets20 excel20 lattice20 ironcalc20 hyperformula20 libreoffice20 formulas#NAME? pycel20
math-longtail/5a4fd5 =SUBTOTAL(2, A1:A3) 3 gsheets3 excel3 lattice3 ironcalc3 hyperformula3 libreoffice3 formulas#NAME? pycel3
math-longtail/46c9a8 =SUBTOTAL(4, A1:A3) 30 gsheets30 excel30 lattice30 ironcalc30 hyperformula30 libreoffice30 formulas#NAME? pycel30
math-longtail/be642e =SUBTOTAL(5, A1:A3) 10 gsheets10 excel10 lattice10 ironcalc10 hyperformula10 libreoffice10 formulas#NAME? pycel10
math-longtail/41ef5f =SUBTOTAL(9, A1:A3) 60 gsheets60 excel60 lattice60 ironcalc60 hyperformula60 libreoffice60 formulas#NAME? pycel60