Workbook workflow

Trigger for .xlsx, .xlsm, .xltx, .csv, and .tsv workbooks or requests to create, read, edit, clean, format, calculate, chart, or convert them. Do not use it for ordinary documents, web pages, databases, or live external spreadsheet APIs.

1. Copy an existing workbook to a unique temporary directory and inspect it with scripts/inspect_workbook.mjs --input <file> --json before editing.
2. Preserve formulas, cached values, styles, merges, tables, filters, validations, conditional formatting, charts, images, shapes, comments, hidden sheets, links, macros, and metadata. Only modify the requested cells or objects.
3. After adding or changing formulas run scripts/recalculate_workbook.mjs --input <file> --output <file> --json. A completed recalculation with formula errors is reported as errors_found; a conversion or process failure is a separate failure.
4. Run scripts/check_workbook.mjs <file> --json; use --allow-lossy only when the caller explicitly accepts the listed loss. The checker does not use PPTX or XSD data.
5. Render with scripts/render_with_office.mjs <file> --output-dir <dir> and inspect every sheet/page. Reopen the output and verify formulas, cached values, objects, and that the original hash is unchanged.

CSV/TSV input requires an explicit encoding, BOM, delimiter, quote, newline, and malformed-row policy. Never replace formulas with constants unless a static export was requested. External links, macros, unsupported extensions, and objects that cannot be safely preserved fail closed.

All commands are standalone Node CLIs. They write stable JSON with --json, diagnostics to stderr, and non-zero status for invalid input, missing Office, timeout, or unsafe preservation. The bundled renderer is resolved through MEMMY_OFFICE_RENDERING_ROOT, the legacy DOCX override during migration, the packaged Office payload, and the source payload; it never silently falls back to a system PATH installation.

See references/workbook-workflow.md, references/formula-recalculation.md, and references/layout-and-preservation.md for the full SOP.