Agent skill

calc

Spreadsheet creation, format conversion (ODS/XLSX/CSV), formulas, data automation with LibreOffice Calc.

View SKILL.md on GitHub Repository
Stars 232
Forks 15

Install this agent skill to your Project

npx add-skill https://github.com/aiskillstore/marketplace/tree/main/skills/sickn33/calc

SKILL.md

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.createInstanceWithContext(
        "com.sun.star.bridge.UnoUrlResolver", local_ctx
    )
    ctx = resolver.resolve(
        "uno:socket,host=localhost,port=8100;urp;StarOffice.ComponentContext"
    )
    smgr = ctx.ServiceManager
    doc = smgr.createInstanceWithContext("com.sun.star.sheet.SpreadsheetDocument", ctx)
    sheets = doc.getSheets()
    sheet = sheets.getByIndex(0)
    cell = sheet.getCellByPosition(0, 0)
    cell.setString("Hello from LibreOffice Calc!")
    doc.storeToURL("file:///path/to/spreadsheet.ods", ())
    doc.close(True)

Method 3: Using ezodf

python
import ezodf

doc = ezodf.newdoc('ods', 'spreadsheet.ods')
sheet = doc.sheets[0]
sheet['A1'].set_value('Hello')
sheet['B1'].set_value('World')
doc.save()

Converting Spreadsheets

bash
# ODS to XLSX
soffice --headless --convert-to xlsx spreadsheet.ods

# ODS to CSV
soffice --headless --convert-to csv spreadsheet.ods

# ODS to PDF
soffice --headless --convert-to pdf spreadsheet.ods

# XLSX to ODS
soffice --headless --convert-to ods spreadsheet.xlsx

# Batch convert
for file in *.ods; do
    soffice --headless --convert-to xlsx "$file"
done

Formula Automation

python
import uno

def create_formula_spreadsheet():
    local_ctx = uno.getComponentContext()
    resolver = local_ctx.ServiceManager.createInstanceWithContext(
        "com.sun.star.bridge.UnoUrlResolver", local_ctx
    )
    ctx = resolver.resolve(
        "uno:socket,host=localhost,port=8100;urp;StarOffice.ComponentContext"
    )
    smgr = ctx.ServiceManager
    doc = smgr.createInstanceWithContext("com.sun.star.sheet.SpreadsheetDocument", ctx)
    sheet = doc.getSheets().getByIndex(0)
    
    sheet.getCellByPosition(0, 0).setDoubleValue(100)
    sheet.getCellByPosition(0, 1).setDoubleValue(200)
    
    cell = sheet.getCellByPosition(0, 2)
    cell.setFormula("SUM(A1:A2)")
    
    doc.storeToURL("file:///path/to/formulas.ods", ())
    doc.close(True)

Format Conversion Reference

Supported Input Formats

  • ODS (native), XLSX, XLS, CSV, DBF, HTML

Supported Output Formats

  • ODS, XLSX, XLS, CSV, PDF, HTML

Command-Line Reference

bash
soffice --headless
soffice --headless --convert-to <format> <file>
soffice --calc  # Calc

Python Libraries

bash
pip install ezodf     # ODS handling
pip install odfpy     # ODF manipulation
pip install pandas    # Data analysis

Best Practices

  1. Use named ranges for clarity
  2. Document complex formulas
  3. Use data validation for input control
  4. Create templates for recurring reports
  5. Store ODS source files in version control
  6. Test conversions thoroughly
  7. Use CSV for data exchange
  8. Handle conversion failures gracefully

Troubleshooting

Cannot open socket

bash
killall soffice.bin
soffice --headless --accept="socket,host=localhost,port=8100;urp;"

Resources

Related Skills

  • writer
  • impress
  • draw
  • base
  • xlsx-official
  • workflow-automation

Recommended Agent Skills

Expand your agent's capabilities with these related and highly-rated skills.

aiskillstore/marketplace

perigon-backend

Perigon ASP.NET Core + EF Core + Aspire conventions

232 15
Explore
aiskillstore/marketplace

perigon-agent

Pointers for Copilot/agents to apply Perigon conventions

232 15
Explore
aiskillstore/marketplace

perigon-angular

Angular 21+ standalone/Material/signal conventions for Perigon WebApp

232 15
Explore
aiskillstore/marketplace

fastapi-mastery

Comprehensive FastAPI development skill covering REST API creation, routing, request/response handling, validation, authentication, database integration, middleware, and deployment. Use when working with FastAPI projects, building APIs, implementing CRUD operations, setting up authentication/authorization, integrating databases (SQL/NoSQL), adding middleware, handling WebSockets, or deploying FastAPI applications. Triggered by requests involving .py files with FastAPI code, API endpoint creation, Pydantic models, or FastAPI-specific features.

232 15
Explore
aiskillstore/marketplace

context7-efficient

Token-efficient library documentation fetcher using Context7 MCP with 86.8% token savings through intelligent shell pipeline filtering. Fetches code examples, API references, and best practices for JavaScript, Python, Go, Rust, and other libraries. Use when users ask about library documentation, need code examples, want API usage patterns, are learning a new framework, need syntax reference, or troubleshooting with library-specific information. Triggers include questions like "Show me React hooks", "How do I use Prisma", "What's the Next.js routing syntax", or any request for library/framework documentation.

232 15
Explore
aiskillstore/marketplace

browser-use

Browser automation using Playwright MCP. Navigate websites, fill forms, click elements, take screenshots, and extract data. Use when tasks require web browsing, form submission, web scraping, UI testing, or any browser interaction.

232 15
Explore

Didn't find tool you were looking for?

Be as detailed as possible for better results