minimax-xlsx

<toolkit_inventory>

Workbook construction — Python 3 via the ipython tool: openpyxl (creation, styling, formulas) + pandas (data wrangling).

Formula recalculation — recalc.py via the shell tool: invokes LibreOffice in headless mode to compute all formula values, then scans for error tokens and returns a JSON report. openpyxl writes formula text (e.g., =SUM(A1:A10)) but does NOT compute results — this script fills that gap.

python ./scripts/recalc.py output.xlsx [timeout_seconds]

• Auto-configures LibreOffice macro on first run
• Recalculates every formula across all sheets
• Returns JSON with error locations and tallies
• Default timeout: 30 seconds
• When to run: ALWAYS after wb.save() and BEFORE recalc, whenever the file has formulas