DV-0027
ironcalc: function not implemented — REPLACE, SUMPRODUCT
Subjects (2)
Tests (6)
matches canonical diverges no fixture in this DV's cluster
| Test | Formula | Canonical | gsheets | excel | lattice | ironcalc | hyperformula | libreoffice | formulas | pycel |
|---|---|---|---|---|---|---|---|---|---|---|
broadcasting/93d57f |
=SUMPRODUCT(--({1,2,3}>1)) |
2 | gsheets2 | excel2 | lattice2 | ironcalc#NAME? | hyperformula2 | libreoffice2 | formulas0 | pycel2 |
broadcasting/1114fe |
=SUMPRODUCT(A1:A3, B1:B3) |
140 | gsheets140 | excel140 | lattice140 | ironcalc#NAME? | hyperformula140 | libreoffice140 | formulas140 | pycel140 |
broadcasting/f777d1 |
=SUMPRODUCT((A1:A3>1)*B1:B3) |
50 | gsheets50 | excel50 | lattice50 | ironcalc#NAME? | hyperformula50 | libreoffice50 | formulas50 | pycel50 |
math/0d371c |
=SUMPRODUCT(A1:A3, B1:B3) |
32 | gsheets32 | excel32 | lattice32 | ironcalc#NAME? | hyperformula32 | libreoffice32 | formulas32 | pycel32 |
text/d0ff05 |
=REPLACE("abcdefghijk", 6, 5, "*") |
abcde*k | gsheetsabcde*k | excelabcde*k | latticeabcde*k | ironcalc#NAME? | hyperformulaabcde*k | libreofficeabcde*k | formulasabcde*k | pycelabcde*k |
text/9f0644 |
=REPLACE("2009", 3, 2, "10") |
2010 | gsheets2010 | excel2010 | lattice2010 | ironcalc#NAME? | hyperformula2010 | libreoffice2010 | formulas2010 | pycel2010 |