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
Open in Parity → Download spec.json All 102 specs