FA-11359 / Spreadsheet calculation semantics / Member archive
Approximate lookup selects a nearest value instead of the lower bracket · case 04
A key between breakpoints gets a future band.
Case contract
Unique sorted integer [key,value] rows define bands. Return value at greatest key <= query or #N/A below all keys or for empty rows.
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 |
|---|---|---|---|
| interior near upper endpoint | "high" | "low" | 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 ↗