Reading & structure2 tools
- Get every sheet's name, used range and size
- Read cell values and the formulas behind them
- Read a sheet or a named range without changing it
All 2 tools
- get_spreadsheet_info
- read_spreadsheet
← The solution
Calc agent
Formulas, solved.
A spreadsheet is not a document with rows. The Calc agent reads the cells and the formulas behind them, and operates the sheet the way an analyst would.
One prompt reads the Data sheet, writes a ratio table on a new Dashboard sheet and charts the results, with every ratio calculated from your figures. Replica of the app window, driven through the agent's real states, not a screen recording.
What it does in Calc.
42 tools, grouped by what they’re for. Every capability below is a real tool the agent calls — the names are the evidence, the text explains what they let you do.
Writing & formatting cells6 tools
- Write values, formulas or text as a block of cells
- Format fonts, colors, number formats and borders
- Add conditional formatting, comments and hyperlinks
All 6 tools
- write_cells
- format_cells
- merge_cells
- insert_cell_comment
- insert_hyperlink
- conditional_format
Rows, columns & sheets13 tools
- Add, rename, copy or delete sheets
- Insert, delete and resize rows and columns
- Freeze panes and hide or show ranges
All 13 tools
- add_sheet
- rename_sheet
- delete_sheet
- copy_sheet
- insert_rows
- insert_columns
- delete_rows
- delete_columns
- set_column_width
- set_row_height
- freeze_panes
- hide_show_rows
- hide_show_columns
Data operations12 tools
- Sort, filter, de-duplicate and transpose ranges
- Find and replace, or split text into columns
- Define named ranges, validation and sheet protection
All 12 tools
- sort_range
- find_replace_cells
- remove_duplicates
- transpose_range
- text_to_columns
- group_rows_columns
- auto_filter
- data_validation
- create_named_range
- clear_range
- set_print_area
- protect_sheet
Analysis, visuals & export8 tools
- Build bar, line, pie, scatter and area charts
- Create pivot tables straight from a data range
- Import CSV, export CSV and XLSX, or build a whole dashboard
All 8 tools
- create_chart
- create_pivot_table
- build_dashboard
- insert_shape
- insert_image
- export_csv
- import_csv
- export_xlsx
Scripting1 tool
- A last-resort fallback for rare operations
- Runs Python UNO code against the open workbook
- Used only when no other tool covers the job
All 1 tool
- execute_script
Skills.
Alongside the tools above, Calc carries 31 skills — pre-built prompt blueprints for common Calc work. A keyword match against what you ask selects one automatically and folds it into the agent’s instructions before it starts; there is no picker to operate.
Financial modelling9 skills
The models an analyst builds by hand: a DCF, a comps table, an LBO structure, returns and sensitivity analysis, a full three-statement build, ratio analysis, a portfolio tracker, a controlling pack.
- comp_analysis
- controlling
- dcf_model
- lbo_model
- portfolio_tracker
- ratio_analysis
- returns_analysis
- sensitivity_analysis
- three_statement
Accounting & close6 skills
Bookkeeping and period-close work: AR aging, a fixed asset register, an amortization schedule, an invoice tracker, account reconciliation, a close checklist.
- account_reconciliation
- amortization_schedule
- ar_aging
- fixed_asset_register
- invoice_tracker
- period_close_checklist
General operations9 skills
Spreadsheet patterns that show up outside finance: dashboards, forecasting, a sales pipeline, project and product trackers, HR and inventory operations, general data analysis, a scoring matrix for weighing options.
- dashboard
- data_analysis
- forecasting
- hr_tracker
- inventory_ops
- product_management
- project_management
- sales_pipeline
- scoring_matrix
Macro automation7 skills
Blueprints that generate Python UNO macro code rather than a workbook directly: batch report generation, chart automation, advanced conditional formatting, data import and transform, PDF and print export, named-range formula systems, sheet protection and validation.
- batch_report_generator
- chart_automation
- conditional_formatting_advanced
- data_import_transform
- export_pdf_print
- formulas_named_ranges
- sheet_protection_validation
How it actually works.
A cell is two things: what it shows and what computed it. Reading a range returns both the value and the formula behind it, so the agent can see that a number comes from a lookup three sheets away before it changes anything that depends on it.
Because it works at the formula layer, it can build what an analyst would build by hand: a pivot table grouped and aggregated from a source range, a named range a formula can call by name instead of a cell address, conditional formatting keyed to a threshold — and hand the result off as a real XLSX export.
Where the edges are.
- It works on the open workbook — not a warehouse or a database.
- Very large sheets are bounded by what LibreOffice itself can hold in memory.
The other two
Try it on your next document.
Create an account, download OfficeLabs and open a file. 14-day Pro trial, no card required.
Start free trial