Calc capabilities
Calc has the largest toolset of the three applications. The full per-tool list, with the risk level of each, is on Agent tools.
These 42 tools are specific to Calc. Tools shared by all applications are on Agent tools.
Advanced
| Tool | What it does | Changes the document | Risk |
|---|---|---|---|
build_dashboard | Renders an entire spreadsheet dashboard from a structured CalcPlan in a SINGLE tool call. | yes | medium |
create_chart | Creates a chart from a data range. | yes | medium |
create_pivot_table | Creates a pivot table on a new sheet from source data. | yes | medium |
execute_script | Runs arbitrary Python UNO code in LibreOffice Calc. | yes | high |
Analysis
| Tool | What it does | Changes the document | Risk |
|---|---|---|---|
get_spreadsheet_info | Gets metadata for all sheets: names, used ranges, row/column counts. | no | low |
read_spreadsheet | Reads cell values and formulas from a sheet or named range. | no | low |
Annotation
| Tool | What it does | Changes the document | Risk |
|---|---|---|---|
insert_cell_comment | Inserts or removes a comment on a cell. | yes | low |
Editing
| Tool | What it does | Changes the document | Risk |
|---|---|---|---|
auto_filter | Applies or removes an AutoFilter on a data range. | yes | low |
clear_range | Clears cell contents, formatting, or both in a range. | yes | medium |
data_validation | Sets data validation rules on a cell range. | yes | medium |
find_replace_cells | Finds and replaces text or values across Calc cells. | yes | medium |
insert_hyperlink | Inserts a clickable URL hyperlink into a cell. | yes | low |
remove_duplicates | Removes duplicate rows from a range based on one or more columns. | yes | high |
sort_range | Sorts a cell range by a column. | yes | medium |
text_to_columns | Splits text in a column by a delimiter into multiple columns. | yes | medium |
transpose_range | Copies a source range and pastes it transposed (rows become columns, columns become rows) at a target cell. | yes | medium |
write_cells | Writes values, formulas, or text to cells as a 2-D array. | yes | medium |
Export
| Tool | What it does | Changes the document | Risk |
|---|---|---|---|
export_csv | Exports the active sheet as a CSV file. | no | high |
export_xlsx | Exports the spreadsheet as an Excel .xlsx file to the given path. | no | high |
Formatting
| Tool | What it does | Changes the document | Risk |
|---|---|---|---|
conditional_format | Applies conditional formatting rules to a cell range. | yes | medium |
format_cells | Formats cell appearance: bold, italic, font size, text/background color, number format, alignment, borders. | yes | low |
freeze_panes | Freezes rows and/or columns so they stay visible when scrolling. | yes | low |
hide_show_columns | Hides or shows columns by index range. | yes | low |
hide_show_rows | Hides or shows rows by index range. | yes | low |
merge_cells | Merges or unmerges a range of cells. | yes | medium |
set_column_width | Sets the width of a column in cm. | yes | low |
set_print_area | Defines or clears the print area on a sheet. | yes | low |
set_row_height | Sets the height of a row in cm. | yes | low |
Import
| Tool | What it does | Changes the document | Risk |
|---|---|---|---|
import_csv | Imports a CSV file as a NEW sheet in the current spreadsheet. | yes | medium |
Media
| Tool | What it does | Changes the document | Risk |
|---|---|---|---|
insert_image | Insert an image onto the active Calc sheet from a local file or URL. | yes | medium |
insert_shape | Insert a drawing shape onto the active Calc sheet. | yes | medium |
Structure
| Tool | What it does | Changes the document | Risk |
|---|---|---|---|
add_sheet | Adds a new empty sheet to the spreadsheet. | yes | medium |
copy_sheet | Copies an existing sheet (with all data and formatting) to a new name within the same spreadsheet. | yes | high |
create_named_range | Defines a named range in the spreadsheet. | yes | low |
delete_columns | Deletes N columns starting at the given 0-based column index. | yes | medium |
delete_rows | Deletes N rows starting at the given 0-based row index. | yes | medium |
delete_sheet | Deletes a sheet by name. | yes | high |
group_rows_columns | Groups or ungroups rows/columns for outline view. | yes | low |
insert_columns | Inserts N empty columns to the left of the given 0-based column index. | yes | medium |
insert_rows | Inserts N empty rows above the given 0-based row index. | yes | medium |
protect_sheet | Protects or unprotects a sheet with an optional password. | yes | medium |
rename_sheet | Renames a sheet from old_name to new_name. | yes | low |