Sheetwrite
GitHub

REACT / CONTROLLED ANALYTICS

React-controlled pipeline analytics.

Filter 100,000 pipeline accounts or edit a formula. React controls the query, while the grid calculates workbook KPIs and records edit history.

Adapter
React
Scenario
100,000 accounts
Owns
Query + analytics
Version
Sheetwrite 0.5.0

Pipeline analytics

React-controlled analytics
100,000accounts in the controlled viewConnecting
New in 0.5.0 · Toolbar colour swatches follow the live theme. Sheet tabs keep page scroll steady.
Secondary toolsFind & replace · native editing · data exchange · runtime

Find & replace

Matches · —

Native editing

Use Ctrl/⌘ C and Ctrl/⌘ V in the Grid. Drag the selection handle to fill; both flows land in the same undo history.

Data exchange

Runtime

Requested: Main thread · Active: Main thread
Try itFilter a market, then select an ARR cell and enter a value or formula. Workbook totals include every account; the market KPI reports the selected market. Open Secondary tools for search, CSV import, exports, and renderer controls.Keyboard ready · Canvas rendered

Public API in use

What this example demonstrates.

No mock controls or copied state. Every interaction above crosses the public adapter and Grid APIs.

  1. 01
    Controlled queries

    Market and segment filters, ranking, and search flow from React state.

  2. 02
    Formulas and KPIs

    Summary cards read real engine formulas — SUM over a named range, AVG, SUMIF per market — and recalculate on every edit.

  3. 03
    Reset reconciliation

    Dataset reloads and renderer swaps rebuild the grid; the surviving React state re-applies itself on ready.

  4. 04
    Data workflows

    CSV import lands as one undoable commit; CSV/XLSX exports hand off to the interoperability proofs.