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{[object Object]; [object Object]; [object Object]} excel{[object Object]; [object Object]; [object Object]} 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{[object Object], [object Object], [object Object]} excel{[object Object], [object Object], [object Object]} 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{[object Object], [object Object]; [object Object], [object Object]} excel{[object Object], [object Object]; [object Object], [object Object]} 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{[object Object]; [object Object]; [object Object]} excel{[object Object]; [object Object]; [object Object]} 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{[object Object], [object Object]; [object Object], [object Object]} excel{[object Object], [object Object]; [object Object], [object Object]} 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{[object Object], [object Object]; [object Object], [object Object]} excel{[object Object], [object Object]; [object Object], [object Object]} 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 gsheets[object Object] excel[object Object] lattice32 ironcalc#NAME? hyperformula32 libreoffice— formulas32 pycel#NAME?
MMULT/mmult-dimension-mismatch =MMULT({1,2}, {1,2}) {#VALUE!, #VALUE!} gsheets[object Object] excel[object Object] 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 gsheets[object Object] excel[object Object] 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 gsheets[object Object] excel[object Object] lattice1210 ironcalc#NAME? hyperformula1210 libreoffice— formulas1210.00 pycel#NAME?
FVSCHEDULE/fvschedule-single-rate =FVSCHEDULE(500, {0.1}) 550 gsheets[object Object] excel[object Object] lattice550 ironcalc#NAME? hyperformula550 libreoffice— formulas550 pycel#NAME?
ADDRESS/address-absolute-a1 =ADDRESS(1,1) $A$1 gsheets[object Object] excel[object Object] lattice$A$1 ironcalc#NAME? hyperformula$A$1 libreoffice— formulas$A$1 pycel#NAME?
ADDRESS/address-relative =ADDRESS(1,1,4) A1 gsheets[object Object] excel[object Object] latticeA1 ironcalc#NAME? hyperformulaA1 libreoffice— formulasA1 pycel#NAME?
ADDRESS/address-row-absolute =ADDRESS(2,3,2) C$2 gsheets[object Object] excel[object Object] latticeC$2 ironcalc#NAME? hyperformulaC$2 libreoffice— formulasC$2 pycel#NAME?
ADDRESS/address-col-absolute =ADDRESS(2,3,3) $C2 gsheets[object Object] excel[object Object] lattice$C2 ironcalc#NAME? hyperformula$C2 libreoffice— formulas$C2 pycel#NAME?
ADDRESS/address-column-z =ADDRESS(5,26,4) Z5 gsheets[object Object] excel[object Object] latticeZ5 ironcalc#NAME? hyperformulaZ5 libreoffice— formulasZ5 pycel#NAME?
ADDRESS/address-column-aa =ADDRESS(1,27,4) AA1 gsheets[object Object] excel[object Object] latticeAA1 ironcalc#NAME? hyperformulaAA1 libreoffice— formulasAA1 pycel#NAME?
MULTINOMIAL/multinomial-two =MULTINOMIAL(2, 3) 10 gsheets[object Object] excel[object Object] lattice10 ironcalc#NAME? hyperformula10 libreoffice— formulas10 pycel#NAME?
MULTINOMIAL/multinomial-three =MULTINOMIAL(2, 3, 4) 1260 gsheets[object Object] excel[object Object] lattice1260 ironcalc#NAME? hyperformula1260 libreoffice— formulas1260 pycel#NAME?
MULTINOMIAL/multinomial-single =MULTINOMIAL(5) 1 gsheets[object Object] excel[object Object] lattice1 ironcalc#NAME? hyperformula1 libreoffice— formulas1 pycel#NAME?
ZTEST/ztest-canonical =ZTEST(A1:A5, 3) 0.5 gsheets[object Object] excel[object Object] lattice0.5 ironcalc#NAME? hyperformula0.5 libreoffice— formulas0.5 pycel#NAME?
STDEV/stdev-identical-values =STDEV(5, 5, 5) 0 gsheets[object Object] excel[object Object] lattice0 ironcalc#NAME? hyperformula0 libreoffice— formulas0 pycel#NAME?
STDEV/stdev-single-value =STDEV(5) #DIV/0! gsheets[object Object] excel[object Object] lattice#DIV/0! ironcalc#NAME? hyperformula#DIV/0! libreoffice— formulas#DIV/0! pycel#NAME?
STDEVP/stdevp-two-values =STDEVP(2, 6) 2 gsheets[object Object] excel[object Object] lattice2 ironcalc#NAME? hyperformula2 libreoffice— formulas2 pycel#NAME?
STDEVP/stdevp-identical =STDEVP(5, 5, 5) 0 gsheets[object Object] excel[object Object] lattice0 ironcalc#NAME? hyperformula0 libreoffice— formulas0 pycel#NAME?
VAR/var-sample-1-5 =VAR(A1:A5) 2.5 gsheets[object Object] excel[object Object] lattice2.5 ironcalc#NAME? hyperformula2.5 libreoffice— formulas2.5 pycel#NAME?
VAR/var-two-values =VAR(1, 3) 2 gsheets[object Object] excel[object Object] lattice2 ironcalc#NAME? hyperformula2 libreoffice— formulas2 pycel#NAME?
VAR/var-identical =VAR(5, 5, 5) 0 gsheets[object Object] excel[object Object] lattice0 ironcalc#NAME? hyperformula0 libreoffice— formulas0 pycel#NAME?
VAR/var-single-value =VAR(5) #DIV/0! gsheets[object Object] excel[object Object] lattice#DIV/0! ironcalc#NAME? hyperformula#DIV/0! libreoffice— formulas#DIV/0! pycel#NAME?
VARP/varp-population-1-5 =VARP(A1:A5) 2 gsheets[object Object] excel[object Object] lattice2 ironcalc#NAME? hyperformula2 libreoffice— formulas2 pycel#NAME?
VARP/varp-two-values =VARP(2, 6) 4 gsheets[object Object] excel[object Object] lattice4 ironcalc#NAME? hyperformula4 libreoffice— formulas4 pycel#NAME?
VARP/varp-identical =VARP(5, 5, 5) 0 gsheets[object Object] excel[object Object] lattice0 ironcalc#NAME? hyperformula0 libreoffice— formulas0 pycel#NAME?
CRITBINOM/critbinom-median =CRITBINOM(10, 0.5, 0.5) 5 gsheets[object Object] excel[object Object] lattice5 ironcalc#NAME? hyperformula5 libreoffice— formulas5 pycel#NAME?
CRITBINOM/critbinom-tail =CRITBINOM(20, 0.3, 0.95) 9 gsheets[object Object] excel[object Object] lattice9 ironcalc#NAME? hyperformula9 libreoffice— formulas9 pycel#NAME?
LOGINV/loginv-at-0-5 =LOGINV(0.5, 0, 1) 1 gsheets[object Object] excel[object Object] lattice1 ironcalc#NAME? hyperformula1 libreoffice— formulas1 pycel#NAME?
LOGNORMDIST/lognormdist-at-1 =LOGNORMDIST(1, 0, 1) 0.5 gsheets[object Object] excel[object Object] lattice0.5 ironcalc#NAME? hyperformula#N/A libreoffice— formulas0.5 pycel#NAME?
NORMINV/norminv-at-0-5 =NORMINV(0.5, 0, 1) 0 gsheets[object Object] excel[object Object] lattice0 ironcalc#NAME? hyperformula-7.681e-17 libreoffice— formulas0 pycel#NAME?
NORMSDIST/normsdist-at-0 =NORMSDIST(0) 0.5 gsheets[object Object] excel[object Object] lattice0.5 ironcalc#NAME? hyperformula#N/A libreoffice— formulas0.5 pycel#NAME?
NORMSINV/normsinv-at-0-5 =NORMSINV(0.5) 0 gsheets[object Object] excel[object Object] lattice0 ironcalc#NAME? hyperformula-7.681e-17 libreoffice— formulas0 pycel#NAME?
CHAR/char-uppercase-a =CHAR(65) A gsheets[object Object] excel[object Object] latticeA ironcalc#NAME? hyperformulaA libreoffice— formulasA pycel#NAME?
CHAR/char-lowercase-a =CHAR(97) a gsheets[object Object] excel[object Object] latticea ironcalc#NAME? hyperformulaa libreoffice— formulasa pycel#NAME?
CHAR/char-digit-0 =CHAR(48) 0 gsheets[object Object] excel[object Object] lattice0 ironcalc#NAME? hyperformula0 libreoffice— formulas0 pycel#NAME?
CHAR/char-space =CHAR(32) gsheets[object Object] excel[object Object] lattice ironcalc#NAME? hyperformula libreoffice— formulas pycel#NAME?
CLEAN/clean-strips-tab =CLEAN("hello" & CHAR(9) & "world") helloworld gsheets[object Object] excel[object Object] latticehelloworld ironcalc#NAME? hyperformulahelloworld libreoffice— formulashelloworld pycel#NAME?
CLEAN/clean-strips-newline =CLEAN("line1" & CHAR(10) & "line2") line1line2 gsheets[object Object] excel[object Object] latticeline1line2 ironcalc#NAME? hyperformulaline1line2 libreoffice— formulasline1line2 pycel#NAME?
CLEAN/clean-plain-passthrough =CLEAN("hello world") hello world gsheets[object Object] excel[object Object] latticehello world ironcalc#NAME? hyperformulahello world libreoffice— formulashello world pycel#NAME?
CLEAN/clean-empty =CLEAN("") gsheets[object Object] excel[object Object] lattice— ironcalc— hyperformula— libreoffice— formulas— pycel—
CODE/code-uppercase-a =CODE("A") 65 gsheets[object Object] excel[object Object] lattice65 ironcalc#NAME? hyperformula65 libreoffice— formulas65 pycel#NAME?
CODE/code-lowercase-a =CODE("a") 97 gsheets[object Object] excel[object Object] lattice97 ironcalc#NAME? hyperformula97 libreoffice— formulas97 pycel#NAME?
CODE/code-first-char =CODE("Alphabet") 65 gsheets[object Object] excel[object Object] lattice65 ironcalc#NAME? hyperformula65 libreoffice— formulas65 pycel#NAME?
CODE/code-empty =CODE("") 0 gsheets[object Object] excel[object Object] lattice#VALUE! ironcalc#NAME? hyperformula#VALUE! libreoffice— formulas#VALUE! pycel#NAME?
PROPER/proper-hello-world =PROPER("hello world") Hello World gsheets[object Object] excel[object Object] latticeHello World ironcalc#NAME? hyperformulaHello World libreoffice— formulasHello World pycel#NAME?
PROPER/proper-all-caps =PROPER("THIS IS A TITLE") This Is A Title gsheets[object Object] excel[object Object] latticeThis Is A Title ironcalc#NAME? hyperformulaThis Is A Title libreoffice— formulasThis Is A Title pycel#NAME?
PROPER/proper-mixed =PROPER("76BudGet") 76Budget gsheets[object Object] excel[object Object] lattice76Budget ironcalc#NAME? hyperformula76Budget libreoffice— formulas76Budget pycel#NAME?
PROPER/proper-apostrophe =PROPER("o'brien") O'Brien gsheets[object Object] excel[object Object] latticeO'Brien ironcalc#NAME? hyperformulaO'Brien libreoffice— formulasO'Brien pycel#NAME?