Meta tags:
description=Spreadsheet 2 - High performance Canvas Spreadsheet component;

Headings (most frequently used words):

spreadsheet, and, usespreadsheetstate, hook, composable, declarative, component, built, for, developers, features, compose, the, perfect, bring, your, own, data, model, state, management, structured, references, calculated, columns, real, time, formulas, collaborative, editing, resources, company, legal, support, or, use,

Text of the page (most frequently used words):
#spreadsheet (25), const (21), and (20), spreadsheetprovider (11), usestate (11), columns (10), you (9), app (9), sheetdata (9), sheet (8), custom (7), rows (7), with (7), your (7), from (7), the (7), import (7), rowsncolumns (7), number (7), tables (6), columncount (6), rowcount (6), sheetid (6), canvasgrid (6), celldata (6), state (6), other (5), data (5), learn (5), more (5), for (5), hook (5), toolbar (5), all (5), return (5), usespreadsheetstate (5), sheets (4), charts (4), embeds (4), can (4), real (4), time (4), built (4), theme (4), onclick (4), onchangesheetdata (4), columnindex (4), rowindex (4), type (4), support (3), documentation (3), calculated (3), ranges (3), functions (3), cells (3), export (3), wrap (3), merges (3), selections (3), activecell (3), columnmetadata (3), rowmetadata (3), frozenrowcount (3), frozencolumncount (3), conditionalformats (3), scale (3), buttonredo (3), buttonundo (3), onchangesheets (3), colormode (3), redo (3), undo (3), management (3), mycelldata (3), rowdata (3), components (3), bottombar (3), discord (2), contact (2), named (2), cell (2), agnostic (2), use (2), add (2), formulas (2), which (2), using (2), developers (2), rendered (2), html (2), canvas (2), giving (2), 60fps (2), rendering (2), performance (2), ability (2), display (2), millions (2), without (2), peformance (2), impact (2), methods (2), activesheetid (2), spreadsheetcolors (2), controls (2), canredo (2), disabled (2), canundo (2), onchangetheme (2), onchangenamedranges (2), onchangetables (2), onchangecharts (2), onchangeembeds (2), locale (2), namedranges (2), defaultspreadsheettheme (2), spreadsheettheme (2), namedrange (2), tableview (2), embeddedobject (2), embeddedchart (2), collaboration (2), optional (2), full (2), are (2), values (2), getcelldata (2), model (2), choose (2), callbacks (2), own (2), sheetstatus (2), sheettabs (2), sheetswitcher (2), formulabar (2), formulabarinput (2), rangeselector (2), 1000 (2), build (2), component (2), composable (2), declarative (2), home (2), github, terms, service, privacy, policy, legal, twitter, sales, company, releases, resources, easily, integrate, 3rd, party, apis, like, openai, language, models, sorting, filtering, banded, protected, formula, dark, mode, insert, delete, move, show, hide, merge, context, menu, fonts, copy, paste, cut, styling, renderers, tooltips, editors, frozen, validation, conditional, formatting, colors, color, scales, strutures, crdt, back, end, stack, partykit, replicache, etc, allow, multiple, users, work, collaborative, editing, javascript, connect, sources, create, reference, column, names, syncs, dynamic, table, structured, references, features, true, stickyeditor, enabletextoverflow, onredo, onundo, isdarkmode, bandedranges, protectedranges, usd, currency, onchangecolormode, onchangescale, calculation, framework, web, worker, capability, uses, immer, this, production, grade, want, get, started, complete, prevdata, its, persist, generate, patches, string, value, onchange, record, extends, hello, customproperty, persistence, any, database, storage, uncontrolled, stateless, renders, based, props, that, pass, invokes, user, actions, bring, formattedvalue, sum, formulavalue, userenteredvalue, formulabarlabel, see, also, functionality, top, many, pick, need, compose, perfect, escape, hatches, access, internals, customize, liking, current, version, demo, beautifully, designed, react, customizable, enterprise, pricing,

