Automate LibreOffice Calc Spreadsheet Operations

LibreOffice Calc skill supports spreadsheet creation, editing, conversion, and automation using ODS as its native format. It describes creating workbooks from scratch or templates, building data entry forms and dashboards, importing data, applying formulas, and producing reports. Analysis capabilities include pivot tables, statistical functions, validation, filtering, and conditional formatting.

Conversion workflows cover ODS, XLSX, XLS, CSV, DBF, HTML, and PDF, including batch conversion. The skill describes command-line automation through soffice, Python scripting through UNO, and spreadsheet creation with ezodf. It also provides formula automation examples that populate cells and set a formula, along with troubleshooting guidance for a LibreOffice socket connection. Command-line options include headless mode and output format selection. Python UNO examples connect to a local socket, access sheets and cells, and store documents.

Use the skill when creating or updating Calc spreadsheets, converting spreadsheet formats, automating calculations, building charts or pivot tables, or processing multiple files. It is suited to recurring spreadsheet workflows that benefit from templates, scripts, or command-line conversion.

Choose input and output formats for the workflow. For UNO automation, start soffice with a listening socket on localhost port 8100; if the connection fails, stop stale soffice.bin processes and relaunch with the socket accept option before retrying. It focuses on LibreOffice Calc; confirm feature and conversion behavior in the spreadsheet application used for delivery.

Inputs can include an ODS template, spreadsheet data, formulas, source files in formats such as XLSX or CSV, and desired output formats. Workflows can create ODS documents, import data, calculate formulas, generate reports, or convert files to XLSX, CSV, PDF, or HTML. Batch conversion can process multiple ODS files.

Open a workbook from the command line with:

soffice --calc template.ods

Best practices include using named ranges, documenting complex formulas, validating input data, creating templates for recurring reports, keeping ODS source files in version control, and using CSV for data exchange.

The skill references LibreOffice Calc command-line tools, the UNO API for Python automation, ezodf and odfpy for OpenDocument handling, and pandas for analysis. It also lists database connectivity, CSV imports and exports, and related LibreOffice tools including Writer, Impress, Draw, and Base.

Spreadsheet users, analysts, and developers can use this skill to automate Calc documents and repeatable data workflows. It supports people who need programmatic spreadsheet generation, format conversion, formula automation, or batch processing.