DV-0017

hyperformula, libreoffice, pycel: function not implemented — BETA.DIST, BINOM.DIST, ERF.PRECISE (+10 more)

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

Subjects (13)

BETA.DIST BINOM.DIST ERF.PRECISE ERFC.PRECISE EXPON.DIST GAMMA.INV NORM.DIST NORM.S.DIST RANK.AVG RANK.EQ T.DIST TEXTJOIN WEIBULL.DIST

Tests (17)

matches canonical diverges no fixture in this DV's cluster

Test Formula Canonical gsheets excel lattice ironcalc hyperformula libreoffice formulas pycel
engineering/454e83 =ERF.PRECISE(0) 0 gsheets0 excel0 lattice0 ironcalc0 hyperformula#NAME? libreoffice#NAME? formulas0 pycel#NAME?
math-longtail/958215 =ERFC.PRECISE(0) 1 gsheets1 excel1 lattice1 ironcalc1 hyperformula#NAME? libreoffice#NAME? formulas1 pycel#NAME?
statistical-descriptive/d9740d =RANK.EQ(20, A1:A4) 2 gsheets2 excel2 lattice2 ironcalc2 hyperformula#NAME? libreoffice#NAME? formulas2 pycel#NAME?
statistical-descriptive/202ba7 =RANK.EQ(3, A1:A5, 1) 3 gsheets3 excel3 lattice3 ironcalc3 hyperformula#NAME? libreoffice#NAME? formulas3 pycel#NAME?
statistical-descriptive/2e53c2 =RANK.EQ(5, A1:A5) 1 gsheets1 excel1 lattice1 ironcalc1 hyperformula#NAME? libreoffice#NAME? formulas1 pycel#NAME?
statistical-descriptive/594c3c =RANK.AVG(20, A1:A4) 2.5 gsheets2.5 excel2.5 lattice2.5 ironcalc2.5 hyperformula#NAME? libreoffice#NAME? formulas2.5 pycel#NAME?
statistical-descriptive/7e3942 =RANK.AVG(3, A1:A5) 3 gsheets3 excel3 lattice3 ironcalc3 hyperformula#NAME? libreoffice#NAME? formulas3 pycel#NAME?
statistical-descriptive/ac52d6 =RANK.AVG(20, A1:A5) 3 gsheets3 excel3 lattice3 ironcalc3 hyperformula#NAME? libreoffice#NAME? formulas3 pycel#NAME?
statistical-distributions/a303e2 =BETA.DIST(1, 2, 5, TRUE, 0, 1) 1 gsheets1 excel1 lattice1 ironcalc1 hyperformula#NAME? libreoffice#NAME? formulas1 pycel#NAME?
statistical-distributions/0d22be =BINOM.DIST(10, 10, 0.5, TRUE) 1 gsheets1 excel1 lattice1.00000 ironcalc1 hyperformula#NAME? libreoffice#NAME? formulas1 pycel#NAME?
statistical-distributions/dbfb47 =EXPON.DIST(0, 2, FALSE) 2 gsheets2 excel2 lattice2 ironcalc2 hyperformula#NAME? libreoffice#NAME? formulas2 pycel#NAME?
statistical-distributions/03c6bd =GAMMA.INV(GAMMA.DIST(2, 2, 1, TRUE), 2, 1) 2 gsheets2 excel2 lattice2 ironcalc2 hyperformula#NAME? libreoffice#NAME? formulas2 pycel#NAME?
statistical-distributions/2823a6 =NORM.DIST(0, 0, 1, TRUE) 0.5 gsheets0.5 excel0.5 lattice0.5 ironcalc0.5 hyperformula#NAME? libreoffice#NAME? formulas0.5 pycel#NAME?
statistical-distributions/b1d7b4 =NORM.S.DIST(0, TRUE) 0.5 gsheets#N/A excel0.5 lattice0.5 ironcalc0.5 hyperformula#NAME? libreoffice#NAME? formulas0.5 pycel#NAME?
statistical-distributions/872355 =T.DIST(0, 10, TRUE) 0.5 gsheets0.5 excel0.5 lattice0.5 ironcalc0.5 hyperformula#NAME? libreoffice#NAME? formulas0.5 pycel#NAME?
statistical-distributions/5af6dc =WEIBULL.DIST(0, 2, 1, TRUE) 0 gsheets0 excel0 lattice0 ironcalc0 hyperformula#NAME? libreoffice#NAME? formulas0 pycel#NAME?
text/20455f =TEXTJOIN(", ", TRUE, A1:A3) Monday, Tuesday, Wedne… gsheetsMonday, Tuesday, Wedne… excelMonday, Tuesday, Wedne… latticeMonday, Tuesday, Wedne… ironcalcMonday, Tuesday, Wedne… hyperformula#NAME? libreoffice#NAME? formulasMonday, Tuesday, Wedne… pycel#NAME?