DV-0004
libreoffice, pycel: function not implemented — ACOTH, ARABIC, BINOM.INV (+27 more)
Subjects (30)
Tests (68)
matches canonical diverges no fixture in this DV's cluster
| Test | Formula | Canonical | gsheets | excel | lattice | ironcalc | hyperformula | libreoffice | formulas | pycel |
|---|---|---|---|---|---|---|---|---|---|---|
DAYS/days-basic |
=DAYS("2025-03-15", "2025-03-01") |
14 | gsheets14 | excel14 | lattice14 | ironcalc14 | hyperformula#VALUE! | libreoffice— | formulas14 | pycel#NAME? |
DAYS/days-negative |
=DAYS("2025-03-01", "2025-03-15") |
-14 | gsheets-14 | excel-14 | lattice-14 | ironcalc-14 | hyperformula#VALUE! | libreoffice— | formulas-14 | pycel#NAME? |
DAYS/days-same-day |
=DAYS("2025-03-15", "2025-03-15") |
0 | gsheets0 | excel0 | lattice0 | ironcalc0 | hyperformula#VALUE! | libreoffice— | formulas0 | pycel#NAME? |
DAYS/days-across-year |
=DAYS("2025-01-01", "2024-01-01") |
366 | gsheets366 | excel366 | lattice366 | ironcalc366 | hyperformula#VALUE! | libreoffice— | formulas366 | pycel#NAME? |
ISOWEEKNUM/isoweeknum-mid-year |
=ISOWEEKNUM("2025-06-15") |
24 | gsheets24 | excel24 | lattice24 | ironcalc24 | hyperformula#VALUE! | libreoffice— | formulas24 | pycel#NAME? |
ISOWEEKNUM/isoweeknum-jan-1-belongs-to-prev-year |
=ISOWEEKNUM("2023-01-01") |
52 | gsheets52 | excel52 | lattice52 | ironcalc52 | hyperformula#VALUE! | libreoffice— | formulas52 | pycel#NAME? |
ISOWEEKNUM/isoweeknum-first-week |
=ISOWEEKNUM("2024-01-01") |
1 | gsheets1 | excel1 | lattice1 | ironcalc1 | hyperformula#VALUE! | libreoffice— | formulas1 | pycel#NAME? |
SWITCH/switch-3-arg-form |
=SWITCH(1, 1, "yes") |
yes | gsheetsyes | excelyes | latticeyes | ironcalcyes | hyperformulayes | libreoffice— | formulasyes | pycel#NAME? |
SWITCH/switch-4-arg-with-no-match |
=SWITCH(99, 1, "one", "default") |
default | gsheetsdefault | exceldefault | latticedefault | ironcalcdefault | hyperformuladefault | libreoffice— | formulasdefault | pycel#NAME? |
PDURATION/pduration-double-money-10pct |
=PDURATION(0.1, 1000, 2000) |
7.272541 | gsheets7.27254 | excel7.27254 | lattice7.27254 | ironcalc7.272540897 | hyperformula7.2725408973 | libreoffice— | formulas7.27254 | pycel#NAME? |
PDURATION/pduration-no-growth-needed |
=PDURATION(0.05, 1000, 1000) |
0 | gsheets0 | excel0 | lattice0 | ironcalc0 | hyperformula0 | libreoffice— | formulas0 | pycel#NAME? |
PDURATION/pduration-invalid-rate |
=PDURATION(0, 1000, 2000) |
#NUM! | gsheets#NUM! | excel#NUM! | lattice#NUM! | ironcalc#NUM! | hyperformula#NUM! | libreoffice— | formulas#NUM! | pycel#NAME? |
RRI/rri-double-in-8-years |
=RRI(8, 1, 2) |
0.090508 | gsheets0.0905077 | excel0.0905077 | lattice0.0905077 | ironcalc0.090507733 | hyperformula0.0905077 | libreoffice— | formulas0.0905077 | pycel#NAME? |
RRI/rri-no-growth |
=RRI(5, 1000, 1000) |
0 | gsheets0 | excel0 | lattice0 | ironcalc0 | hyperformula0 | libreoffice— | formulas0 | pycel#NAME? |
ISFORMULA/isformula-of-formula-cell |
=ISFORMULA(A1) |
true | gsheetstrue | exceltrue | latticetrue | ironcalctrue | hyperformulatrue | libreoffice— | formulastrue | pycel#NAME? |
ISFORMULA/isformula-of-number-cell |
=ISFORMULA(A1) |
false | gsheetsfalse | excelfalse | latticefalse | ironcalcfalse | hyperformulafalse | libreoffice— | formulasfalse | pycel#NAME? |
ISFORMULA/isformula-of-blank-cell |
=ISFORMULA(A1) |
false | gsheetsfalse | excelfalse | latticefalse | ironcalcfalse | hyperformulafalse | libreoffice— | formulasfalse | pycel#NAME? |
ISFORMULA/isformula-of-text-cell |
=ISFORMULA(A1) |
false | gsheetsfalse | excelfalse | latticefalse | ironcalcfalse | hyperformulafalse | libreoffice— | formulasfalse | pycel#NAME? |
SWITCH/switch-match-first |
=SWITCH(1, 1, "one", 2, "two") |
one | gsheetsone | excelone | latticeone | ironcalcone | hyperformulaone | libreoffice— | formulasone | pycel#NAME? |
SWITCH/switch-match-second |
=SWITCH(2, 1, "one", 2, "two") |
two | gsheetstwo | exceltwo | latticetwo | ironcalctwo | hyperformulatwo | libreoffice— | formulastwo | pycel#NAME? |
SWITCH/switch-with-default |
=SWITCH(99, 1, "one", 2, "two", "other") |
other | gsheetsother | excelother | latticeother | ironcalcother | hyperformulaother | libreoffice— | formulasother | pycel#NAME? |
SWITCH/switch-no-match-no-default |
=SWITCH(99, 1, "one", 2, "two") |
#N/A | gsheets#N/A | excel#N/A | lattice#N/A | ironcalc#N/A | hyperformula#N/A | libreoffice— | formulas#N/A | pycel#NAME? |
XLOOKUP/xlookup-basic |
=XLOOKUP(2, A1:A3, B1:B3) |
banana | gsheetsbanana | excelbanana | latticebanana | ironcalcbanana | hyperformulabanana | libreoffice— | formulasbanana | pycel#NAME? |
XLOOKUP/xlookup-not-found-with-default |
=XLOOKUP(99, A1:A2, B1:B2, "missing") |
missing | gsheetsmissing | excelmissing | latticemissing | ironcalcmissing | hyperformulamissing | libreoffice— | formulasmissing | pycel#NAME? |
SEC/sec-at-0 |
=SEC(0) |
1 | gsheets1 | excel1 | lattice1 | ironcalc1 | hyperformula1 | libreoffice— | formulas1 | pycel#NAME? |
SEC/sec-at-pi |
=SEC(PI()) |
-1 | gsheets-1 | excel-1 | lattice-1 | ironcalc-1 | hyperformula-1 | libreoffice— | formulas-1 | pycel#NAME? |
SEC/sec-negative |
=SEC(-PI()) |
-1 | gsheets-1 | excel-1 | lattice-1 | ironcalc-1 | hyperformula-1 | libreoffice— | formulas-1 | pycel#NAME? |
CSC/csc-at-pi-2 |
=CSC(PI()/2) |
1 | gsheets1 | excel1 | lattice1 | ironcalc1 | hyperformula1 | libreoffice— | formulas1 | pycel#NAME? |
CSC/csc-negative |
=CSC(-PI()/2) |
-1 | gsheets-1 | excel-1 | lattice-1 | ironcalc-1 | hyperformula-1 | libreoffice— | formulas-1 | pycel#NAME? |
SECH/sech-at-0 |
=SECH(0) |
1 | gsheets1 | excel1 | lattice1 | ironcalc1 | hyperformula1 | libreoffice— | formulas1 | pycel#NAME? |
ACOTH/acoth-out-of-domain |
=ACOTH(1) |
#NUM! | gsheets#NUM! | excel#NUM! | lattice#NUM! | ironcalc#NUM! | hyperformula#NUM! | libreoffice— | formulas#NUM! | pycel#NAME? |
DECIMAL/decimal-from-hex |
=DECIMAL("A", 16) |
10 | gsheets10 | excel10 | lattice10 | ironcalc10 | hyperformula10 | libreoffice— | formulas10 | pycel#NAME? |
DECIMAL/decimal-from-binary |
=DECIMAL("101", 2) |
5 | gsheets5 | excel5 | lattice5 | ironcalc5 | hyperformula5 | libreoffice— | formulas5 | pycel#NAME? |
DECIMAL/decimal-from-hex-larger |
=DECIMAL("FF", 16) |
255 | gsheets255 | excel255 | lattice255 | ironcalc255 | hyperformula255 | libreoffice— | formulas255 | pycel#NAME? |
DECIMAL/decimal-base-36 |
=DECIMAL("Z", 36) |
35 | gsheets35 | excel35 | lattice35 | ironcalc35 | hyperformula35 | libreoffice— | formulas35 | pycel#NAME? |
GAMMALN.PRECISE/gammaln-precise-at-1 |
=GAMMALN.PRECISE(1) |
0 | gsheets0 | excel0 | lattice0 | ironcalc-4.441e-16 | hyperformula0 | libreoffice— | formulas0 | pycel#NAME? |
GAMMALN.PRECISE/gammaln-precise-at-2 |
=GAMMALN.PRECISE(2) |
0 | gsheets0 | excel0 | lattice0 | ironcalc0 | hyperformula-4.441e-16 | libreoffice— | formulas0 | pycel#NAME? |
COVARIANCE.S/covariance-s-canonical |
=COVARIANCE.S(A1:A5, B1:B5) |
1.5 | gsheets1.5 | excel1.5 | lattice1.5 | ironcalc1.5 | hyperformula1.5 | libreoffice— | formulas1.5 | pycel#NAME? |
COVARIANCE.S/covariance-s-linear |
=COVARIANCE.S(A1:A3, B1:B3) |
2 | gsheets2 | excel2 | lattice2 | ironcalc2 | hyperformula2 | libreoffice— | formulas2 | pycel#NAME? |
SKEW.P/skew-p-symmetric |
=SKEW.P(A1:A5) |
0 | gsheets0 | excel0 | lattice0 | ironcalc0 | hyperformula0 | libreoffice— | formulas0 | pycel#NAME? |
Z.TEST/z-test-canonical |
=Z.TEST(A1:A5, 3) |
0.5 | gsheets0.5 | excel0.5 | lattice0.5 | ironcalc0.5 | hyperformula0.5 | libreoffice— | formulas0.5 | pycel#NAME? |
STDEV.S/stdev-s-identical |
=STDEV.S(5, 5, 5) |
0 | gsheets0 | excel0 | lattice0 | ironcalc0 | hyperformula0 | libreoffice— | formulas0 | pycel#NAME? |
STDEV.S/stdev-s-single-value |
=STDEV.S(5) |
#DIV/0! | gsheets#DIV/0! | excel#DIV/0! | lattice#DIV/0! | ironcalc#DIV/0! | hyperformula#DIV/0! | libreoffice— | formulas#DIV/0! | pycel#NAME? |
STDEV.P/stdev-p-two-values |
=STDEV.P(2, 6) |
2 | gsheets2 | excel2 | lattice2 | ironcalc2 | hyperformula2 | libreoffice— | formulas2 | pycel#NAME? |
STDEV.P/stdev-p-identical |
=STDEV.P(5, 5, 5) |
0 | gsheets0 | excel0 | lattice0 | ironcalc0 | hyperformula0 | libreoffice— | formulas0 | pycel#NAME? |
VAR.S/var-s-sample-1-5 |
=VAR.S(A1:A5) |
2.5 | gsheets2.5 | excel2.5 | lattice2.5 | ironcalc2.5 | hyperformula2.5 | libreoffice— | formulas2.5 | pycel#NAME? |
VAR.S/var-s-identical |
=VAR.S(5, 5, 5) |
0 | gsheets0 | excel0 | lattice0 | ironcalc0 | hyperformula0 | libreoffice— | formulas0 | pycel#NAME? |
VAR.S/var-s-single-value |
=VAR.S(5) |
#DIV/0! | gsheets#DIV/0! | excel#DIV/0! | lattice#DIV/0! | ironcalc#DIV/0! | hyperformula#DIV/0! | libreoffice— | formulas#DIV/0! | pycel#NAME? |
VAR.P/var-p-population-1-5 |
=VAR.P(A1:A5) |
2 | gsheets2 | excel2 | lattice2 | ironcalc2 | hyperformula2 | libreoffice— | formulas2 | pycel#NAME? |
VAR.P/var-p-two-values |
=VAR.P(2, 6) |
4 | gsheets4 | excel4 | lattice4 | ironcalc4 | hyperformula4 | libreoffice— | formulas4 | pycel#NAME? |
VAR.P/var-p-identical |
=VAR.P(5, 5, 5) |
0 | gsheets0 | excel0 | lattice0 | ironcalc0 | hyperformula0 | libreoffice— | formulas0 | pycel#NAME? |
BINOM.INV/binom-inv-median |
=BINOM.INV(10, 0.5, 0.5) |
5 | gsheets5 | excel5 | lattice5 | ironcalc5 | hyperformula5 | libreoffice— | formulas5 | pycel#NAME? |
BINOM.INV/binom-inv-tail |
=BINOM.INV(20, 0.3, 0.95) |
9 | gsheets9 | excel9 | lattice9 | ironcalc9 | hyperformula9 | libreoffice— | formulas9 | pycel#NAME? |
CHISQ.TEST/chisq-test-identical-ranges |
=CHISQ.TEST(A1:B2, A4:B5) |
1 | gsheets1 | excel1 | lattice1 | ironcalc1 | hyperformula1 | libreoffice— | formulas1 | pycel#NAME? |
GAUSS/gauss-at-0 |
=GAUSS(0) |
0 | gsheets0 | excel0 | lattice0 | ironcalc0 | hyperformula0 | libreoffice— | formulas0 | pycel#NAME? |
LOGNORM.INV/lognorm-inv-at-0-5 |
=LOGNORM.INV(0.5, 0, 1) |
1 | gsheets1 | excel1 | lattice1 | ironcalc1 | hyperformula1 | libreoffice— | formulas1 | pycel#NAME? |
NORM.INV/norm-inv-at-0-5 |
=NORM.INV(0.5, 0, 1) |
0 | gsheets0 | excel0 | lattice0 | ironcalc0 | hyperformula-7.681e-17 | libreoffice— | formulas0 | pycel#NAME? |
NORM.S.INV/norm-s-inv-at-0-5 |
=NORM.S.INV(0.5) |
0 | gsheets0 | excel0 | lattice0 | ironcalc0 | hyperformula-7.681e-17 | libreoffice— | formulas0 | pycel#NAME? |
T.DIST.RT/t-dist-rt-at-0 |
=T.DIST.RT(0, 10) |
0.5 | gsheets0.5 | excel0.5 | lattice0.5 | ironcalc0.5 | hyperformula0.5 | libreoffice— | formulas0.5 | pycel#NAME? |
T.INV/t-inv-at-0-5 |
=T.INV(0.5, 10) |
0 | gsheets0 | excel0 | lattice0 | ironcalc0 | hyperformula0 | libreoffice— | formulas0 | pycel#NAME? |
ARABIC/arabic-xiv |
=ARABIC("XIV") |
14 | gsheets14 | excel14 | lattice14 | ironcalc14 | hyperformula14 | libreoffice— | formulas14 | pycel#NAME? |
ARABIC/arabic-mcmxciv |
=ARABIC("MCMXCIV") |
1994 | gsheets1994 | excel1994 | lattice1994 | ironcalc1994 | hyperformula1994 | libreoffice— | formulas1994 | pycel#NAME? |
ARABIC/arabic-empty |
=ARABIC("") |
0 | gsheets0 | excel0 | lattice0 | ironcalc0 | hyperformula0 | libreoffice— | formulas0 | pycel#NAME? |
ARABIC/arabic-lowercase |
=ARABIC("xiv") |
14 | gsheets14 | excel14 | lattice14 | ironcalc14 | hyperformula14 | libreoffice— | formulas14 | pycel#NAME? |
UNICODE/unicode-uppercase-a |
=UNICODE("A") |
65 | gsheets65 | excel65 | lattice65 | ironcalc65 | hyperformula65 | libreoffice— | formulas65 | pycel#NAME? |
UNICODE/unicode-snowman |
=UNICODE("☃") |
9731 | gsheets9731 | excel9731 | lattice9731 | ironcalc9731 | hyperformula9731 | libreoffice— | formulas9731 | pycel#NAME? |
UNICODE/unicode-heart |
=UNICODE("♥") |
9829 | gsheets9829 | excel9829 | lattice9829 | ironcalc9829 | hyperformula9829 | libreoffice— | formulas9829 | pycel#NAME? |
UNICODE/unicode-first-char |
=UNICODE("Alphabet") |
65 | gsheets65 | excel65 | lattice65 | ironcalc65 | hyperformula65 | libreoffice— | formulas65 | pycel#NAME? |