DV-0251

excel, ironcalc, lattice: empty-string addition (""+1) raises #VALUE! instead of coercing to 0

Cause
error-code
Category
value
Diverging engines
excelironcalclattice
Behavior signature
{"error":"#VALUE!"}
Test count
1
Seeded
2026-04-26
Last confirmed
2026-04-26

Subjects (1)

op:+

Tests (1)

matches canonical diverges no fixture in this DV's cluster

Test Formula Canonical gsheets excel lattice ironcalc hyperformula libreoffice formulas pycel
type-coercion/ed098c =""+1 1 gsheets1 excel#VALUE! lattice#VALUE! ironcalc#VALUE! hyperformula1 libreoffice— formulas— pycel—