assay
type-coercion

non-numeric-string-plus-number

Subject
op:+
Category
value
Formula
="abc"+1
Canonical
#VALUE!

Per-engine results

matches canonical diverges no fixture

Engine Verdict Value
gsheets match #VALUE!
excel match #VALUE!
lattice match #VALUE!
ironcalc match #VALUE!
hyperformula match #VALUE!
libreoffice diverge
formulas match #VALUE!
pycel diverge #NAME?