Product reference
What the GRID engine, viewer and editor do today, feature by feature, and what survives the trip through XLSX.
The same functions, syntax, error values and edge cases, including the parts of the calculation model most engines skip.
Dynamic arrays · LET and LAMBDA · Iterative calculation · Goal seek · Data tables · External references · 3-D references
AI agents call our spreadsheet tools directly instead of spending tokens on code, and everything with an engine mark in the table below is theirs to use.
High-level operations · Change deltas on every write · Warnings and error lists · Precedents and dependents · What-if without writing
Workbooks come in from XLSX and go back out with their sheets, cells, formulas and calculated values, and with their styles, number formats, comments, tables and views.
Sheets and formulas · Calculated values · Styles and themes · Number formats · Threaded comments · Tables
The viewer and editor behave the way people expect a spreadsheet to behave, down to the keyboard shortcuts they already know.
Keyboard navigation · Fill and auto-fill · Undo and redo · Smart input parsing · Formula bar · Syntax highlighting
| Feature | EngineEnginemodels and calculates itThe engine models it, so code and agents can read and change it through the API. That is why features that look like display, such as fonts and borders, carry an engine mark. | ViewerViewerrenders itIt is rendered, and where it applies interactive, in the read-only viewer. The editor renders everything the viewer does. | EditorEditorhas UI to change itThe editor has a built-in control for it. The code mark means it has none yet, but the engine supports it: edit it through the API, or add it to the editor with your own UI. | File round-tripFilessurvives XLSX in and outIt comes back out of an XLSX export the way it came in, through recalculation and structural edits, including where the engine never acts on it. |
|---|---|---|---|---|
| Formulas and calculation | ||||
| 505/542 | ✓ | ✓ | ✓ | |
| 21/21 | ✓ | ✓ | ✓ | |
| Defined names (named ranges) | ✓ | ✓Supported through the engine | No built-in control in the editor yet. The engine supports it, so it can be edited through the API, and a custom UI can add it to the editor. | ✓ |
| ✓ | ✓Supported through the engine | ✓ | n/aDoes not apply to this product | |
| LET/LAMBDA functions | ✓ | ✓Supported through the engine | ✓ | n/aDoes not apply to this product |
| 3-D (sheet-range, cross-tab) references | ✓ | ✓Supported through the engine | No built-in control in the editor yet. The engine supports it, so it can be edited through the API, and a custom UI can add it to the editor. | ✓ |
| External references (linked workbooks) | ✓ | ✓Supported through the engine | No built-in control in the editor yet. The engine supports it, so it can be edited through the API, and a custom UI can add it to the editor. | ✓ |
| ✓ | ✓Supported through the engine | No built-in control in the editor yet. The engine supports it, so it can be edited through the API, and a custom UI can add it to the editor. | ✓ | |
| ✓ | ✓Supported through the engine | No built-in control in the editor yet. The engine supports it, so it can be edited through the API, and a custom UI can add it to the editor. | ✓ | |
| Data tables | ✓ | ✓Supported through the engine | No built-in control in the editor yet. The engine supports it, so it can be edited through the API, and a custom UI can add it to the editor. | ✓ |
| Goal seek | ✓ | ✓Supported through the engine | No built-in control in the editor yet. The engine supports it, so it can be edited through the API, and a custom UI can add it to the editor. | n/aDoes not apply to this product |
| Values and number formats | ||||
| ✓ | ✓ | ◐Partly supported | ✓ | |
| n/aDoes not apply to this product | ✓ | n/aDoes not apply to this product | ||
| Increase and decrease decimals | n/aDoes not apply to this product | n/aDoes not apply to this product | ✓ | n/aDoes not apply to this product |
| Hyperlinks | ✓ | ✓ | ||
| Locale support | ◐Partly supported | ◐Partly supported | ◐Partly supported | |
| Styling | ||||
| ✓ | ✓ | ◐Partly supported | ✓ | |
| ✓ | ✓ | ✓ | ||
| ✓ | ✓ | in progress◌Planned or in development | ✓ | |
| ✓ | ✓ | ◐Partly supported | ✓ | |
| Conditional formatting | in progress◌Planned or in development | in progress◌Planned or in development | in progress◌Planned or in development | in progress◌Planned or in development |
| Rich text | in progress◌Planned or in development | in progress◌Planned or in development | ||
| Named cell styles | ✓ | ✓ | No built-in control in the editor yet. The engine supports it, so it can be edited through the API, and a custom UI can add it to the editor. | ✓ |
| Themes and custom themes | ✓ | ✓ | No built-in control in the editor yet. The engine supports it, so it can be edited through the API, and a custom UI can add it to the editor. | ✓ |
| Column / row styles | ◐Partly supported | ✓ | in progress◌Planned or in development | ✓ |
| Sheet structure | ||||
| ✓ | ✓Supported through the engine | ✓ | n/aDoes not apply to this product | |
| Insert cells | ✓ | ✓Supported through the engine | ✓ | n/aDoes not apply to this product |
| Delete cells | ✓ | ✓Supported through the engine | ✓ | n/aDoes not apply to this product |
| ✓ | ✓ | ✓ | n/aDoes not apply to this product | |
| Row heights & column widths | ✓ | ✓ | ✓ | ✓ |
| ✓ | ✓ | ✓ | ✓ | |
| Hidden rows / columns | ✓ | ✓ | in progress◌Planned or in development | ✓ |
| ✓ | ✓Supported through the engine | ✓ | n/aDoes not apply to this product | |
| ◐Partly supported | ◐Partly supported | |||
| Tables and pivots | ||||
| ✓ | ✓ | No built-in control in the editor yet. The engine supports it, so it can be edited through the API, and a custom UI can add it to the editor. | ✓ | |
| ◐Partly supported | ◐Partly supported | ◐Partly supported | ||
| Charts and drawings | ||||
| Charts | in progress◌Planned or in development | in progress◌Planned or in development | in progress◌Planned or in development | |
| Bitmap images | in progress◌Planned or in development | in progress◌Planned or in development | in progress◌Planned or in development | |
| Shapes | in progress◌Planned or in development | in progress◌Planned or in development | in progress◌Planned or in development | |
| Textboxes | in progress◌Planned or in development | in progress◌Planned or in development | ||
| Comments and notes | ||||
| ✓ | ◐Partly supported | ◐Partly supported | ✓ | |
| ✓ | ◐Partly supported | No built-in control in the editor yet. The engine supports it, so it can be edited through the API, and a custom UI can add it to the editor. | ✓ | |
| Views | ||||
| Freeze panes | ✓ | in progress◌Planned or in development | No built-in control in the editor yet. The engine supports it, so it can be edited through the API, and a custom UI can add it to the editor. | ✓ |
| Gridlines shown / hidden | ✓ | ✓ | ||
| Sheet zoom levels | in progress◌Planned or in development | ✓ | ||
| Edit state | ✓ | ✓Supported through the engine | ✓ | ✓ |
| Focus cell | in progress◌Planned or in development | n/aDoes not apply to this product | ✓ | ✓ |
| Reading and writing | ||||
| XLSX import | ✓ | ✓ | ✓ | n/aDoes not apply to this product |
| XLSX export | ✓ | ✓Supported through the engine | in progress◌Planned or in development | n/aDoes not apply to this product |
| Read from cells | ✓ | ✓ | ✓ | n/aDoes not apply to this product |
| Write values to cells | ✓ | ✓Supported through the engine | ✓ | n/aDoes not apply to this product |
| Write formulas to cells | ✓ | ✓Supported through the engine | ✓ | n/aDoes not apply to this product |
| ◐Partly supported | n/aDoes not apply to this product | ◐Partly supported | n/aDoes not apply to this product | |
| Editing and navigation | ||||
| ✓ | ◐Partly supported | n/aDoes not apply to this product | ||
| Undo/Redo | n/aDoes not apply to this product | ✓ | n/aDoes not apply to this product | |
| ✓ | ✓Supported through the engine | ✓ | n/aDoes not apply to this product | |
| Move cells (Cut/Paste) | ✓ | ✓Supported through the engine | ✓ | n/aDoes not apply to this product |
| Drag-and-drop cells | n/aDoes not apply to this product | n/aDoes not apply to this product | ✓ | n/aDoes not apply to this product |
| n/aDoes not apply to this product | n/aDoes not apply to this product | ✓ | n/aDoes not apply to this product | |
| n/aDoes not apply to this product | ✓ | ✓ | n/aDoes not apply to this product | |
| Interface | ||||
| Formula bar UI | n/aDoes not apply to this product | ✓ | ✓ | n/aDoes not apply to this product |
| Sheet selection UI (tabs) | n/aDoes not apply to this product | ✓ | ✓ | n/aDoes not apply to this product |
| Function help | n/aDoes not apply to this product | ✓ | n/aDoes not apply to this product | |
| Syntax highlighting | n/aDoes not apply to this product | ✓ | ✓ | n/aDoes not apply to this product |
| Formula reference highlighting while editing | n/aDoes not apply to this product | n/aDoes not apply to this product | ✓ | n/aDoes not apply to this product |
| Formula reference highlighting on single click | n/aDoes not apply to this product | ✓ | in progress◌Planned or in development | n/aDoes not apply to this product |
| Quick stats for selections (SUM/COUNT/AVG) | n/aDoes not apply to this product | ✓ | ✓ | n/aDoes not apply to this product |
| Error detail display | n/aDoes not apply to this product | ✓ | in progress◌Planned or in development | n/aDoes not apply to this product |
| n/aDoes not apply to this product | n/aDoes not apply to this product | ◐Partly supported | n/aDoes not apply to this product | |
| Paint format | n/aDoes not apply to this product | n/aDoes not apply to this product | ✓ | n/aDoes not apply to this product |
✓ supported✓ supported through the engine◐ partly supported editable through the API, add it to the editor with your own UIin progress◌ planned or in developmentn/a does not apply to that productblank: not supported yet
The table lists the features that are supported today or on the way. Missing something you need? Tell us.
Install the engine from npm with a free evaluation license and start building today. When you are ready to ship, talk to us. Most teams are surprised how quickly they go from first install to production, with direct support from the GRID team throughout.