Features
ReoGrid Web is a high-performance, Canvas-based spreadsheet library for the browser. This page summarizes the full feature set, edition differences, and supported frameworks.
Core Features
| Feature | Description |
|---|
| Canvas Rendering | High-performance cell rendering using HTML5 Canvas |
| Cell Data | Reading and writing values, bulk loading, display text retrieval |
| Cell Styles | Font (family, size, bold, italic, underline), text color, background color, horizontal/vertical alignment, text wrapping |
| Number Formatting | Excel-compatible format codes (#,##0, ¥#,##0, 0.00%, etc.) |
| Borders | Cell and range borders (top, bottom, left, right; style, color, width) |
| Cell Merging | Merging and unmerging multiple cells |
| Row & Column Operations | Resizing, inserting/deleting, showing/hiding, auto-fit |
| Feature | Description |
|---|
| AST Parser | Parses Excel-compatible formula syntax |
| Dependency Graph | Automatic tracking and recalculation of cell references |
| Built-in Functions | 109 functions across math, statistics, trigonometry, logical, text, date/time, lookup, info, conditional aggregation, and random categories |
| Lookup & Reference | VLOOKUP, HLOOKUP, XLOOKUP, INDEX, MATCH, XMATCH, ADDRESS, ROW, COLUMN, ROWS, COLUMNS |
| Conditional Aggregation | SUMIF, COUNTIF, AVERAGEIF and the *IFS multi-criteria variants |
| Cell References | A1 notation (relative and absolute), range references |
| Smart Formula Editor | While editing a formula, click cells to insert references — each reference is color-coded with a matching outline on the grid |
Advanced Features
| Feature | Description |
|---|
| Auto-fill (Fill Handle) | Drag the bottom-right square of the selection to extend values down / up / left / right. Detects copy, arithmetic progression, date increment, and formula relative-reference patterns. |
| Freeze Panes | Freezing rows and columns (e.g., pinning header rows during scrolling) |
| Sorting | Ascending and descending column sort |
| Auto-Filter | Data filtering via header dropdowns |
| Grouping | Row and column outlining (collapse/expand) |
| Cell Types | Checkbox, dropdown, button, progress bar, rating, sparkline, hyperlink |
| Conditional Formatting | Value-, expression-, and text-based rules with per-side border overrides |
| Cell Protection | Sheet protection and per-cell locking |
Data I/O
| Feature | Description |
|---|
| XLSX Import | Load xlsx from URL, File object, or ArrayBuffer (optional chunked async load for big files) |
| XLSX Export | Download a worksheet as an xlsx file |
| ReoGrid JSON | Native lossless serialization (writeReoGridJson / readReoGridJson / parseReoGridJson) — preserves cells, styles, number formats, rich text, merges, borders, sizes/visibility, freeze, conditional formats, outlines, filter, cell types, protection, and alternate rows |
| Clipboard | Copy, cut, and paste (TSV / HTML format support) |
| Printing | Convert to HTML table for browser printing |
UI Features
| Feature | Description |
|---|
| Cell Editor | Inline text editing via double-click, F2, or Enter (Mac-friendly) |
| Smart Formula Editor | Excel-style color-coded reference editing — click cells to insert refs, drag to extend to a range |
| Undo / Redo | Undo and redo operations (up to 30 steps) |
| Keyboard Shortcuts | Ctrl+Z/Y, Ctrl+C/V/X, Tab, Enter, and more |
| Context Menu | Right-click menu event |
| Grid Lines | Toggle visibility on/off |
| Alternating Row Colors | Background color for even/odd rows |
| Animation | Smooth animation on cell value changes |
Edition Comparison
| Lite (Free) | Pro (Paid) |
|---|
| Rows | Up to 100 rows | Unlimited |
| Columns | Up to 26 columns (A-Z) | Unlimited |
| Formulas | Arithmetic only | All 109 functions |
| Cell Styles | Yes | Yes |
| Number Formatting | Yes | Yes |
| Borders | Yes | Yes |
| Cell Merging | Yes | Yes |
| Auto-fill | Yes | Yes |
| Smart Formula Editor | Yes | Yes |
| Freeze Panes | — | Yes |
| XLSX Import | Yes | Yes |
| XLSX Export | — | Yes |
| ReoGrid JSON I/O | Yes | Yes |
| Cell Types | — | Yes |
| Row/Column Insert & Delete | — | Yes |
| Row/Column Show & Hide | — | Yes |
| Sort & Filter | — | Yes |
| Grouping | — | Yes |
| Conditional Formatting | — | Yes |
| Cell Tooltip | — | Yes |
| Images | — | Yes |
| Printing | — | Yes |
Framework Support
| Framework | Package | Component |
|---|
| React ≥17 | @reogrid/lite/react or @reogrid/pro/react | <Reogrid> (forwardRef) |
| Vue ≥3 | @reogrid/lite/vue or @reogrid/pro/vue | <Reogrid> (Composition API) |
| Vanilla JS/TS | @reogrid/lite or @reogrid/pro | createReogrid() |
