FA-11380 / Spreadsheet calculation semantics / Member archive
SUMPRODUCT silently truncates mismatched ranges · case 05
A shorter range drops trailing factors, or broadcasting repeats its last value.
Case contract
One-dimensional integer ranges must have equal lengths. Return pairwise product sum or #VALUE! for mismatched lengths; two empty ranges sum to zero.
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 |
|---|---|---|---|
| short right range | 15 | "#VALUE!" | 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 ↗