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 | 32 functions including SUM, AVERAGE, IF, VLOOKUP |
| Cell References | A1 notation (relative and absolute), range references |
Advanced Features
| Feature | Description |
|---|
| 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 |
| Cell Protection | Sheet protection and per-cell locking |
Data I/O
| Feature | Description |
|---|
| XLSX Import | Load xlsx from URL, File object, or ArrayBuffer |
| XLSX Export | Download a worksheet as an xlsx file |
| 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 or F2 |
| 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 32 functions |
| Cell Styles | Yes | Yes |
| Number Formatting | Yes | Yes |
| Borders | Yes | Yes |
| Cell Merging | Yes | Yes |
| Freeze Panes | — | Yes |
| XLSX Import | Yes | Yes |
| XLSX Export | — | Yes |
| Cell Types | — | Yes |
| Row/Column Insert & Delete | — | Yes |
| Row/Column Show & Hide | — | Yes |
| Sort & Filter | — | Yes |
| Grouping | — | 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() |
