Excel Formula Syntax & Error Auditor
Excel Formula Syntax & Error Auditor: Parses `<f>` formula nodes across all sheet XML parts and verifies calculation syntax and error constants.
About this excel formula syntax & error auditor
Excel Formula Syntax & Error Auditor — browser-based utility.
How this tool works
Implements client-side Excel Formula Syntax & Error Auditor operations. Parses `<f>` formula nodes across all sheet XML parts and verifies calculation syntax and error constants specifically designed for a financial auditor scans a complex financial model for broken formula references (#ref!, #div/0!).
- OpenXML ZIP Decompression: Unpacks DOCX/PPTX archive structures in memory via fflate, validating package integrity against Zip Bomb attacks.
- XML DOM Parsing & Relationship Mapping: Parses word/comments.xml and word/_rels/document.xml.rels to resolve comment ranges, authors, and dates.
- Thread & Status Reconstruction: Reconstructs parent-child reply relationships and resolved states from commentsExtended parts.
- XLSX Workbook Compilation: Compiles parsed records into a typed Excel workbook with frozen header rows and auto-filters.
Worked example
Scenario: An analyst inventories stored formulas and error cells without recalculating a workbook.
Sample input:
Processing: Uses SheetJS cell metadata to list cell.f strings and stored error values.
Illustrative output:
Limits and verification
Legacy binary formats (.doc, .ppt, .xls) must be converted to modern OpenXML (.docx, .pptx, .xlsx) before processing. Password-encrypted Office packages must be unlocked prior to parsing.
Examples demonstrate an expected workflow; they do not prove every input or every branch of an external specification. Check important results with an independent source before using them for money, security, compliance, safety, or irreversible file changes.
Browser processing boundary
Tool input is processed by code running in the browser and is not intentionally sent to a CZOA processing API. The page can still request ordinary site assets, analytics, or advertising when those services are enabled. Browser extensions and managed-device software remain outside this tool's control.
Relevant references
These references govern or help explain the format, protocol, or calculation used here. Listing a reference does not claim certification or complete implementation of every optional feature.
Content owner: CZOA Tools · Last reviewed: 2026-09-15 · Review methodology
How to use it
- Enter, paste, or select your input data into the Excel Formula Syntax & Error Auditor workspace controls.
- Review available parameter fields, units, formats, or options configured for your task.
- Click the action button or observe immediate live calculations rendered in your browser runtime.
- Inspect the resulting output and any diagnostic messages, then copy or download the result if needed.
Frequently asked questions
How does XLSX Formula Auditor inspect a workbook?+
It reads selected bytes with SheetJS, iterates each SheetName and cell entry, and returns formula text only when cell.f is a string. It also lists cells whose type is e or whose stored value matches its error pattern.
Which controls and result fields are available?+
The page has one local file chooser and Process locally. It returns read-only JSON with sheets, formulaCells, formulas, errorCells, and a note; there are no calculation, repair, filtering, editing, download, or dependency-graph controls.
What calculation limits apply?+
Formula text is prefixed with = and stored error values are inventoried. It does not parse formula correctness, recalculate formulas, evaluate references, detect volatile functions, or establish why an error occurred.
What did isolated browser verification establish?+
For an independently created Calc worksheet with B2 =A2*2 and stored C2 #REF!, the JSON is expected to report formulaCells 1, the B2 formula, and one C2 errorCells entry. This inventories stored SheetJS cell metadata; it does not parse, evaluate, or recalculate formulas.