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 |
|---|---|---|---|---|---|---|---|---|---|---|
date/85991c |
=DAYS("2025-03-15", "2025-03-01") |
14 | gsheets14 | excel14 | lattice14 | ironcalc14 | hyperformula#VALUE! | libreoffice#NAME? | formulas14 | pycel#NAME? |
date/393422 |
=DAYS("2025-03-01", "2025-03-15") |
-14 | gsheets-14 | excel-14 | lattice-14 | ironcalc-14 | hyperformula#VALUE! | libreoffice#NAME? | formulas-14 | pycel#NAME? |
date/f5d649 |
=DAYS("2025-03-15", "2025-03-15") |
0 | gsheets0 | excel0 | lattice0 | ironcalc0 | hyperformula#VALUE! | libreoffice#NAME? | formulas0 | pycel#NAME? |
date/c7c68c |
=DAYS("2025-01-01", "2024-01-01") |
366 | gsheets366 | excel366 | lattice366 | ironcalc366 | hyperformula#VALUE! | libreoffice#NAME? | formulas366 | pycel#NAME? |
date/2bf6ea |
=ISOWEEKNUM("2025-06-15") |
24 | gsheets24 | excel24 | lattice24 | ironcalc24 | hyperformula#VALUE! | libreoffice#NAME? | formulas24 | pycel#NAME? |
date/8b84e8 |
=ISOWEEKNUM("2023-01-01") |
52 | gsheets52 | excel52 | lattice52 | ironcalc52 | hyperformula#VALUE! | libreoffice#NAME? | formulas52 | pycel#NAME? |
date/e16816 |
=ISOWEEKNUM("2024-01-01") |
1 | gsheets1 | excel1 | lattice1 | ironcalc1 | hyperformula#VALUE! | libreoffice#NAME? | formulas1 | pycel#NAME? |
divergences/9110de |
=SWITCH(1, 1, "yes") |
yes | gsheetsyes | excelyes | latticeyes | ironcalcyes | hyperformulayes | libreoffice#NAME? | formulasyes | pycel#NAME? |
divergences/731045 |
=SWITCH(99, 1, "one", "default") |
default | gsheetsdefault | exceldefault | latticedefault | ironcalcdefault | hyperformuladefault | libreoffice#NAME? | formulasdefault | pycel#NAME? |
financial-timevalue/983081 |
=PDURATION(0.1, 1000, 2000) |
7.272541 | gsheets7.27254 | excel7.27254 | lattice7.27254 | ironcalc7.272540897 | hyperformula7.2725408973 | libreoffice#NAME? | formulas7.27254 | pycel#NAME? |
financial-timevalue/c9beca |
=PDURATION(0.05, 1000, 1000) |
0 | gsheets0 | excel0 | lattice0 | ironcalc0 | hyperformula0 | libreoffice#NAME? | formulas0 | pycel#NAME? |
financial-timevalue/696cf4 |
=PDURATION(0, 1000, 2000) |
#NUM! | gsheets#NUM! | excel#NUM! | lattice#NUM! | ironcalc#NUM! | hyperformula#NUM! | libreoffice#NAME? | formulas#NUM! | pycel#NAME? |
financial-timevalue/f1c545 |
=RRI(8, 1, 2) |
0.090508 | gsheets0.0905077 | excel0.0905077 | lattice0.0905077 | ironcalc0.090507733 | hyperformula0.0905077 | libreoffice#NAME? | formulas0.0905077 | pycel#NAME? |
financial-timevalue/9d7de9 |
=RRI(5, 1000, 1000) |
0 | gsheets0 | excel0 | lattice0 | ironcalc0 | hyperformula0 | libreoffice#NAME? | formulas0 | pycel#NAME? |
info/e30cb1 |
=ISFORMULA(A1) |
true | gsheetstrue | exceltrue | lattice#VALUE! | ironcalctrue | hyperformulatrue | libreoffice#NAME? | formulastrue | pycel#NAME? |
info/08e9f8 |
=ISFORMULA(A1) |
false | gsheetsfalse | excelfalse | lattice#VALUE! | ironcalcfalse | hyperformulafalse | libreoffice#NAME? | formulasfalse | pycel#NAME? |
info/6074fe |
=ISFORMULA(A1) |
false | gsheetsfalse | excelfalse | lattice#VALUE! | ironcalcfalse | hyperformulafalse | libreoffice#NAME? | formulasfalse | pycel#NAME? |
info/0b6ab6 |
=ISFORMULA(A1) |
false | gsheetsfalse | excelfalse | lattice#VALUE! | ironcalcfalse | hyperformulafalse | libreoffice#NAME? | formulasfalse | pycel#NAME? |
logical/84569a |
=SWITCH(1, 1, "one", 2, "two") |
one | gsheetsone | excelone | latticeone | ironcalcone | hyperformulaone | libreoffice#NAME? | formulasone | pycel#NAME? |
logical/ef86ac |
=SWITCH(2, 1, "one", 2, "two") |
two | gsheetstwo | exceltwo | latticetwo | ironcalctwo | hyperformulatwo | libreoffice#NAME? | formulastwo | pycel#NAME? |
logical/0b3ad8 |
=SWITCH(99, 1, "one", 2, "two", "other") |
other | gsheetsother | excelother | latticeother | ironcalcother | hyperformulaother | libreoffice#NAME? | formulasother | pycel#NAME? |
logical/e5fe7a |
=SWITCH(99, 1, "one", 2, "two") |
#N/A | gsheets#N/A | excel#N/A | lattice#N/A | ironcalc#N/A | hyperformula#N/A | libreoffice#NAME? | formulas#N/A | pycel#NAME? |
lookup/a8f9e7 |
=XLOOKUP(2, A1:A3, B1:B3) |
banana | gsheetsbanana | excelbanana | latticebanana | ironcalcbanana | hyperformulabanana | libreoffice#NAME? | formulasbanana | pycel#NAME? |
lookup/63f481 |
=XLOOKUP(99, A1:A2, B1:B2, "missing") |
missing | gsheetsmissing | excelmissing | latticemissing | ironcalcmissing | hyperformulamissing | libreoffice#NAME? | formulasmissing | pycel#NAME? |
math-longtail/5aff8a |
=SEC(0) |
1 | gsheets1 | excel1 | lattice1 | ironcalc1 | hyperformula1 | libreoffice#NAME? | formulas1 | pycel#NAME? |
math-longtail/0a1220 |
=SEC(PI()) |
-1 | gsheets-1 | excel-1 | lattice-1 | ironcalc-1 | hyperformula-1 | libreoffice#NAME? | formulas-1 | pycel#NAME? |
math-longtail/75c849 |
=SEC(-PI()) |
-1 | gsheets-1 | excel-1 | lattice-1 | ironcalc-1 | hyperformula-1 | libreoffice#NAME? | formulas-1 | pycel#NAME? |
math-longtail/5c1bed |
=CSC(PI()/2) |
1 | gsheets1 | excel1 | lattice1 | ironcalc1 | hyperformula1 | libreoffice#NAME? | formulas1 | pycel#NAME? |
math-longtail/afa336 |
=CSC(-PI()/2) |
-1 | gsheets-1 | excel-1 | lattice-1 | ironcalc-1 | hyperformula-1 | libreoffice#NAME? | formulas-1 | pycel#NAME? |
math-longtail/aa3903 |
=SECH(0) |
1 | gsheets1 | excel1 | lattice1 | ironcalc1 | hyperformula1 | libreoffice#NAME? | formulas1 | pycel#NAME? |
math-longtail/1e86bf |
=ACOTH(1) |
#NUM! | gsheets#NUM! | excel#NUM! | lattice#NUM! | ironcalc#NUM! | hyperformula#NUM! | libreoffice#NAME? | formulas#NUM! | pycel#NAME? |
math-longtail/ed68a5 |
=DECIMAL("A", 16) |
10 | gsheets10 | excel10 | lattice10 | ironcalc10 | hyperformula10 | libreoffice#NAME? | formulas10 | pycel#NAME? |
math-longtail/6f52fa |
=DECIMAL("101", 2) |
5 | gsheets5 | excel5 | lattice5 | ironcalc5 | hyperformula5 | libreoffice#NAME? | formulas5 | pycel#NAME? |
math-longtail/79442c |
=DECIMAL("FF", 16) |
255 | gsheets255 | excel255 | lattice255 | ironcalc255 | hyperformula255 | libreoffice#NAME? | formulas255 | pycel#NAME? |
math-longtail/4786a0 |
=DECIMAL("Z", 36) |
35 | gsheets35 | excel35 | lattice35 | ironcalc35 | hyperformula35 | libreoffice#NAME? | formulas35 | pycel#NAME? |
math-longtail/2db02c |
=GAMMALN.PRECISE(1) |
0 | gsheets0 | excel0 | lattice0 | ironcalc-4.441e-16 | hyperformula0 | libreoffice#NAME? | formulas0 | pycel#NAME? |
math-longtail/df7aba |
=GAMMALN.PRECISE(2) |
0 | gsheets0 | excel0 | lattice0 | ironcalc0 | hyperformula-4.441e-16 | libreoffice#NAME? | formulas0 | pycel#NAME? |
statistical-analytics/97f567 |
=COVARIANCE.S(A1:A5, B1:B5) |
1.5 | gsheets1.5 | excel1.5 | lattice1.5 | ironcalc1.5 | hyperformula1.5 | libreoffice#NAME? | formulas1.5 | pycel#NAME? |
statistical-analytics/a2fe62 |
=COVARIANCE.S(A1:A3, B1:B3) |
2 | gsheets2 | excel2 | lattice2 | ironcalc2 | hyperformula2 | libreoffice#NAME? | formulas2 | pycel#NAME? |
statistical-analytics/c939de |
=SKEW.P(A1:A5) |
0 | gsheets0 | excel0 | lattice0 | ironcalc0 | hyperformula0 | libreoffice#NAME? | formulas0 | pycel#NAME? |
statistical-analytics/fe904d |
=Z.TEST(A1:A5, 3) |
0.5 | gsheets0.5 | excel0.5 | lattice#VALUE! | ironcalc0.5 | hyperformula0.5 | libreoffice#NAME? | formulas0.5 | pycel#NAME? |
statistical-descriptive/44b2fb |
=STDEV.S(5, 5, 5) |
0 | gsheets0 | excel0 | lattice0 | ironcalc0 | hyperformula0 | libreoffice#NAME? | formulas0 | pycel#NAME? |
statistical-descriptive/4768d6 |
=STDEV.S(5) |
#DIV/0! | gsheets#DIV/0! | excel#DIV/0! | lattice#DIV/0! | ironcalc#DIV/0! | hyperformula#DIV/0! | libreoffice#NAME? | formulas#DIV/0! | pycel#NAME? |
statistical-descriptive/ee1669 |
=STDEV.P(2, 6) |
2 | gsheets2 | excel2 | lattice2 | ironcalc2 | hyperformula2 | libreoffice#NAME? | formulas2 | pycel#NAME? |
statistical-descriptive/68e086 |
=STDEV.P(5, 5, 5) |
0 | gsheets0 | excel0 | lattice0 | ironcalc0 | hyperformula0 | libreoffice#NAME? | formulas0 | pycel#NAME? |
statistical-descriptive/7f544d |
=VAR.S(A1:A5) |
2.5 | gsheets2.5 | excel2.5 | lattice2.5 | ironcalc2.5 | hyperformula2.5 | libreoffice#NAME? | formulas2.5 | pycel#NAME? |
statistical-descriptive/6f3293 |
=VAR.S(5, 5, 5) |
0 | gsheets0 | excel0 | lattice0 | ironcalc0 | hyperformula0 | libreoffice#NAME? | formulas0 | pycel#NAME? |
statistical-descriptive/d30956 |
=VAR.S(5) |
#DIV/0! | gsheets#DIV/0! | excel#DIV/0! | lattice#DIV/0! | ironcalc#DIV/0! | hyperformula#DIV/0! | libreoffice#NAME? | formulas#DIV/0! | pycel#NAME? |
statistical-descriptive/4fe005 |
=VAR.P(A1:A5) |
2 | gsheets2 | excel2 | lattice2 | ironcalc2 | hyperformula2 | libreoffice#NAME? | formulas2 | pycel#NAME? |
statistical-descriptive/99090b |
=VAR.P(2, 6) |
4 | gsheets4 | excel4 | lattice4 | ironcalc4 | hyperformula4 | libreoffice#NAME? | formulas4 | pycel#NAME? |
statistical-descriptive/f79d1f |
=VAR.P(5, 5, 5) |
0 | gsheets0 | excel0 | lattice0 | ironcalc0 | hyperformula0 | libreoffice#NAME? | formulas0 | pycel#NAME? |
statistical-distributions/6be05f |
=BINOM.INV(10, 0.5, 0.5) |
5 | gsheets5 | excel5 | lattice5 | ironcalc5 | hyperformula5 | libreoffice#NAME? | formulas5 | pycel#NAME? |
statistical-distributions/f37fd2 |
=BINOM.INV(20, 0.3, 0.95) |
9 | gsheets9 | excel9 | lattice9 | ironcalc9 | hyperformula9 | libreoffice#NAME? | formulas9 | pycel#NAME? |
statistical-distributions/216393 |
=CHISQ.TEST(A1:B2, A4:B5) |
1 | gsheets1 | excel1 | lattice1 | ironcalc1 | hyperformula1 | libreoffice#NAME? | formulas1 | pycel#NAME? |
statistical-distributions/6f64cb |
=GAUSS(0) |
0 | gsheets0 | excel0 | lattice0 | ironcalc0 | hyperformula0 | libreoffice#NAME? | formulas0 | pycel#NAME? |
statistical-distributions/38f50d |
=LOGNORM.INV(0.5, 0, 1) |
1 | gsheets1 | excel1 | lattice1 | ironcalc1 | hyperformula1 | libreoffice#NAME? | formulas1 | pycel#NAME? |
statistical-distributions/8d7bbe |
=NORM.INV(0.5, 0, 1) |
0 | gsheets0 | excel0 | lattice0 | ironcalc0 | hyperformula-7.681e-17 | libreoffice#NAME? | formulas0 | pycel#NAME? |
statistical-distributions/679343 |
=NORM.S.INV(0.5) |
0 | gsheets0 | excel0 | lattice0 | ironcalc0 | hyperformula-7.681e-17 | libreoffice#NAME? | formulas0 | pycel#NAME? |
statistical-distributions/b819dc |
=T.DIST.RT(0, 10) |
0.5 | gsheets0.5 | excel0.5 | lattice0.5 | ironcalc0.5 | hyperformula0.5 | libreoffice#NAME? | formulas0.5 | pycel#NAME? |
statistical-distributions/8e4c28 |
=T.INV(0.5, 10) |
0 | gsheets0 | excel0 | lattice0 | ironcalc0 | hyperformula0 | libreoffice#NAME? | formulas0 | pycel#NAME? |
text-longtail/40ec6d |
=ARABIC("XIV") |
14 | gsheets14 | excel14 | lattice14 | ironcalc14 | hyperformula14 | libreoffice#NAME? | formulas14 | pycel#NAME? |
text-longtail/ff6cd0 |
=ARABIC("MCMXCIV") |
1994 | gsheets1994 | excel1994 | lattice1994 | ironcalc1994 | hyperformula1994 | libreoffice#NAME? | formulas1994 | pycel#NAME? |
text-longtail/263f63 |
=ARABIC("") |
0 | gsheets0 | excel0 | lattice0 | ironcalc0 | hyperformula0 | libreoffice#NAME? | formulas0 | pycel#NAME? |
text-longtail/ff939a |
=ARABIC("xiv") |
14 | gsheets14 | excel14 | lattice14 | ironcalc14 | hyperformula14 | libreoffice#NAME? | formulas14 | pycel#NAME? |
text-longtail/5f0592 |
=UNICODE("A") |
65 | gsheets65 | excel65 | lattice65 | ironcalc65 | hyperformula65 | libreoffice#NAME? | formulas65 | pycel#NAME? |
text-longtail/43aebb |
=UNICODE("☃") |
9731 | gsheets9731 | excel9731 | lattice9731 | ironcalc9731 | hyperformula9731 | libreoffice#NAME? | formulas9731 | pycel#NAME? |
text-longtail/379dba |
=UNICODE("♥") |
9829 | gsheets9829 | excel9829 | lattice9829 | ironcalc9829 | hyperformula9829 | libreoffice#NAME? | formulas9829 | pycel#NAME? |
text-longtail/19ec47 |
=UNICODE("Alphabet") |
65 | gsheets65 | excel65 | lattice65 | ironcalc65 | hyperformula65 | libreoffice#NAME? | formulas65 | pycel#NAME? |