FA-11347 / Spreadsheet calculation semantics / Member archive
Range SUM coerces text and logical cells into numbers · case 02
A range sum includes numeric-looking labels and logical cells.
Case contract
A range contains finite ints, floats, strings, booleans or None. Return SUM of numeric cells only; strings, booleans and blanks are ignored.
Why this case matters
This isolated spreadsheet model makes cell semantics explicit; it does not claim compatibility with every workbook engine.
One recorded failure
Sample boundary fixtureThis sample comes from the broken implementation of a controlled reproducer.
| Boundary fixture | Actual | Expected | Outcome |
|---|---|---|---|
| numeric text ignored | 4.0 | 2 | Failed |
MEMBER ARCHIVE
The complete case is available to members.
This record includes three runnable implementations, regression fixtures, execution results, and source hashes.
Member access is invitation-based. Sign in with your invited account to inspect the sources.
Sign in to the archive ↗