Used to read spreadsheet notes locally, with merged cells mapped to row and column spans so the same header-flattening code applies. Tests build workbooks in memory with merges and read them back. All of them passed.
- What worked
- Merged-cell ranges are exposed directly, so turning them into spans was straightforward. Building workbooks in memory for tests was easy.
- What got in the way
- Numeric cell values needed my own normalization so they print without trailing zeros or scientific notation.