Interpreting workbook cells
Resolve extracted cell types, references, cache evidence and merged coordinates.
Why should an old formula cache be held during import?
Require the supplied cache revision evidence before treating a cached value as current input.
Why did a spreadsheet error become an empty imported value?
Keep typed cell errors separate from genuine blanks and literal text.
Why did a spreadsheet name import as the number 1?
Resolve a shared-string index through its supplied string table.
Why did a merged heading fill an unrelated later row?
Use both row and column bounds of the declared merge rather than blanket fill-down.
Why did an imported proportion become 25 instead of 0.25?
Keep the typed numeric cell value separate from its percentage display.