assay

DV-0005

ironcalc, pycel: function not implemented — ADDRESS, CHAR, CLEAN (+17 more)

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

Subjects (20)

ADDRESS CHAR CLEAN CODE CRITBINOM FVSCHEDULE LOGINV LOGNORMDIST MMULT MULTINOMIAL NORMINV NORMSDIST NORMSINV PROPER STDEV STDEVP TRANSPOSE VAR VARP ZTEST

Tests (55)

matches canonical diverges no fixture in this DV's cluster

Test Formula Canonical gsheets excel lattice ironcalc hyperformula libreoffice formulas pycel
TRANSPOSE/transpose-row-to-col =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} libreoffice— formulas{1; 2; 3} pycel#NAME?
TRANSPOSE/transpose-col-to-row =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} libreoffice— formulas{1, 2, 3} pycel#NAME?
TRANSPOSE/transpose-2x2 =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} libreoffice— formulas{1, 3; 2, 4} pycel#NAME?
TRANSPOSE/transpose-from-grid =TRANSPOSE(A1:C1) {1; 2; 3} gsheets{1; 2; 3} excel{1; 2; 3} lattice{1; 2; 3} ironcalc#NAME? hyperformula{1; 2; 3} libreoffice— formulas{1; 2; 3} pycel#NAME?
MMULT/mmult-a-times-identity =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} libreoffice— formulas{1, 2; 3, 4} pycel#NAME?
MMULT/mmult-2x2-generic =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} libreoffice— formulas{19, 22; 43, 50} pycel#NAME?
MMULT/mmult-row-by-col =MMULT({1,2,3}, {4;5;6}) 32 gsheets32 excel32 lattice32 ironcalc#NAME? hyperformula32 libreoffice— formulas32 pycel#NAME?
MMULT/mmult-dimension-mismatch =MMULT({1,2}, {1,2}) {#VALUE!, #VALUE!} gsheets#VALUE! excel#VALUE! lattice#VALUE! ironcalc#NAME? hyperformula{#VALUE!, #VALUE!} libreoffice— formulas#VALUE! pycel#NAME?
FVSCHEDULE/fvschedule-three-rates =FVSCHEDULE(1000, {0.05, 0.06, 0.07}) 1191.51 gsheets1190.91 excel1190.91 lattice1190.91 ironcalc#NAME? hyperformula1190.91 libreoffice— formulas1190.91 pycel#NAME?
FVSCHEDULE/fvschedule-zero-rate-in-schedule =FVSCHEDULE(1000, {0.1, 0, 0.1}) 1210 gsheets1210 excel1210 lattice1210 ironcalc#NAME? hyperformula1210 libreoffice— formulas1210.00 pycel#NAME?
FVSCHEDULE/fvschedule-single-rate =FVSCHEDULE(500, {0.1}) 550 gsheets550 excel550 lattice550 ironcalc#NAME? hyperformula550 libreoffice— formulas550 pycel#NAME?
ADDRESS/address-absolute-a1 =ADDRESS(1,1) $A$1 gsheets$A$1 excel$A$1 lattice$A$1 ironcalc#NAME? hyperformula$A$1 libreoffice— formulas$A$1 pycel#NAME?
ADDRESS/address-relative =ADDRESS(1,1,4) A1 gsheetsA1 excelA1 latticeA1 ironcalc#NAME? hyperformulaA1 libreoffice— formulasA1 pycel#NAME?
ADDRESS/address-row-absolute =ADDRESS(2,3,2) C$2 gsheetsC$2 excelC$2 latticeC$2 ironcalc#NAME? hyperformulaC$2 libreoffice— formulasC$2 pycel#NAME?
ADDRESS/address-col-absolute =ADDRESS(2,3,3) $C2 gsheets$C2 excel$C2 lattice$C2 ironcalc#NAME? hyperformula$C2 libreoffice— formulas$C2 pycel#NAME?
ADDRESS/address-column-z =ADDRESS(5,26,4) Z5 gsheetsZ5 excelZ5 latticeZ5 ironcalc#NAME? hyperformulaZ5 libreoffice— formulasZ5 pycel#NAME?
ADDRESS/address-column-aa =ADDRESS(1,27,4) AA1 gsheetsAA1 excelAA1 latticeAA1 ironcalc#NAME? hyperformulaAA1 libreoffice— formulasAA1 pycel#NAME?
MULTINOMIAL/multinomial-two =MULTINOMIAL(2, 3) 10 gsheets10 excel10.0000 lattice10 ironcalc#NAME? hyperformula10 libreoffice— formulas10 pycel#NAME?
MULTINOMIAL/multinomial-three =MULTINOMIAL(2, 3, 4) 1260 gsheets1260 excel1260.00 lattice1260 ironcalc#NAME? hyperformula1260 libreoffice— formulas1260 pycel#NAME?
MULTINOMIAL/multinomial-single =MULTINOMIAL(5) 1 gsheets1 excel1.00000 lattice1 ironcalc#NAME? hyperformula1 libreoffice— formulas1 pycel#NAME?
ZTEST/ztest-canonical =ZTEST(A1:A5, 3) 0.5 gsheets0.5 excel0.5 lattice0.5 ironcalc#NAME? hyperformula0.5 libreoffice— formulas0.5 pycel#NAME?
STDEV/stdev-identical-values =STDEV(5, 5, 5) 0 gsheets0 excel0 lattice0 ironcalc#NAME? hyperformula0 libreoffice— formulas0 pycel#NAME?
STDEV/stdev-single-value =STDEV(5) #DIV/0! gsheets#DIV/0! excel#DIV/0! lattice#DIV/0! ironcalc#NAME? hyperformula#DIV/0! libreoffice— formulas#DIV/0! pycel#NAME?
STDEVP/stdevp-two-values =STDEVP(2, 6) 2 gsheets2 excel2 lattice2 ironcalc#NAME? hyperformula2 libreoffice— formulas2 pycel#NAME?
STDEVP/stdevp-identical =STDEVP(5, 5, 5) 0 gsheets0 excel0 lattice0 ironcalc#NAME? hyperformula0 libreoffice— formulas0 pycel#NAME?
VAR/var-sample-1-5 =VAR(A1:A5) 2.5 gsheets2.5 excel2.5 lattice2.5 ironcalc#NAME? hyperformula2.5 libreoffice— formulas2.5 pycel#NAME?
VAR/var-two-values =VAR(1, 3) 2 gsheets2 excel2 lattice2 ironcalc#NAME? hyperformula2 libreoffice— formulas2 pycel#NAME?
VAR/var-identical =VAR(5, 5, 5) 0 gsheets0 excel0 lattice0 ironcalc#NAME? hyperformula0 libreoffice— formulas0 pycel#NAME?
VAR/var-single-value =VAR(5) #DIV/0! gsheets#DIV/0! excel#DIV/0! lattice#DIV/0! ironcalc#NAME? hyperformula#DIV/0! libreoffice— formulas#DIV/0! pycel#NAME?
VARP/varp-population-1-5 =VARP(A1:A5) 2 gsheets2 excel2 lattice2 ironcalc#NAME? hyperformula2 libreoffice— formulas2 pycel#NAME?
VARP/varp-two-values =VARP(2, 6) 4 gsheets4 excel4 lattice4 ironcalc#NAME? hyperformula4 libreoffice— formulas4 pycel#NAME?
VARP/varp-identical =VARP(5, 5, 5) 0 gsheets0 excel0 lattice0 ironcalc#NAME? hyperformula0 libreoffice— formulas0 pycel#NAME?
CRITBINOM/critbinom-median =CRITBINOM(10, 0.5, 0.5) 5 gsheets5 excel5 lattice5 ironcalc#NAME? hyperformula5 libreoffice— formulas5 pycel#NAME?
CRITBINOM/critbinom-tail =CRITBINOM(20, 0.3, 0.95) 9 gsheets9 excel9 lattice9 ironcalc#NAME? hyperformula9 libreoffice— formulas9 pycel#NAME?
LOGINV/loginv-at-0-5 =LOGINV(0.5, 0, 1) 1 gsheets1 excel1 lattice1 ironcalc#NAME? hyperformula1 libreoffice— formulas1 pycel#NAME?
LOGNORMDIST/lognormdist-at-1 =LOGNORMDIST(1, 0, 1) 0.5 gsheets0.5 excel0.5 lattice0.5 ironcalc#NAME? hyperformula#N/A libreoffice— formulas0.5 pycel#NAME?
NORMINV/norminv-at-0-5 =NORMINV(0.5, 0, 1) 0 gsheets0 excel0 lattice0 ironcalc#NAME? hyperformula-7.681e-17 libreoffice— formulas0 pycel#NAME?
NORMSDIST/normsdist-at-0 =NORMSDIST(0) 0.5 gsheets0.5 excel0.5 lattice0.5 ironcalc#NAME? hyperformula#N/A libreoffice— formulas0.5 pycel#NAME?
NORMSINV/normsinv-at-0-5 =NORMSINV(0.5) 0 gsheets0 excel0 lattice0 ironcalc#NAME? hyperformula-7.681e-17 libreoffice— formulas0 pycel#NAME?
CHAR/char-uppercase-a =CHAR(65) A gsheetsA excelA latticeA ironcalc#NAME? hyperformulaA libreoffice— formulasA pycel#NAME?
CHAR/char-lowercase-a =CHAR(97) a gsheetsa excela latticea ironcalc#NAME? hyperformulaa libreoffice— formulasa pycel#NAME?
CHAR/char-digit-0 =CHAR(48) 0 gsheets0 excel0 lattice0 ironcalc#NAME? hyperformula0 libreoffice— formulas0 pycel#NAME?
CHAR/char-space =CHAR(32) gsheets excel lattice ironcalc#NAME? hyperformula libreoffice— formulas pycel#NAME?
CLEAN/clean-strips-tab =CLEAN("hello" & CHAR(9) & "world") helloworld gsheetshelloworld excelhelloworld latticehelloworld ironcalc#NAME? hyperformulahelloworld libreoffice— formulashelloworld pycel#NAME?
CLEAN/clean-strips-newline =CLEAN("line1" & CHAR(10) & "line2") line1line2 gsheetsline1line2 excelline1line2 latticeline1line2 ironcalc#NAME? hyperformulaline1line2 libreoffice— formulasline1line2 pycel#NAME?
CLEAN/clean-plain-passthrough =CLEAN("hello world") hello world gsheetshello world excelhello world latticehello world ironcalc#NAME? hyperformulahello world libreoffice— formulashello world pycel#NAME?
CLEAN/clean-empty =CLEAN("") gsheets— excel— lattice ironcalc#NAME? hyperformula libreoffice— formulas— pycel#NAME?
CODE/code-uppercase-a =CODE("A") 65 gsheets65 excel65 lattice65 ironcalc#NAME? hyperformula65 libreoffice— formulas65 pycel#NAME?
CODE/code-lowercase-a =CODE("a") 97 gsheets97 excel97 lattice97 ironcalc#NAME? hyperformula97 libreoffice— formulas97 pycel#NAME?
CODE/code-first-char =CODE("Alphabet") 65 gsheets65 excel65 lattice65 ironcalc#NAME? hyperformula65 libreoffice— formulas65 pycel#NAME?
CODE/code-empty =CODE("") 0 gsheets#VALUE! excel#VALUE! lattice#VALUE! ironcalc#NAME? hyperformula#VALUE! libreoffice— formulas#VALUE! pycel#NAME?
PROPER/proper-hello-world =PROPER("hello world") Hello World gsheetsHello World excelHello World latticeHello World ironcalc#NAME? hyperformulaHello World libreoffice— formulasHello World pycel#NAME?
PROPER/proper-all-caps =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 libreoffice— formulasThis Is A Title pycel#NAME?
PROPER/proper-mixed =PROPER("76BudGet") 76Budget gsheets76Budget excel76Budget lattice76Budget ironcalc#NAME? hyperformula76Budget libreoffice— formulas76Budget pycel#NAME?
PROPER/proper-apostrophe =PROPER("o'brien") O'Brien gsheetsO'Brien excelO'Brien latticeO'Brien ironcalc#NAME? hyperformulaO'Brien libreoffice— formulasO'Brien pycel#NAME?