assay

DV-0016

hyperformula, pycel: function not implemented — CONVERT, ERROR.TYPE, GESTEP (+4 more)

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

Subjects (7)

CONVERT ERROR.TYPE GESTEP MAXA MINA T XIRR

Tests (17)

matches canonical diverges no fixture in this DV's cluster

Test Formula Canonical gsheets excel lattice ironcalc hyperformula libreoffice formulas pycel
GESTEP/gestep-greater =GESTEP(5, 3) 1 gsheets1 excel1 lattice1 ironcalc1 hyperformula#NAME? libreoffice— formulas1 pycel#NAME?
GESTEP/gestep-less =GESTEP(2, 3) 0 gsheets0 excel0 lattice0 ironcalc0 hyperformula#NAME? libreoffice— formulas0 pycel#NAME?
GESTEP/gestep-equal =GESTEP(3, 3) 1 gsheets1 excel1 lattice1 ironcalc1 hyperformula#NAME? libreoffice— formulas1 pycel#NAME?
GESTEP/gestep-default-step-zero =GESTEP(-1) 0 gsheets0 excel0 lattice0 ironcalc0 hyperformula#NAME? libreoffice— formulas0 pycel#NAME?
XIRR/xirr-no-sign-change =XIRR(A1:A2, B1:B2) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NAME? libreoffice— formulas#NUM! pycel#NAME?
ERROR.TYPE/error-type-of-div-0-info =ERROR.TYPE(1/0) 2 gsheets2 excel2 lattice2 ironcalc2 hyperformula#NAME? libreoffice— formulas2 pycel#NAME?
ERROR.TYPE/error-type-of-na =ERROR.TYPE(NA()) 7 gsheets7 excel7 lattice7 ironcalc7 hyperformula#NAME? libreoffice— formulas7 pycel#NAME?
ERROR.TYPE/error-type-of-value-info =ERROR.TYPE("a"+1) 3 gsheets3 excel3 lattice3 ironcalc3 hyperformula#NAME? libreoffice— formulas3 pycel#NAME?
ERROR.TYPE/error-type-of-non-error-number =ERROR.TYPE(42) #N/A gsheets#N/A excel#N/A lattice#N/A ironcalc#N/A hyperformula#NAME? libreoffice— formulas#N/A pycel#NAME?
ERROR.TYPE/error-type-of-non-error-text =ERROR.TYPE("hello") #N/A gsheets#N/A excel#N/A lattice#N/A ironcalc#N/A hyperformula#NAME? libreoffice— formulas#N/A pycel#NAME?
ERROR.TYPE/error-type-of-ref-error =ERROR.TYPE(INDIRECT("ZZZZ99999999")) 4 gsheets4 excel4 lattice#N/A ironcalc4 hyperformula#NAME? libreoffice— formulas4 pycel#NAME?
CONVERT/convert-feet-to-inches =CONVERT(1, "ft", "in") 12 gsheets12 excel12 lattice12.0000 ironcalc12 hyperformula#NAME? libreoffice— formulas12.0000 pycel#NAME?
CONVERT/convert-celsius-to-fahrenheit =CONVERT(100, "C", "F") 212 gsheets212 excel212 lattice212 ironcalc212 hyperformula#NAME? libreoffice— formulas212.000 pycel#NAME?
CONVERT/convert-hours-to-seconds =CONVERT(1, "hr", "sec") 3600 gsheets3600 excel3600 lattice3600 ironcalc3600 hyperformula#NAME? libreoffice— formulas3600 pycel#NAME?
MAXA/maxa-inline-boolean =MAXA(-2, -1, TRUE) 1 gsheets1 excel1 lattice1 ironcalc1 hyperformula#NAME? libreoffice— formulas1 pycel#NAME?
MINA/mina-inline-boolean-false =MINA(2, 3, FALSE) 0 gsheets0 excel0 lattice0 ironcalc0 hyperformula#NAME? libreoffice— formulas0 pycel#NAME?
T/t-boolean =T(TRUE) gsheets— excel— lattice ironcalc hyperformula#NAME? libreoffice— formulas— pycel#NAME?