odslisted

# ODS creation, editing, and analysis ## Overview An `.ods` file is an OpenDocument ZIP package for spreadsheets. Important package files: - `mimetype` - should be the first ZIP entry and stored uncompressed as `application/vnd.oasis.opendocument.spreadsheet` - `content.xml` - sheets, rows, cells, formulas, charts, and most content - `styles.xml` - cell, table, page, and number styles - `meta.xml` - document metadata - `settings.xml` - application settings - `META-INF/manifest.xml` - package manifest ## Quick Reference | Task | Preferred approach | |------|--------------------| | Read sheets/data | Use `scripts/extract_sheets.py` or parse `content.xml` | | Create simple workbook | Generate ODS package XML directly | | Create styled/model workbook | Start from an `.ods` template and edit cells XML-safely | | Extract/check formulas | Use `scripts/extract_formulas.py` | | Convert CSV/XLSX to ODS | Use LibreOffice only when the source already exists or interoperability requires it | | Validate formulas/recalc | Recalculate with LibreOffice, then inspect formulas, CSV/PDF, and error values | ## Tool Checks Before starting a real ODS task, check available tools: ```bash python3 -c "import pandas, odf; print('pandas and odfpy available')" ``` Resolve the LibreOffice command as described in [docs/soffice-resolver.md](../../docs/soffice-resolver.md). Use the bundled workspace Python when normal `python3` lacks pandas or other spreadsheet libraries. ## Reading Data When `pa