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 |
|---|---|---|---|---|---|---|---|---|---|---|
type-coercion/255ef9 |
=SUM(TRUE, FALSE, TRUE) |
2 | gsheets2 | excel2 | lattice2 | ironcalc0 | hyperformula#NAME? | libreoffice— | formulas— | pycel— |
type-coercion/9c608d |
=SUM("1", "2", "3") |
6 | gsheets6 | excel6 | lattice6 | ironcalc0 | hyperformula6 | libreoffice— | formulas— | pycel— |