Text of the page (random words):
home rows n columns rows n columns home pricing documentation enterprise contact us discord spreadsheet 2 composable declarative spreadsheet component beautifully designed spreadsheet component for react composable customizable declarative full demo documentation current version rowsncolumns spreadsheet 10 5 13 rowsncolumns spreadsheet state 29 1 17 built for developers spreadsheet is rendered in html canvas giving you 60fps rendering performance and ability to display millions of rows and columns without peformance impact with escape hatches you can access the internals and customize it to your liking compose the perfect spreadsheet pick and choose the components you need to build your spreadsheet you can also build own custom functionality on top of spreadsheet 2 with the many callbacks from canvasgrid see all components import spreadsheetprovider canvasgrid toolbar buttonundo buttonredo rangeselector formulabarlabel formulabarinput bottombar sheetswitcher sheettabs sheetstatus from rowsncolumns spreadsheet const app const sheet id 1 rowcount 1000 columncount 1000 return toolbar buttonundo onclick buttonredo onclick import all other controls toolbar formulabar rangeselector formulabarinput formulabar canvasgrid sheetid sheet id rowcount sheet rowcount columncount sheet columncount getcelldata sheetid number rowindex number columnindex number celldata return userenteredvalue formulavalue sum 4 4 formattedvalue 8 bottombar sheetswitcher sheettabs sheetstatus bottombar wrap your app in spreadsheetprovider export const spreadsheet spreadsheetprovider app spreadsheetprovider bring your own data model and state management or use usespreadsheetstate hook spreadsheet components are all uncontrolled and stateless it renders based on the props that you pass in and invokes callbacks to user actions spreadsheet 2 is agnostic of your data persistence model you can choose any database for storage or real time collaboration learn more import type celldata from rowsncolumns spreadsheet import usespreadsheetstate sheet sheetdata rowdata from rowsncolumns spreadsheet state type mycelldata celldata customproperty hello type sheetdata t extends celldata record number rowdata t type rowdata t values t const app const sheets onchangesheets usestate sheet const sheetdata onchangesheetdata usestate sheetdata mycelldata return canvasgrid mycelldata getcelldata sheetid rowindex columnindex return sheetdata sheetid rowindex values columnindex onchange value string sheetid number rowindex number columnindex number persist and generate undo redo patches if you are using usespreadsheetstate hook its all built in onchangesheetdata prevdata wrap your app in spreadsheetprovider export const spreadsheet spreadsheetprovider app spreadsheetprovider usespreadsheetstate hook this is an optional production grade hook if you want to get started with the spreadsheet with complete state management uses immer for state management full undo redo capability calculation framework with optional web worker support real time collaboration built in learn more import defaultspreadsheettheme sheet sheetdata from rowsncolumns spreadsheet state import celldata namedrange embeddedobject embeddedchart tableview spreadsheettheme canvasgrid spreadsheetprovider from rowsncolumns spreadsheet const app const sheets onchangesheets usestate sheet const sheetdata onchangesheetdata usestate sheetdata celldata const scale onchangescale usestate 1 const colormode onchangecolormode usestate colormode const charts onchangecharts usestate embeddedchart const embeds onchangeembeds usestate embeddedobject const tables onchangetables usestate tableview const namedranges onchangenamedranges usestate namedrange const theme onchangetheme usestate spreadsheettheme defaultspreadsheettheme const locale en gb const currency usd const activecell activesheetid selections rowcount columncount frozencolumncount frozenrowcount rowmetadata columnmetadata merges protectedranges bandedranges conditionalformats isdarkmode spreadsheetcolors canredo canundo undo redo other spreadsheet methods usespreadsheetstate sheets sheetdata tables functions namedranges theme colormode locale onchangesheets onchangesheetdata onchangeembeds onchangecharts onchangetables onchangenamedranges onchangetheme return toolbar buttonundo onclick onundo disabled canundo buttonredo onclick onredo disabled canredo import all other controls toolbar canvasgrid spreadsheetcolors enabletextoverflow stickyeditor true scale scale conditionalformats conditionalformats sheetid activesheetid rowcount rowcount columncount columncount frozencolumncount frozencolumncount frozenrowcount frozenrowcount rowmetadata rowmetadata columnmetadata columnmetadata activecell activecell selections selections theme theme merges merges charts charts embeds embeds tables tables other methods from the hook wrap your app in spreadsheetprovider export const spreadsheet spreadsheetprovider app spreadsheetprovider spreadsheet features built for developers spreadsheet is rendered in html canvas giving you 60fps rendering performance and ability to display millions of rows and columns without peformance impact structured references and calculated columns create tables and reference cells using column names add calculated columns which syncs with dynamic table cells learn more real time formulas add named javascript functions as formulas which can connect to real time data sources learn more collaborative editing allow multiple users to work on a spreadsheet agnostic of data strutures crdt ot or back end stack use partykit replicache etc learn more conditional formatting with colors and color scales data validation frozen rows and columns custom editors custom tooltips custom cell renderers custom charts and embeds cell styling copy paste and cut support custom fonts context menu merge cells show hide rows and columns insert delete move rows and columns dark mode custom formula functions protected ranges named ranges banded ranges calculated columns sorting filtering sheets and tables easily integrate 3rd party apis like openai and other language models resources releases spreadsheet documentation company contact sales twitter legal privacy policy terms of service support github discord