Totals follow every edit
An owned engine parses formulas into the shared AST. Dependents recalculate. The language is closed: no reference from text, and nothing reaches the host except the clock you pass.
- Formulas
Solution · Sheets
A spreadsheet with formulas built to recalculate.
An owned formula engine, a keyboard grid, and CSV that will not inject formulas.
Status: in development
Plan a project budget
Try this
- Change a quantity or unit price; the row and grand totals recalculate.
- Toggle formulas to see the owned engine’s expressions as data.
- Add a line item, then reset to restore the fixture workbook.
Use Reset to return to the starting example.
Enter or F2 edits the cell. Escape cancels. Control or Command plus Z undoes; Shift plus Z or Y redoes. Control or Command plus C copies; V pastes.
| Row | A | B | C | D |
|---|---|---|---|---|
1 | Work item | Quantity | Unit price | Total |
2 | Design workshop | 3 | 120 | 360 |
3 | Prototype materials | 8 | 24.5 | 196 |
4 | User interviews | 5 | 42 | 210 |
5 | Project total | 766 | ||
6 | ||||
7 | ||||
8 |
8 rows
Project budget loaded. Select a cell or use the controls to explore the formula engine.
Enter or F2 edits the cell. Escape cancels. Control or Command plus Z undoes; Shift plus Z or Y redoes. Control or Command plus C copies; V pastes.
| Row | A | B | C | D |
|---|---|---|---|---|
1 | Work item | Quantity | Unit price | Total |
2 | Design workshop | 3 | 120 | 360 |
3 | Prototype materials | 8 | 24.5 | 196 |
4 | User interviews | 5 | 42 | 210 |
5 | Project total | 766 | ||
6 | ||||
7 | ||||
8 |
8 rows
{
"format": "texuli-sheet",
"formatVersion": 1,
"meta": {
"title": "Project budget"
},
"sheets": [
{
"id": "budget",
"name": "Budget",
"rows": 8,
"columns": 4,
"cells": {
"A1": "Work item",
"B1": "Quantity",
"C1": "Unit price",
"D1": "Total",
"A2": "Design workshop",
"B2": 3,
"C2": 120,
"D2": "=B2*C2",
"A3": "Prototype materials",
"B3": 8,
"C3": 24.5,
"D3": "=B3*C3",
"A4": "User interviews",
"B4": 5,
"C4": 42,
"D4": "=B4*C4",
"A5": "Project total",
"D5": "=SUM(D2:D4)"
}
}
]
}If the interactive demo cannot load, use the static preview above.
What you can ship in a sheet
Move rows without breaking formulas
Structural edits rewrite references. The workbook engine keeps computed values current. Values paint as text. There is no HTML sink.
- Structural edits
Hand off CSV that stays inert
Import keeps formula-looking fields as text unless you opt in. Export neutralizes formula injection so a spreadsheet tool will not run them.
- CSV
planned
Work on it together, later
Collaboration on the document sync core is planned, not shipped. Localized formula display and native evaluation are planned too.
- Collaboration
From a workbook to a grid you can edit.
Model
Validate a workbook and keep every edit in a framework-free model.
Package:
@texuli/sheetsCalculate
Evaluate formulas and recalculate every dependent cell.
Package:
@texuli/sheetsEdit
Work the accessible grid and formula bar from the keyboard.
Package:
@texuli/sheetsExchange
Import and export CSV. Export neutralizes formula injection.
Package:
@texuli/sheets
Solution
Sheets
Packages
- L5
@texuli/sheetsFormula engine, workbook model, CSV and grid viewSubpaths: ./formula · ./model · ./csv · ./view
Built on
- L4
@texuli/data(Data views) - L3
texuli(Styled components) - L0
@texuli/core(Texels and the URL policy) - L0
@texuli/date(Date arithmetic)
Build with Sheets
Start with a sheet
Install
pnpm add @texuli/sheetsEvaluate a formula
import { createWorkbook, displayValue, loadUntrustedSheet } from '@texuli/sheets/model';
const loaded = loadUntrustedSheet("{\"format\":\"texuli-sheet\",\"formatVersion\":1,\"meta\":{\"title\":\"Office budget\"},\"sheets\":[{\"id\":\"costs\",\"name\":\"Costs\",\"rows\":20,\"columns\":4,\"cells\":{\"A1\":\"Desk\",\"B1\":120,\"A2\":\"Chair\",\"B2\":80,\"B3\":\"=SUM(B1:B2)\"}}]}");
if (loaded.ok) {
const workbook = createWorkbook(loaded.sheet, { now: () => Date.now() });
console.log(displayValue(workbook.value('costs', 2, 1)));
}
Import CSV
import { csvToSheet } from '@texuli/sheets/csv';
const imported = csvToSheet("item,amount\nDesk,120\nChair,80", { name: 'Orders' });
if (imported.ok) {
console.log(imported.sheet.sheets[0]?.name);
}
Edit with SheetView
<script lang="ts">
import { loadUntrustedSheet } from '@texuli/sheets/model';
import { SheetView } from '@texuli/sheets/view';
import '@texuli/tokens/base.css';
const loaded = loadUntrustedSheet("{\"format\":\"texuli-sheet\",\"formatVersion\":1,\"meta\":{\"title\":\"Office budget\"},\"sheets\":[{\"id\":\"costs\",\"name\":\"Costs\",\"rows\":20,\"columns\":4,\"cells\":{\"A1\":\"Desk\",\"B1\":120,\"A2\":\"Chair\",\"B2\":80,\"B3\":\"=SUM(B1:B2)\"}}]}");
let sheet = $state(loaded.ok ? loaded.sheet : null);
</script>
{#if sheet}
<SheetView bind:sheet now={() => Date.now()} />
{/if}
Verified by apps/website/tests/solutions/sheets-quickstart.test.ts
Recipes
Drop a grid into your app
Load a workbook, evaluate formulas, and show the grid, step by step in the Sheets docs.
Install the package (external site)
Add @texuli/sheets from npm (pre-1.0, in development).
For agents
Agents emit a spreadsheet as data through the spreadsheet catalog id. The host app checks it with validateDraft and the sheet check before painting; the remote MCP server refuses spreadsheet nodes. The packages are in development.
spreadsheetspreadsheet: In developmentCatalog component that carries a whole sheet in its sheet prop.
validateDraftvalidateDraft: In developmentCatalog check; spreadsheet nodes pass only with the checkSheet hook from the sheets model.
skills/texuli/blueprints/SKILL.mdskills/texuli/blueprints/SKILL.md: In developmentSkill stage J: forms, canvases, sheets and data sources as agent data.
Platforms
Web
Web: In developmentSvelte 5 packages published on npm (pre-1.0).
Compose Desktop
Compose Desktop: PlannedKotlin Multiplatform renderer on the JVM, built in this repository.
Android
Android: PlannedNative renderer target.
iOS
iOS: PlannedNative renderer target.
Start building with Sheets
An embeddable spreadsheet with formulas and CSV.
