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 |
| Text Rotation & Vertical Text | Turn cell text through -90..90 degrees, or switch on Japanese vertical writing; auto-fit measures the rotated outline |
| 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 |
| Find & Replace | Ctrl+F / Ctrl+H with a built-in bar β match case, entire cell, regular expressions, and a sheet / selection / workbook scope; replace-all undoes in one step |
| Range / Row / Column Move | Drag the selection border to relocate a block, or a selected row/column header to reorder lines; cancellable before-event and one-step undo |
| Multi-Range Selection | Ctrl/Cmd+click adds a range instead of replacing it, on cells and headers alike; delete, styling, auto-fit and copy act on every range |
| Images | Insert, drag and resize floating images, with Excelβs three cell anchors and a full xl/media xlsx round-trip |
| Hyperlinks | Links from xlsx open on click in a new tab (only http/https/mailto/tel); =HYPERLINK(); author links with setHyperlink; xlsx and JSON round-trip |
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 |
| PDF Export | In-browser vector PDF via our own engine β paginates exactly like the page-break preview (exportPdf() / saveAsPdf()); one sheet or the whole workbook in one document (sheets: 'all') |
| PDF Fonts by Locale | Name a locale (ja / zh-CN / zh-TW / ko) and the matching CJK font is embedded for you; registerPdfFont adds your own |
| Page Header & Footer | Page number, date, sheet or file name in the paper margins using Excelβs format codes (&P / &N / &D), with odd/even and first-page bands; xlsx round-trip |
| Fit to Pages | Excelβs γN γγΌγΈγ«εγγγ β say how many pages wide or tall, and the print scale is derived; preview, PDF and print all agree |
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 (30 steps by default, configurable via undoCapacity) |
| 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 |
| Form Mode | Locked layout, click-to-edit, placeholder hints and Enter/Tab navigation between input cells β a protected sheet fills in from the keyboard |
| Header Font | Choose the font family and size used to draw the row numbers and column letters |
| Zoom | 10%β400% per sheet with Ctrl/Cmd + wheel, trackpad pinch or setZoom(); only the view scales β print and exports stay at 100% |
| 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 |
| Find & Replace | Yes | Yes |
| Range / Row / Column Move | Yes | Yes |
| Multi-Range Selection | Yes | Yes |
| Text Rotation & Vertical Text | Yes | Yes |
| Form Mode | Yes | Yes |
| Header Font | Yes | Yes |
| Zoom | Yes | Yes |
| Hyperlinks | Read & open | 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 | Import / export only | Yes |
| Printing | β | Yes |
| PDF Export | β | Yes |
| PDF Fonts by Locale | β | Yes |
| Page Header & Footer | β | Yes |
| Fit to Pages | β | Yes |
| Animation | β | 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() |
Was this page helpful? Thank you for your feedback! 