cadrumo.core.workbook module¶

The workbook-reading policy every layer that opens a spreadsheet shares.

A cell carrying a formula states a computation, not a figure. Beside it a workbook may cache whatever number was last computed into it, and that cached number is not the formula’s value: a sheet edited somewhere else and saved without recalculating carries a figure nobody typed and the formula does not produce. Reading it would take that number as fact.

So a formula cell is refused, never read, everywhere a spreadsheet is treated as a source of financial or filing data — the bank-statement workbook provider, the casilla-value spreadsheet, and the bulk invoice book each refuse on this ground. The alternative, reading the cached value, fails in the direction that matters: the wrong figure reaches a return as a number rather than as any kind of failure, which is the one outcome no downstream check is positioned to catch.

The detection and the sentence live here so the three readers cannot drift apart on what a formula cell is or on what the operator is told about it. What stays with each reader is the part that genuinely differs: which rows are in scope (the statement provider ignores its preamble and header, the other two read every row), and which error type its layer refuses with.

This module deliberately does not import openpyxl. The cell is described structurally instead, so resolving the policy never pulls a spreadsheet engine into the innermost layer.