Calc Spreadsheets

Calc Spreadsheets

Use ODS when the user asks for a spreadsheet, workbook, editable table, budget, formulas, or Calc file. Use XLSX only when the user asks for Excel/XLSX compatibility, provides an existing .xlsx, or needs embedded spreadsheet charts supported by the tool.

The document UI and Desktop are user-owned. Creating or editing an ODS or XLSX must save the workbook, but must not open a document modal or Desktop surface automatically. Use Desktop/Calc only for explicit GUI requests, visual chart/layout polish, or final visual confirmation. Do not write faux UI action labels such as "Open document" or "Download file", and do not add a note saying the canvas was not opened automatically unless the user explicitly asks about UI behavior.

Workflow

Create a workbook:

{
  "tool_name": "office_artifact",
  "tool_args": {
    "action": "create",
    "kind": "spreadsheet",
    "title": "Budget",
    "format": "ods",
    "content": "Item,Amount\nPlatform,1000"
  }
}

For a blank workbook request, create a simple workbook with the requested title and format: "ods"; do not call status first unless the user asked for availability.

Edit cells:

{
  "tool_name": "office_artifact",
  "tool_args": {
    "action": "edit",
    "file_id": "abc123",
    "operation": "set_cells",
    "cells": {
      "Sheet1!A1": "Item",
      "Sheet1!B1": "Amount"
    }
  }
}

Practical rules:

• content may be CSV, TSV, or a Markdown table; the tool writes real spreadsheet cells.
• Use rows for whole-table replacement, append_rows for adding records, and set_cells for precise edits.
• Use create_chart with a chart object for embedded charts when working in XLSX compatibility format; otherwise use Calc/Desktop or code execution for chart workflows that ODS direct editing does not yet cover.
• Do not open Calc/Desktop automatically. The user can choose Open in Desktop when they want the visible spreadsheet.