assay

DV-0013

hyperformula, ironcalc, libreoffice, pycel: function not implemented — FORECAST.LINEAR, MODE.SNGL, MUNIT (+9 more)

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

Subjects (12)

FORECAST.LINEAR MODE.SNGL MUNIT PERCENTILE.EXC PERCENTILE.INC PERCENTRANK.EXC PERCENTRANK.INC PERMUTATIONA QUARTILE.EXC QUARTILE.INC SINGLE XMATCH

Tests (32)

matches canonical diverges no fixture in this DV's cluster

Test Formula Canonical gsheets excel lattice ironcalc hyperformula libreoffice formulas pycel
SINGLE/single-explicit-top-left =SINGLE({10,20,30}) 10 gsheets10 excel10 lattice10 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas10 pycel#NAME?
XMATCH/xmatch-exact =XMATCH(20, A1:A3) 2 gsheets2 excel2 lattice2 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas2 pycel#NAME?
MUNIT/munit-2x2 =MUNIT(2) {1, 0; 0, 1} gsheets{1, 0; 0, 1} excel{1, 0; 0, 1} lattice{1, 0; 0, 1} ironcalc#NAME? hyperformula#NAME? libreoffice— formulas— pycel#NAME?
MUNIT/munit-3x3 =MUNIT(3) [3×3] gsheets[3×3] excel[3×3] lattice[3×3] ironcalc#NAME? hyperformula#NAME? libreoffice— formulas— pycel#NAME?
MUNIT/munit-1x1 =MUNIT(1) 1 gsheets1 excel1 lattice1 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas1 pycel#NAME?
FORECAST.LINEAR/forecast-linear-exact-linear =FORECAST.LINEAR(4, B1:B3, A1:A3) 8 gsheets8 excel8 lattice8 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas8 pycel#NAME?
MODE.SNGL/mode-sngl-clear-winner =MODE.SNGL(1, 2, 2, 3, 4) 2 gsheets2 excel2 lattice2 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas2 pycel#NAME?
MODE.SNGL/mode-sngl-tied-dataset =MODE.SNGL(B1:B5) 2 gsheets2 excel2 lattice2 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas2 pycel#NAME?
MODE.SNGL/mode-sngl-no-repeats =MODE.SNGL(1, 2, 3) #N/A gsheets#N/A excel#N/A lattice#N/A ironcalc#NAME? hyperformula#NAME? libreoffice— formulas#N/A pycel#NAME?
PERCENTILE.INC/percentile-inc-25th-on-1-5 =PERCENTILE.INC(A1:A5, 0.25) 2 gsheets2 excel2 lattice2 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas2 pycel#NAME?
PERCENTILE.INC/percentile-inc-50th-on-1-5 =PERCENTILE.INC(A1:A5, 0.5) 3 gsheets3 excel3 lattice3 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas3 pycel#NAME?
PERCENTILE.INC/percentile-inc-75th-on-1-5 =PERCENTILE.INC(A1:A5, 0.75) 4 gsheets4 excel4 lattice4 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas4 pycel#NAME?
PERCENTILE.EXC/percentile-exc-25th-on-1-5 =PERCENTILE.EXC(A1:A5, 0.25) 1.5 gsheets1.5 excel1.5 lattice1.5 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas1.5 pycel#NAME?
PERCENTILE.EXC/percentile-exc-50th-on-1-5 =PERCENTILE.EXC(A1:A5, 0.5) 3 gsheets3 excel3 lattice3 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas3 pycel#NAME?
PERCENTILE.EXC/percentile-exc-75th-on-1-5 =PERCENTILE.EXC(A1:A5, 0.75) 4.5 gsheets4.5 excel4.5 lattice4.5 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas4.5 pycel#NAME?
PERCENTILE.EXC/percentile-exc-0th-invalid =PERCENTILE.EXC({1,2,3,4,5}, 0) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NAME? hyperformula#NAME? libreoffice— formulas#NUM! pycel#NAME?
PERCENTRANK.INC/percentrank-inc-midpoint =PERCENTRANK.INC(A1:A5, 3) 0.5 gsheets0.5 excel0.5 lattice0.5 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas0.5 pycel#NAME?
PERCENTRANK.INC/percentrank-inc-minimum =PERCENTRANK.INC(A1:A5, 1) 0 gsheets0 excel0 lattice0 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas0 pycel#NAME?
PERCENTRANK.INC/percentrank-inc-quarter =PERCENTRANK.INC(A1:A5, 2) 0.25 gsheets0.25 excel0.25 lattice0.25 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas0.25 pycel#NAME?
PERCENTRANK.EXC/percentrank-exc-midpoint =PERCENTRANK.EXC(A1:A5, 3) 0.5 gsheets0.5 excel0.5 lattice0.5 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas0.5 pycel#NAME?
PERCENTRANK.EXC/percentrank-exc-interior =PERCENTRANK.EXC(A1:A5, 2) 0.333 gsheets0.333 excel0.333 lattice0.333 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas0.333 pycel#NAME?
PERMUTATIONA/permutationa-basic =PERMUTATIONA(5, 2) 25 gsheets25 excel25 lattice25 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas25 pycel#NAME?
PERMUTATIONA/permutationa-triple =PERMUTATIONA(3, 3) 27 gsheets27 excel27 lattice27 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas27 pycel#NAME?
PERMUTATIONA/permutationa-zero-pick =PERMUTATIONA(5, 0) 1 gsheets#NUM! excel1 lattice1 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas1 pycel#NAME?
PERMUTATIONA/permutationa-negative =PERMUTATIONA(-1, 2) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NAME? hyperformula#NAME? libreoffice— formulas#NUM! pycel#NAME?
QUARTILE.INC/quartile-inc-q1-on-1-5 =QUARTILE.INC(A1:A5, 1) 2 gsheets2 excel2 lattice2 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas2 pycel#NAME?
QUARTILE.INC/quartile-inc-q2-on-1-5 =QUARTILE.INC(A1:A5, 2) 3 gsheets3 excel3 lattice3 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas3 pycel#NAME?
QUARTILE.INC/quartile-inc-q3-on-1-5 =QUARTILE.INC(A1:A5, 3) 4 gsheets4 excel4 lattice4 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas4 pycel#NAME?
QUARTILE.EXC/quartile-exc-q1-on-1-5 =QUARTILE.EXC(A1:A5, 1) 1.5 gsheets1.5 excel1.5 lattice1.5 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas1.5 pycel#NAME?
QUARTILE.EXC/quartile-exc-q2-on-1-5 =QUARTILE.EXC(A1:A5, 2) 3 gsheets3 excel3 lattice3 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas3 pycel#NAME?
QUARTILE.EXC/quartile-exc-q3-on-1-5 =QUARTILE.EXC(A1:A5, 3) 4.5 gsheets4.5 excel4.5 lattice4.5 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas4.5 pycel#NAME?
QUARTILE.EXC/quartile-exc-q0-invalid =QUARTILE.EXC({1,2,3,4,5}, 0) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NAME? hyperformula#NAME? libreoffice— formulas#NUM! pycel#NAME?