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 gsheets[object Object] excel[object Object] lattice10 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas10 pycel#NAME?
XMATCH/xmatch-exact =XMATCH(20, A1:A3) 2 gsheets[object Object] excel[object Object] lattice2 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas2 pycel#NAME?
MUNIT/munit-2x2 =MUNIT(2) {1, 0; 0, 1} gsheets{[object Object], [object Object]; [object Object], [object Object]} excel{[object Object], [object Object]; [object Object], [object Object]} 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 gsheets[object Object] excel[object Object] lattice1 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas1 pycel#NAME?
FORECAST.LINEAR/forecast-linear-exact-linear =FORECAST.LINEAR(4, B1:B3, A1:A3) 8 gsheets[object Object] excel[object Object] lattice8 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas8 pycel#NAME?
MODE.SNGL/mode-sngl-clear-winner =MODE.SNGL(1, 2, 2, 3, 4) 2 gsheets[object Object] excel[object Object] lattice2 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas2 pycel#NAME?
MODE.SNGL/mode-sngl-tied-dataset =MODE.SNGL(B1:B5) 2 gsheets[object Object] excel[object Object] lattice2 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas2 pycel#NAME?
MODE.SNGL/mode-sngl-no-repeats =MODE.SNGL(1, 2, 3) #N/A gsheets[object Object] excel[object Object] 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 gsheets[object Object] excel[object Object] lattice2 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas2 pycel#NAME?
PERCENTILE.INC/percentile-inc-50th-on-1-5 =PERCENTILE.INC(A1:A5, 0.5) 3 gsheets[object Object] excel[object Object] lattice3 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas3 pycel#NAME?
PERCENTILE.INC/percentile-inc-75th-on-1-5 =PERCENTILE.INC(A1:A5, 0.75) 4 gsheets[object Object] excel[object Object] 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 gsheets[object Object] excel[object Object] 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 gsheets[object Object] excel[object Object] 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 gsheets[object Object] excel[object Object] 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[object Object] excel[object Object] lattice#NUM! ironcalc#NAME? hyperformula#NAME? libreoffice— formulas#NUM! pycel#NAME?
PERCENTRANK.INC/percentrank-inc-midpoint =PERCENTRANK.INC(A1:A5, 3) 0.5 gsheets[object Object] excel[object Object] lattice0.5 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas0.5 pycel#NAME?
PERCENTRANK.INC/percentrank-inc-minimum =PERCENTRANK.INC(A1:A5, 1) 0 gsheets[object Object] excel[object Object] lattice0 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas0 pycel#NAME?
PERCENTRANK.INC/percentrank-inc-quarter =PERCENTRANK.INC(A1:A5, 2) 0.25 gsheets[object Object] excel[object Object] lattice0.25 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas0.25 pycel#NAME?
PERCENTRANK.EXC/percentrank-exc-midpoint =PERCENTRANK.EXC(A1:A5, 3) 0.5 gsheets[object Object] excel[object Object] lattice0.5 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas0.5 pycel#NAME?
PERCENTRANK.EXC/percentrank-exc-interior =PERCENTRANK.EXC(A1:A5, 2) 0.333 gsheets[object Object] excel[object Object] lattice0.333 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas0.333 pycel#NAME?
PERMUTATIONA/permutationa-basic =PERMUTATIONA(5, 2) 25 gsheets[object Object] excel[object Object] lattice25 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas25 pycel#NAME?
PERMUTATIONA/permutationa-triple =PERMUTATIONA(3, 3) 27 gsheets[object Object] excel[object Object] lattice27 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas27 pycel#NAME?
PERMUTATIONA/permutationa-zero-pick =PERMUTATIONA(5, 0) 1 gsheets[object Object] excel[object Object] lattice1 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas1 pycel#NAME?
PERMUTATIONA/permutationa-negative =PERMUTATIONA(-1, 2) #NUM! gsheets[object Object] excel[object Object] 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 gsheets[object Object] excel[object Object] lattice2 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas2 pycel#NAME?
QUARTILE.INC/quartile-inc-q2-on-1-5 =QUARTILE.INC(A1:A5, 2) 3 gsheets[object Object] excel[object Object] lattice3 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas3 pycel#NAME?
QUARTILE.INC/quartile-inc-q3-on-1-5 =QUARTILE.INC(A1:A5, 3) 4 gsheets[object Object] excel[object Object] lattice4 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas4 pycel#NAME?
QUARTILE.EXC/quartile-exc-q1-on-1-5 =QUARTILE.EXC(A1:A5, 1) 1.5 gsheets[object Object] excel[object Object] 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 gsheets[object Object] excel[object Object] lattice3 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas3 pycel#NAME?
QUARTILE.EXC/quartile-exc-q3-on-1-5 =QUARTILE.EXC(A1:A5, 3) 4.5 gsheets[object Object] excel[object Object] 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[object Object] excel[object Object] lattice#NUM! ironcalc#NAME? hyperformula#NAME? libreoffice— formulas#NUM! pycel#NAME?