Live Examples

Progress bars, star ratings, sparkline charts, checkboxes, and hyperlinks — all rendered inside spreadsheet cells.

Click column header dropdowns to filter and sort rows. Switch between 300, 1K, and 10K rows to test performance.

Font styles, colors, backgrounds, text alignment, and border options — a showcase of the Cell Style API.

Toggle frozen rows and columns interactively. Scroll a 50-row dataset while headers stay fixed.

Cell merging for titles, grouped headers, side labels, and complex multi-level table layouts.

Format numbers as currency, percentages, dates, and custom patterns — a reference of all supported format codes.

Value-based cell styling with traffic-light stock levels, expression rules comparing sales vs targets, and text-match status coloring — all updating live as you edit.

Event registration form with contextual tooltips: blue hints for required fields, red error messages after validation. Fill, validate, and cycle through errors interactively.

Japanese era dates (令和/平成/昭和) and bracket color formats ([赤]/[Red]) for business documents — P&L statement demo with red-negative display.

3-level row outline (Region → Country → Branch) × 1-level column outline (quarters). All subtotals are live SUM formulas — edit any cell and watch four levels of totals update.

Four sheets in one workbook with a built-in tab bar. The Summary sheet consolidates three branch sheets entirely with cross-sheet formulas (='Tokyo'!E6) — edit any branch and the totals recalculate across sheets.

Live, API-driven pivot tables — pick row/column fields and an aggregation (sum, average, count, min, max) computed from a source range and rendered into the grid. Edit any source value and the pivot recomputes.

Excel "Format as Table" — built-in banded styles applied as a live overlay via range.formatAsTable(). Switch styles instantly, toggle banded rows, and insert a row to watch the banding re-flow. Round-trips as a real xlsx table.

Excel-style input rules (入力規則): list dropdowns, whole/decimal/date/time and text-length bounds, and custom formulas — with stop / warning / information alerts. Pro-authored rules also enforce in Lite and round-trip through xlsx.

Template-driven detail repetition (テンプレート明細繰り返し): design an invoice once with {{token}} cells, then bindReport(data) materializes header / detail(×N) / footer in place with per-row formula shift, footer aggregates, and page breaks.

Classic Excel comments / memos (メモ) — one per cell, shown with a red corner marker and a hover bubble. Select a cell to add, edit, or remove its comment. xlsx read, JSON round-trip.

Dependency-free PDF export with a page-break preview: setShowPageBreaks(true) shows the printable pages on screen, and saveAsPdf({ locale: 'ja', usePageBreaks: true }) paginates the PDF exactly like the preview — with a page header/footer using Excel format codes (&P / &N / &D).

Excel-style Ctrl+F / Ctrl+H with a built-in find bar: match case, entire cell, regular expressions, and a sheet / selection / workbook scope. Every match is highlighted on the canvas, and replace-all undoes in one step.

Drag the selection border to relocate a cell block, or drag a selected row/column header to reorder whole lines — with a cancellable onBeforeRangeMove event (the header row is pinned here) and one-step undo.

Invoice with editable quantities and unit prices — totals auto-calculate with formulas. Available on StackBlitz as React, Vue, and Vanilla.

Edit quantities and unit prices — totals auto-calculate with SUM formulas. Real spreadsheet formulas running in the browser.

Monthly attendance tracking with weekend/holiday coloring and summary columns.

Quarterly income and expense tracker with category sections, color-coded totals, and profit summary.

A scrollbar that represents one million rows while only visible rows are fetched on demand. Jump anywhere — the grid keeps a few hundred rows in memory.

Load 10,000 rows instantly and sort by any column. Sort time is displayed in real-time — typically under 1 second.

Formula results animate smoothly when values change. Watch numbers and progress bars transition fluidly.

Load an .xlsx and convert it to JSON in the browser — clean data rows for apps & AI, or the lossless ReoGrid JSON workbook. Toggle, copy, download.