calclisted

# LibreOffice Calc ## Overview LibreOffice Calc skill for creating, editing, converting, and automating spreadsheet workflows using the native ODS (OpenDocument Spreadsheet) format. ## When to Use This Skill Use this skill when: - Creating new spreadsheets in ODS format - Converting between ODS, XLSX, CSV, PDF formats - Automating data processing and analysis - Creating formulas, charts, and pivot tables - Batch processing spreadsheet operations ## Core Capabilities ### 1. Spreadsheet Creation - Create new ODS spreadsheets from scratch - Generate spreadsheets from templates - Create data entry forms - Build dashboards and reports ### 2. Format Conversion - ODS to other formats: XLSX, CSV, PDF, HTML - Other formats to ODS: XLSX, XLS, CSV, DBF - Batch conversion of multiple files ### 3. Data Automation - Formula automation and calculations - Data import from CSV, database, APIs - Data export to various formats - Batch data processing ### 4. Data Analysis - Pivot tables and data summarization - Statistical functions and analysis - Data validation and filtering - Conditional formatting ### 5. Integration - Command-line automation via soffice - Python scripting with UNO - Database connectivity ## Workflows ### Creating a New Spreadsheet #### Method 1: Command-Line ```bash soffice --calc template.ods ``` #### Method 2: Python with UNO ```python import uno def create_spreadsheet(): local_ctx = uno.getComponentContext() resolver = local_ctx.ServiceManager.creat