Check formula integrity
check_formula_integrityReviews XLSX formula cells for cached errors, #REF! text, and unusual relative-pattern variations without evaluating formulas, flagging integrity issues for human review.
Instructions
Review formula cells in an XLSX sheet for cached errors, #REF! text, and unusual relative-pattern variations. It never evaluates formulas and presents variations as human review leads.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| file_path | Yes | XLSX path relative to KINGWORKBOOK_ROOT. | |
| sheet_name | No | Optional sheet name; defaults to the first visible sheet. | |
| max_findings | No | Maximum total finding cells returned. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| notes | Yes | ||
| findings | Yes | ||
| file_path | Yes | ||
| sheet_name | Yes | ||
| formulas_scanned | Yes | ||
| findings_truncated | Yes | ||
| cached_formula_errors | Yes | ||
| formula_runs_compared | Yes | ||
| broken_reference_formulas | Yes | ||
| formula_pattern_variations | Yes |