FA-11362 / Spreadsheet calculation semantics / Member archive

Subtotal includes nested aggregates or hidden rows · case 02

The subtotal doubles a nested subtotal or counts rows hidden by the specified mode.

Member previewVariant 2 · 3 implementations · 7 checks per implementation

Case contract

Rows are [number,filtered,manually_hidden,is_subtotal]. Mode 9 includes manually hidden rows; mode 109 excludes them. Both exclude filtered rows and subtotal cells.

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
manual hidden omitted in mode 109	`2`	`0`	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.