FAIRmat-NFDI / sand / 39684960071

89%

main: 86%

Pull #103

github

Address review: refuse what sand cannot compute exactly

Every case below either wrote a stale or wrong value, or crashed instead
of refusing:

- Formulas whose inputs the text leaves open (defined names, INDIRECT,
  OFFSET, table references) may read any cell; whole-row ranges are seen.
- Date cells are not edited (text would replace the date), and formulas
  over dates are refused instead of raising TypeError.
- Comparisons follow Excel across types: numbers < text < TRUE/FALSE.
- Array formulas: refused only when an edit feeds them; data tables
  feed on anything. Formulas on other sheets that point at the edited
  sheet are refused.
- Circular formulas are refused instead of recursing forever.
- Writes outside the sheet are refused before any cell is created.
- An empty text result is a valid stored result, not a missing one.
- Docstring names the real self-check; HEADER_ROW instead of 2; verify
  reuses the loaded original (4 workbook loads per write, not 6).

747 of 797 new or added lines in 6 files covered. (93.73%)

2580 of 2886 relevant lines covered (89.4%)

0.89 hits per line