pandas ODS import: distinguishing covered cells with values from empty merged placeholders
Separate visual cell coverage from value presence so that a calculation entered by the document author is not silently reclassified as missing.
pandas ODS import: distinguishing covered cells with values from empty merged placeholders
A visually covered spreadsheet cell is not always an empty merged placeholder. If the ODS source retains a calculated-value attribute, reading it as blank may discard stored information. Inspect the cell coordinate and value attribute before judging the reader or filling blanks indiscriminately. [1, 2, 3]
What the primary source establishes
A report shows pandas' odf reader treating a covered-table-cell as empty despite its office:value. It distinguishes ordinary merged placeholders from covered cells carrying array-formula results and provides calamine as a comparison path. [1]
The handover decision
Inspect the covered cell's value attributes and coordinates first. Reconcile an explicit value with the source, then ask the document owner whether the formulas were recalculated. A comparison table should retain sheet, cell_address, office_value, and parsed_value rather than filling all visually covered cells indiscriminately. [1, 3]
A reference defined before the output
The illustrative ODS cell explicitly carries 42. A result of 42 preserves that stored value; missing does not. This differs from an empty merged placeholder because the source contains a value attribute. The check concerns preservation of the stored result, not a claim that a cached spreadsheet calculation is current. [1, 3]
The scoped Truthound check
Truthound Core 3.3.2 offers ColumnPairValidator for office_value and parsed_value aligned by cell coordinate. Build the table from cells with explicit source values so that missing outputs remain visible. Interpreting ODS structure and recalculating formulas are separate responsibilities. Because null pairs can be skipped, compare explicit Boolean source and output value-presence columns separately from the actual values. [1, 2, 3]
Limits and alternative choices
The check does not establish that the stored value is the latest formula result; it does not justify filling every empty merged cell. Verify a reader that supports explicit covered-cell values alongside an approved document-recalculation process. If the source has no value attribute or its cache is stale, there is no basis for treating 42 as the current answer. [1, 3]
Application conditions
Prepare source and parsed values by sheet and cell coordinate, distinguishing explicit value attributes from empty placeholders. Keep outputs without values under their original identifiers and reconcile explicit Boolean presence states separately.
Alternatives
Verify a reader that supports explicit covered-cell values alongside an approved document-recalculation process.
Limitations
The check does not establish that the stored value is the latest formula result; it does not justify filling every empty merged cell.
Evidence
- Event checked
- Subject checked
- Modified
