Formula-Safe Spreadsheet Workbook Maintenance

Problem

Spreadsheets are often more than exported data. When an agent creates or edits xlsx, xlsm, csv, or tsv files, the usual risk is overwriting formulas, breaking cell references, losing hidden sheets, or hardcoding final results into the file. These outputs may look correct at first, but they are hard to maintain once the underlying logic changes.

How It Works

The skill treats spreadsheet work as formula-safe workbook maintenance, not plain text replacement:
- Prefer cell-level edits to avoid breaking formulas by rewriting whole sheets.
- Run workbook validation before delivery to check structure, formulas, data, and output consistency.
- Use recalculation for computed fields so results come from workbook logic instead of one-off scripts.
- Rely on pandas, openpyxl, and LibreOffice for parsing, modification, and recalculation.

Boundaries

It fits cases where a spreadsheet is the formal deliverable: repairing legacy files, adjusting calculated fields, or producing maintainable workbooks after data merges. If you only need to inspect a few rows, or the target has no formulas or complex structure, a lighter data-viewing approach is usually enough.