skills.rest
BAIZ1D
BAIZ1DCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

calc

Automate LibreOffice Calc spreadsheet creation, format conversion, and data tasks.

Updated Jun 30, 2026
Search Tags:#spreadsheet#batch-processing#data-automation#pivot-tables#formula-automation#libreoffice-calc#ods-conversion
One-click install
npx skills add https://github.com/BAIZ1D/macbookM1_rice --skill calc-baiz1d
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: calc
Source: https://github.com/BAIZ1D/macbookM1_rice/tree/main/agent/skills/libreoffice/calc
Command: npx skills add https://github.com/BAIZ1D/macbookM1_rice --skill calc-baiz1d

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill eliminates the manual effort of creating, converting, and automating spreadsheet workflows, especially when handling common formats like ODS, XLSX, CSV, and PDF that require consistent formatting and batch processing.

Core Features & Use Cases

  • Spreadsheet Creation & Editing: Build new ODS spreadsheets from scratch, use pre-made templates, create data entry forms, and design dashboards and reports.
  • Format Conversion: Seamlessly convert between ODS, XLSX, CSV, PDF, and other spreadsheet formats, including batch conversion for multiple files at once.
  • Data Automation & Analysis: Automate formula calculations, import/export data from external sources, create pivot tables, and apply conditional formatting for data insights. For example, if you have 100 sales CSV files that need to be combined into a single formatted ODS report with auto-calculated totals and pivot tables, this Skill automates the entire process.

Quick Start

Use the calc skill to convert all CSV files in your current working directory to ODS spreadsheets with auto-calculated sum columns for each numeric column.

Frequently Asked Questions about calc

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I batch convert CSV files to ODS spreadsheets without opening LibreOffice Calc?▼

Batch conversion of CSV files to ODS spreadsheets is automated without manual GUI interaction using command-line soffice execution and Python UNO scripting. This Skill processes multiple files at once, converting between ODS, XLSX, CSV, and PDF formats directly.

Can I automate formula calculations and pivot tables in LibreOffice Calc via command line?▼

Automating formula calculations and pivot tables in LibreOffice Calc is supported through Python UNO scripting and ODS library manipulation. This Skill applies formula automation and builds pivot tables for data analysis entirely without manual GUI interaction.

What is the best way to generate a formatted ODS report from multiple CSV files?▼

Generating a formatted ODS report from multiple CSV files is handled by combining batch processing with formula automation. This Skill merges source data, applies auto-calculated sum columns, and designs dashboards or reports from scratch using pre-made templates.

Does this approach require a LibreOffice desktop installation to convert XLSX to PDF?▼

Converting XLSX to PDF requires the soffice command-line engine rather than the full LibreOffice GUI. This Skill drives format conversion through command-line automation and Python UNO scripting, eliminating the need to manually open the desktop application.

Why use Python UNO scripting for spreadsheet automation instead of standard macros?▼

Python UNO scripting enables command-line automation for spreadsheet creation and data processing without manual GUI interaction, surpassing standard macros. This Skill manipulates ODS libraries directly, allowing scalable batch processing and automated format conversion across multiple files.

Are there limitations when batch converting ODS files with conditional formatting to PDF?▼

Batch converting ODS files with conditional formatting to PDF is supported, but complex layouts may require explicit template configuration. This Skill automates format conversion and applies conditional formatting for data insights, though intricate GUI-dependent rendering is outside its command-line scope.

Related Skills

Explore More Data & Analytics Skills→
BAIZ1DBAIZ1D

writer

Create, convert, and batch process LibreOffice Writer documents via soffice and UNO API.

Community
Intermediate
wuyyyyyouwuyyyyyou

recipe-backup-sheet-as-csv

Export a Google Sheets spreadsheet to a CSV file for local backup.

Community
Intermediate
dongsheng123132dongsheng123132
1.7k

excel-helper

Automate Excel formula generation, pivot tables, data cleaning, and charting.

Community
Intermediate
RamanEbrahimiRamanEbrahimi
3

xlsx

Create, edit, and analyze Excel files with pandas and openpyxl.

Community
Advanced