DV-0248
ironcalc: SUM doesn't coerce booleans or numeric strings — returns 0
Subjects (1)
Tests (2)
matches canonical diverges no fixture in this DV's cluster
| Test | Formula | Canonical | gsheets | excel | lattice | ironcalc | hyperformula | libreoffice | formulas | pycel |
|---|---|---|---|---|---|---|---|---|---|---|
SUM/sum-with-booleans |
=SUM(TRUE, FALSE, TRUE) |
2 | gsheets2 | excel2 | lattice2 | ironcalc0 | hyperformula#NAME? | libreoffice— | formulas2 | pycel0 |
SUM/sum-with-numeric-string |
=SUM("1", "2", "3") |
6 | gsheets6 | excel6 | lattice6 | ironcalc0 | hyperformula6 | libreoffice— | formulas6 | pycel0 |