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 canvas is user-owned UI. Creating or editing an ODS or XLSX must save the workbook and return action buttons, but must not open the canvas automatically. Use Desktop/Calc only for explicit GUI requests, visual chart/layout polish, or final visual confirmation.

Workflow

Create a workbook:

{
  "tool_name": "document_artifact:create",
  "tool_args": {
    "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": "document_artifact:edit",
  "tool_args": {
    "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/canvas automatically. The user can choose Open in canvas when they want the visible spreadsheet.