DV-0005
ironcalc, pycel: function not implemented — ADDRESS, CHAR, CLEAN (+17 more)
Subjects (20)
Tests (55)
matches canonical diverges no fixture in this DV's cluster
| Test | Formula | Canonical | gsheets | excel | lattice | ironcalc | hyperformula | libreoffice | formulas | pycel |
|---|---|---|---|---|---|---|---|---|---|---|
array-longtail/f65a1f |
=TRANSPOSE({1,2,3}) |
[1, 2, 3] | gsheets[1, 2, 3] | excel[1, 2, 3] | lattice[1, 2, 3] | ironcalc#NAME? | hyperformula[1, 2, 3] | libreoffice1 | formulas[1, 2, 3] | pycel#NAME? |
array-longtail/b41aec |
=TRANSPOSE({1;2;3}) |
[1, 2, 3] | gsheets[1, 2, 3] | excel[1, 2, 3] | lattice[1, 2, 3] | ironcalc#NAME? | hyperformula[1, 2, 3] | libreoffice1 | formulas[1, 2, 3] | pycel#NAME? |
array-longtail/4c8b50 |
=TRANSPOSE({1,2;3,4}) |
[1, 3, 2, 4] | gsheets[1, 3, 2, 4] | excel[1, 3, 2, 4] | lattice[1, 3, 2, 4] | ironcalc#NAME? | hyperformula[1, 3, 2, 4] | libreoffice1 | formulas[1, 3, 2, 4] | pycel#NAME? |
array-longtail/126a11 |
=TRANSPOSE(A1:C1) |
[1, 2, 3] | gsheets[1, 2, 3] | excel[1, 2, 3] | lattice[1, 2, 3] | ironcalc#NAME? | hyperformula[1, 2, 3] | libreoffice1 | formulas[1, 2, 3] | pycel#NAME? |
array-longtail/a97912 |
=MMULT({1,2;3,4}, {1,0;0,1}) |
[1, 2, 3, 4] | gsheets[1, 2, 3, 4] | excel[1, 2, 3, 4] | lattice[1, 2, 3, 4] | ironcalc#NAME? | hyperformula[1, 2, 3, 4] | libreoffice1 | formulas[1, 2, 3, 4] | pycel#NAME? |
array-longtail/612f8b |
=MMULT({1,2;3,4}, {5,6;7,8}) |
[19, 22, 43, 50] | gsheets[19, 22, 43, 50] | excel[19, 22, 43, 50] | lattice[19, 22, 43, 50] | ironcalc#NAME? | hyperformula[19, 22, 43, 50] | libreoffice19 | formulas[19, 22, 43, 50] | pycel#NAME? |
array-longtail/cc8a4e |
=MMULT({1,2,3}, {4;5;6}) |
32 | gsheets32 | excel32 | lattice32 | ironcalc#NAME? | hyperformula32 | libreoffice32 | formulas32 | pycel#NAME? |
array-longtail/92945c |
=MMULT({1,2}, {1,2}) |
[#VALUE!, #VALUE!] | gsheets#VALUE! | excel#VALUE! | lattice#VALUE! | ironcalc#NAME? | hyperformula[#VALUE!, #VALUE!] | libreoffice#VALUE! | formulas#VALUE! | pycel#NAME? |
financial-timevalue/1742ab |
=FVSCHEDULE(1000, {0.05, 0.06, 0.07}) |
1191.51 | gsheets1190.91 | excel1190.91 | lattice1190.91 | ironcalc#NAME? | hyperformula1190.91 | libreoffice1190.91 | formulas1190.91 | pycel#NAME? |
financial-timevalue/b9bff1 |
=FVSCHEDULE(1000, {0.1, 0, 0.1}) |
1210 | gsheets1210 | excel1210 | lattice1210 | ironcalc#NAME? | hyperformula1210 | libreoffice1210 | formulas1210.00 | pycel#NAME? |
financial-timevalue/61c9f9 |
=FVSCHEDULE(500, {0.1}) |
550 | gsheets550 | excel550 | lattice550 | ironcalc#NAME? | hyperformula550 | libreoffice550 | formulas550 | pycel#NAME? |
lookup-longtail/b16b29 |
=ADDRESS(1,1) |
$A$1 | gsheets$A$1 | excel$A$1 | lattice$A$1 | ironcalc#NAME? | hyperformula$A$1 | libreoffice$A$1 | formulas$A$1 | pycel#NAME? |
lookup-longtail/354491 |
=ADDRESS(1,1,4) |
A1 | gsheetsA1 | excelA1 | latticeA1 | ironcalc#NAME? | hyperformulaA1 | libreofficeA1 | formulasA1 | pycel#NAME? |
lookup-longtail/5c279f |
=ADDRESS(2,3,2) |
C$2 | gsheetsC$2 | excelC$2 | latticeC$2 | ironcalc#NAME? | hyperformulaC$2 | libreofficeC$2 | formulasC$2 | pycel#NAME? |
lookup-longtail/b31c18 |
=ADDRESS(2,3,3) |
$C2 | gsheets$C2 | excel$C2 | lattice$C2 | ironcalc#NAME? | hyperformula$C2 | libreoffice$C2 | formulas$C2 | pycel#NAME? |
lookup-longtail/fda9c1 |
=ADDRESS(5,26,4) |
Z5 | gsheetsZ5 | excelZ5 | latticeZ5 | ironcalc#NAME? | hyperformulaZ5 | libreofficeZ5 | formulasZ5 | pycel#NAME? |
lookup-longtail/cbc5b1 |
=ADDRESS(1,27,4) |
AA1 | gsheetsAA1 | excelAA1 | latticeAA1 | ironcalc#NAME? | hyperformulaAA1 | libreofficeAA1 | formulasAA1 | pycel#NAME? |
math-longtail/f7a15f |
=MULTINOMIAL(2, 3) |
10 | gsheets10 | excel10.0000 | lattice10 | ironcalc#NAME? | hyperformula10 | libreoffice10 | formulas10 | pycel#NAME? |
math-longtail/525327 |
=MULTINOMIAL(2, 3, 4) |
1260 | gsheets1260 | excel1260.00 | lattice1260 | ironcalc#NAME? | hyperformula1260 | libreoffice1260 | formulas1260 | pycel#NAME? |
math-longtail/bae2b9 |
=MULTINOMIAL(5) |
1 | gsheets1 | excel1.00000 | lattice1 | ironcalc#NAME? | hyperformula1 | libreoffice1 | formulas1 | pycel#NAME? |
statistical-analytics/f5dd88 |
=ZTEST(A1:A5, 3) |
0.5 | gsheets0.5 | excel0.5 | lattice0.5 | ironcalc#NAME? | hyperformula0.5 | libreoffice0.5 | formulas0.5 | pycel#NAME? |
statistical-descriptive/ec6deb |
=STDEV(5, 5, 5) |
0 | gsheets0 | excel0 | lattice0 | ironcalc#NAME? | hyperformula0 | libreoffice0 | formulas0 | pycel#NAME? |
statistical-descriptive/f4d5c5 |
=STDEV(5) |
#DIV/0! | gsheets#DIV/0! | excel#DIV/0! | lattice#DIV/0! | ironcalc#NAME? | hyperformula#DIV/0! | libreoffice#DIV/0! | formulas#DIV/0! | pycel#NAME? |
statistical-descriptive/7937fd |
=STDEVP(2, 6) |
2 | gsheets2 | excel2 | lattice2 | ironcalc#NAME? | hyperformula2 | libreoffice2 | formulas2 | pycel#NAME? |
statistical-descriptive/c61ac0 |
=STDEVP(5, 5, 5) |
0 | gsheets0 | excel0 | lattice0 | ironcalc#NAME? | hyperformula0 | libreoffice0 | formulas0 | pycel#NAME? |
statistical-descriptive/81698e |
=VAR(A1:A5) |
2.5 | gsheets2.5 | excel2.5 | lattice2.5 | ironcalc#NAME? | hyperformula2.5 | libreoffice2.5 | formulas2.5 | pycel#NAME? |
statistical-descriptive/6cb13d |
=VAR(1, 3) |
2 | gsheets2 | excel2 | lattice2 | ironcalc#NAME? | hyperformula2 | libreoffice2 | formulas2 | pycel#NAME? |
statistical-descriptive/d31acb |
=VAR(5, 5, 5) |
0 | gsheets0 | excel0 | lattice0 | ironcalc#NAME? | hyperformula0 | libreoffice0 | formulas0 | pycel#NAME? |
statistical-descriptive/c9b44a |
=VAR(5) |
#DIV/0! | gsheets#DIV/0! | excel#DIV/0! | lattice#DIV/0! | ironcalc#NAME? | hyperformula#DIV/0! | libreoffice#DIV/0! | formulas#DIV/0! | pycel#NAME? |
statistical-descriptive/9a46e4 |
=VARP(A1:A5) |
2 | gsheets2 | excel2 | lattice2 | ironcalc#NAME? | hyperformula2 | libreoffice2 | formulas2 | pycel#NAME? |
statistical-descriptive/8a831f |
=VARP(2, 6) |
4 | gsheets4 | excel4 | lattice4 | ironcalc#NAME? | hyperformula4 | libreoffice4 | formulas4 | pycel#NAME? |
statistical-descriptive/0910af |
=VARP(5, 5, 5) |
0 | gsheets0 | excel0 | lattice0 | ironcalc#NAME? | hyperformula0 | libreoffice0 | formulas0 | pycel#NAME? |
statistical-distributions/50b095 |
=CRITBINOM(10, 0.5, 0.5) |
5 | gsheets5 | excel5 | lattice5 | ironcalc#NAME? | hyperformula5 | libreoffice5 | formulas5 | pycel#NAME? |
statistical-distributions/fa0704 |
=CRITBINOM(20, 0.3, 0.95) |
9 | gsheets9 | excel9 | lattice9 | ironcalc#NAME? | hyperformula9 | libreoffice9 | formulas9 | pycel#NAME? |
statistical-distributions/9f865c |
=LOGINV(0.5, 0, 1) |
1 | gsheets1 | excel1 | lattice1 | ironcalc#NAME? | hyperformula1 | libreoffice1 | formulas1 | pycel#NAME? |
statistical-distributions/fb6e20 |
=LOGNORMDIST(1, 0, 1) |
0.5 | gsheets0.5 | excel0.5 | lattice0.5 | ironcalc#NAME? | hyperformula#N/A | libreoffice0.5 | formulas0.5 | pycel#NAME? |
statistical-distributions/86dcd2 |
=NORMINV(0.5, 0, 1) |
0 | gsheets0 | excel0 | lattice0 | ironcalc#NAME? | hyperformula-7.681e-17 | libreoffice0 | formulas0 | pycel#NAME? |
statistical-distributions/2075c8 |
=NORMSDIST(0) |
0.5 | gsheets0.5 | excel0.5 | lattice0.5 | ironcalc#NAME? | hyperformula#N/A | libreoffice0.5 | formulas0.5 | pycel#NAME? |
statistical-distributions/292a2e |
=NORMSINV(0.5) |
0 | gsheets0 | excel0 | lattice0 | ironcalc#NAME? | hyperformula-7.681e-17 | libreoffice0 | formulas0 | pycel#NAME? |
text-longtail/92ae07 |
=CHAR(65) |
A | gsheetsA | excelA | latticeA | ironcalc#NAME? | hyperformulaA | libreofficeA | formulasA | pycel#NAME? |
text-longtail/c2316b |
=CHAR(97) |
a | gsheetsa | excela | latticea | ironcalc#NAME? | hyperformulaa | libreofficea | formulasa | pycel#NAME? |
text-longtail/068a35 |
=CHAR(48) |
0 | gsheets0 | excel0 | lattice0 | ironcalc#NAME? | hyperformula0 | libreoffice0 | formulas0 | pycel#NAME? |
text-longtail/e1bac5 |
=CHAR(32) |
gsheets | excel | lattice | ironcalc#NAME? | hyperformula | libreoffice | formulas | pycel#NAME? | |
text-longtail/642c37 |
=CLEAN("hello" & CHAR(9) & "world") |
helloworld | gsheetshelloworld | excelhelloworld | latticehelloworld | ironcalc#NAME? | hyperformulahelloworld | libreofficehelloworld | formulashelloworld | pycel#NAME? |
text-longtail/0c7a32 |
=CLEAN("line1" & CHAR(10) & "line2") |
line1line2 | gsheetsline1line2 | excelline1line2 | latticeline1line2 | ironcalc#NAME? | hyperformulaline1line2 | libreofficeline1line2 | formulasline1line2 | pycel#NAME? |
text-longtail/cfe703 |
=CLEAN("hello world") |
hello world | gsheetshello world | excelhello world | latticehello world | ironcalc#NAME? | hyperformulahello world | libreofficehello world | formulashello world | pycel#NAME? |
text-longtail/ebc46f |
=CLEAN("") |
gsheets— | excel— | lattice | ironcalc#NAME? | hyperformula | libreoffice— | formulas— | pycel#NAME? | |
text-longtail/d2a5b5 |
=CODE("A") |
65 | gsheets65 | excel65 | lattice65 | ironcalc#NAME? | hyperformula65 | libreoffice65 | formulas65 | pycel#NAME? |
text-longtail/3d3776 |
=CODE("a") |
97 | gsheets97 | excel97 | lattice97 | ironcalc#NAME? | hyperformula97 | libreoffice97 | formulas97 | pycel#NAME? |
text-longtail/b67498 |
=CODE("Alphabet") |
65 | gsheets65 | excel65 | lattice65 | ironcalc#NAME? | hyperformula65 | libreoffice65 | formulas65 | pycel#NAME? |
text-longtail/1d5c13 |
=CODE("") |
0 | gsheets#VALUE! | excel#VALUE! | lattice#VALUE! | ironcalc#NAME? | hyperformula#VALUE! | libreoffice0 | formulas#VALUE! | pycel#NAME? |
text-longtail/c884ea |
=PROPER("hello world") |
Hello World | gsheetsHello World | excelHello World | latticeHello World | ironcalc#NAME? | hyperformulaHello World | libreofficeHello World | formulasHello World | pycel#NAME? |
text-longtail/7ce6cd |
=PROPER("THIS IS A TITLE") |
This Is A Title | gsheetsThis Is A Title | excelThis Is A Title | latticeThis Is A Title | ironcalc#NAME? | hyperformulaThis Is A Title | libreofficeThis Is A Title | formulasThis Is A Title | pycel#NAME? |
text-longtail/a5d880 |
=PROPER("76BudGet") |
76Budget | gsheets76Budget | excel76Budget | lattice76Budget | ironcalc#NAME? | hyperformula76Budget | libreoffice76Budget | formulas76Budget | pycel#NAME? |
text-longtail/219a88 |
=PROPER("o'brien") |
O'Brien | gsheetsO'Brien | excelO'Brien | latticeO'Brien | ironcalc#NAME? | hyperformulaO'Brien | libreofficeO'Brien | formulasO'Brien | pycel#NAME? |