FA-11372 / Spreadsheet calculation semantics / Member archive

A spill overwrites an occupied cell displaying an empty string · case 02

A dynamic array overwrites a formula whose visible result is empty.

Member previewVariant 2 · 3 implementations · 7 checks per implementation

Case contract

Given equal-length proposed values and target cells, return values if all targets are None, otherwise #SPILL!. An empty string means an occupied formula cell. No partial write occurs.

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 fixture

This sample comes from the broken implementation of a controlled reproducer.

Boundary fixture	Actual	Expected	Outcome
empty string formula blocks	`[2]`	`"#SPILL!"`	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.