Intelligent Grid documentation
Intelligent Grid is an Excel-like data grid for the browser, written in TypeScript and backed by SorlaDB. Rows live in a SorlaDB collection, filters compile to the Sorla query language, and a formula engine adds Excel calculations on top.
Guides
| Page | What it covers |
|---|---|
| Getting started | Install, ES module / CommonJS / browser bundle, SorlaDB setup, the first grid |
| React, Vue, Svelte and Angular | Ready-made components for each framework, how they map props, events and the instance |
| Grid options | Every constructor option |
| Columns | Column schema, types, formats, rendering, hidden columns |
| Sorting & filtering | Multi-column sort, AutoFilter menu, filter model, search |
| Advanced filter | Visual query builder: nested AND / OR / NOT, SorlaDB find() JSON |
| Editing & validation | Editors, parsing, validation, change hooks, keyboard, clipboard, custom editors |
| Selection | Single/multiple row selection, checkboxes, bulk actions |
| Spreadsheet features | Cell ranges, fill handle, undo / redo, find / replace / go to, comments, remove duplicates, shortcuts |
| Grouping & subtotals | Group rows by fields, collapse, subtotals per column |
| Import | CSV, TSV and XLSX files into the grid |
| Virtualization | Large data, pinned (frozen) columns, wrapped text, row height |
| Navbar & status bar | Built-in buttons, filter chips, custom items |
| Append mode (infinite scroll) | Loading pages from an API over fetch or a WebSocket, server-side vs local queries |
| Server data | Server-Sent Events loading in blocks, rows pushed by the server |
| Export | CSV and XLSX, options, formulas in Excel |
| Change tracking | Inserted/updated/deleted rows, history, JSON for forms, accept/reject |
| Formulas | Formula language, calculated columns, cell formulas, footers, conditional formats (data bars, color scales, icon sets), sparklines, custom functions |
| Function reference | All 137 functions with signatures |
| Number formats | Excel format codes for display, TEXT() and XLSX |
| Events | Every event, its detail and which ones can be cancelled |
| API reference | Every public method |
| Theming | CSS variables, dark mode, state classes |
| Internationalization | Locales, input parsing, labels |
| TypeScript | Exported types and typed usage |
Project
| Page | What it covers |
|---|---|
| Architecture | Module layout and how the grid uses SorlaDB |
| SorlaDB status | SorlaDB issues fixed for the grid (1.1–1.5) and the open items |
| Development | Scripts, build output, lint, husky hooks, tests, releasing |
| Benchmarks | Timings from 10 000 to 1 000 000 rows, bundle size |
Runnable examples are in examples/ (npm run demo).