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 |
|---|---|---|---|---|---|---|---|---|---|---|
SUMPRODUCT/double-unary-coerces-boolean-row-to-numeric |
=SUMPRODUCT(--({1,2,3}>1)) |
2 | gsheets2 | excel2 | lattice2 | ironcalc#NAME? | hyperformula2 | libreoffice— | formulas0 | pycel#NAME? |
SUMPRODUCT/sumproduct-with-two-ranges |
=SUMPRODUCT(A1:A3, B1:B3) |
140 | gsheets140 | excel140 | lattice140 | ironcalc#NAME? | hyperformula140 | libreoffice— | formulas140 | pycel140 |
SUMPRODUCT/sumproduct-with-boolean-broadcast |
=SUMPRODUCT((A1:A3>1)*B1:B3) |
50 | gsheets50 | excel50 | lattice50 | ironcalc#NAME? | hyperformula50 | libreoffice— | formulas50 | pycel#NAME? |
SUMPRODUCT/sumproduct-basic |
=SUMPRODUCT(A1:A3, B1:B3) |
32 | gsheets32 | excel32 | lattice32 | ironcalc#NAME? | hyperformula32 | libreoffice— | formulas32 | pycel32 |
REPLACE/replace-basic |
=REPLACE("abcdefghijk", 6, 5, "*") |
abcde*k | gsheetsabcde*k | excelabcde*k | latticeabcde*k | ironcalc#NAME? | hyperformulaabcde*k | libreoffice— | formulasabcde*k | pycelabcde*k |
REPLACE/replace-year |
=REPLACE("2009", 3, 2, "10") |
2010 | gsheets2010 | excel2010 | lattice2010 | ironcalc#NAME? | hyperformula2010 | libreoffice— | formulas2010 | pycel2010 |