Skip to main content
Glama

Numbers: edit cell

numbers_edit_cell
Destructive

Set one cell value in a .numbers file with backup, verification, and atomic write. Use dry_run=true to preview the change on a copy without touching the file.

Instructions

Set one cell (e.g. ref "B2") in a .numbers file. Backed up, verified, atomic; every other cell is checked unchanged. dry_run=true previews the change on a copy without touching the file. Use to set one value. For a formula use numbers_set_formula; to add whole rows use numbers_insert with values; for how a number displays use numbers_set_number_format.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
refYesOne cell in A1 notation, e.g. "B2".
pathYesPath to the .numbers file (absolute, or starting with ~).
sheetNoSheet name. Omit when the file has one sheet (iwork_read lists sheets and tables).
tableNoTable name on that sheet. Omit when the sheet has one table.
valueYesNew value: a number stays a number, text stays text exactly (Arabic too); null clears. For a formula use numbers_set_formula.
dry_runNotrue = make the change on a throwaway copy, run every check, and return what would change; the file itself is not touched. Use it before broad or risky edits and show the user.

Output Schema

TableJSON Schema
NameRequiredDescriptionDefault

No arguments

Schema Changelog

Changes observed during successful MCP inspections.

  1. Changed6 schema fields changedv2.4.1
    • addedInput schema / properties / dry_run / description
      Added value: +"true = make the change on a throwaway copy, run every check, and return what would change; the file itself is not touched. Use it before broad or risky edits and show the user."
    • addedInput schema / properties / path / description
      Added value: +"Path to the .numbers file (absolute, or starting with ~)."
    • addedInput schema / properties / ref / description
      Added value: +"One cell in A1 notation, e.g. \"B2\"."
    • addedInput schema / properties / sheet / description
      Added value: +"Sheet name. Omit when the file has one sheet (iwork_read lists sheets and tables)."
    • addedInput schema / properties / table / description
      Added value: +"Table name on that sheet. Omit when the sheet has one table."
    • addedInput schema / properties / value / description
      Added value: +"New value: a number stays a number, text stays text exactly (Arabic too); null clears. For a formula use numbers_set_formula."
  2. First observedv2.4.0

TDQS

A4.7/5.0
Behavior5/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

Annotations only declare destructiveHint=true and idempotentHint=false; the description goes well beyond by disclosing backup, verification, atomicity, and that every other cell is checked unchanged, plus dry_run previewing on a throwaway copy. This is exactly the mutation-safety context an agent needs and does not contradict the annotations.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

Front-loads the core action, then safety guarantees, then routing alternatives in a tight sequence. No sentence is wasted and the ordering matches how an agent evaluates the call.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness5/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Covers mutation semantics, safety guarantees, dry-run preview, and sibling routing; an output schema exists so return values need no explanation. Nothing needed to call this correctly is missing.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema description coverage is 100%, so the schema already documents all six parameters including ref, value coercion, and dry_run semantics. The description largely echoes that content, so it meets the baseline without adding much beyond schema-provided meaning.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

States a specific verb and resource ("Set one cell (e.g. ref "B2") in a .numbers file") and explicitly names the sibling tools it is not, so an agent can distinguish it from numbers_set_formula, numbers_insert, and numbers_set_number_format without opening schemas.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines5/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

Gives a direct usage rule ("Use to set one value") and three explicit when-to-use alternatives with the condition that selects each (formula, whole rows, display formatting). Routing is fully specified.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.