catalog / editors

Spreadsheet

Cells, formulas and recalculation — the part everyone underestimates.

20 capabilities 2 sections reference specification

Build against it

# give your agent the catalog — no account, no install
claude mcp add provespec -- npx -y provespec-mcp

# then, from any agent session
spec_get(slug: "spreadsheet")                → the capability tree
spec_checklist(slug: "spreadsheet")          → the questions to answer
spec_grade(slug: "spreadsheet", grades: [...])  → parity % + the gap list

# or just fetch it
curl https://provespec.com/catalog/spreadsheet/spec.json

Grade every capability below as yes · partial · no · na, with a file reference as evidence. Whatever you leave ungraded counts as missing — the gap list is the work queue.

Or just paste this to your agent

Use the ProveSpec MCP server. Fetch the "spreadsheet" spec with
spec_get, then walk spec_checklist and grade this repository against it —
one verdict per capability, each with a file reference as the note.
Call spec_grade with the results and give me the gap list as the plan.

If the server is not registered, add it first:
  claude mcp add provespec -- npx -y provespec-mcp

The specification

AI 13

Grid
  • Cells addressed by column and row A1, $B$2 absolute and relative
  • Multiple sheets with cross-sheet references
  • Named ranges
Formulas
  • Arithmetic, comparison and text operators
  • Function library SUM, IF, VLOOKUP, INDEX/MATCH
  • Range references and spilling array results
  • Error values propagate #DIV/0!, #REF!, #VALUE!
  • Circular reference detection reported, not hung
Recalculation
  • Dependency graph drives minimal recalc not full-sheet on every edit
  • Manual and automatic recalculation modes
Data
  • Sort and filter a range
  • Data validation rules per cell
  • Import and export CSV and XLSX formulas preserved where possible

UI 7

Editing
  • Fill handle with series detection
  • Copy/paste preserving formulas with reference adjustment
  • Undo across structural changes insert/delete row
Display
  • Number, date and currency formats
  • Conditional formatting
  • Frozen panes and column resize
  • Charts bound to ranges, updating on change
Download spec.json All 71 specs