Display millions of rows or columns without pagination using virtual scrolling.
Lightning-fast rendering with smooth scrolling
Smart virtualization loads only visible cells.
Memory-efficient architecture with automatic cleanup.
Optimized for large datasets using minimal DOM footprint.
Lazy loading and progressive data fetching
Caching and memoization for repeated operations.
Optimized and fast JSON I/O format.
Optional ultra-fast UTF8 Store data format.
Full Excel-style editable formula engine with 200+ functions.
Expression-based calculations and custom formulas.
Full JavaScript formulas and calculations in data.
Cell types: text, HTML, number, date, checkbox, combo box, image, link...
Support for side icons and buttons in cells.
Multi-state checkboxes for advanced workflows.
Simple and calculated bar & line charts embedded directly in cells.
Advanced formatting based on type and format strings.
Conditional formatting with custom rules and conditions.
Each row supports its own column structure and widths.
Each column section supports its different rows & heights.
Unlimited independently-scrollable and resizable sections.
Sticky rows remain visible during vertical scrolling.
Sticky cell text remains visible during horizontal scrolling.
Cell spanning across rows, columns or both directions.
Customizable state colors, icons and indicators.
Optional column-based grid mode for alternative layouts.
Add, copy and delete rows and columns.
Resize, move and hide row and columns.
Freeze rows and columns on all sides.
Drag rows or columns between grids.
Resize row and column sections and the entire grid.
Span cells dynamically for layout flexibility.
Multiple selection modes: row, column, cell and range.
Copy & paste rows, columns and cell ranges.
Full undo & redo support.
In-cell editing with Excel-like keyboard navigation.
Single-cell or range cursor.
Auto-complete with suggestions and rules.
Advanced validation via custom rules or regex.
Input masks with regular expressions.
Multi-line editing in text areas
Rich text editing with full formatting and styling.
Auto-fill and smart fill-down operations.
Copy & paste cells and ranges from and to Excel and other spreadsheets.
Copy & paste cell styles and formats.
Calendar picker for date cells.
Inserting images floating above cells like in Excel.
Manipulating and changing images by mouse dragging.
Unlimited tree hierarchy for rows and columns.
Expand & collapse with keyboard shortcuts.
Row tree can be split in more columns.
Dynamic multi level pivot tables with drag & drop configuration.
Editable pivot cells with automatic or custom aggregation
Flexible grouping with automatic or custom aggregation
Tree filtering and search capabilities for hierarchical datasets.
Expand indicators displaying number of hidden items.
Excel-style auto-filter with checkbox lists.
Expression filtering with custom operators
Global Google-like full-text search.
Custom filter functions and predicates.
Multi-column sorting with custom comparators.
Sorting and filtering both rows and columns.
Aggregation functions (sum, average, count, ...).
Statistical analysis and data summaries.
Export to XLSX, CSV, PDF with customizable styling.
Print-ready layouts with multi-page splitting and scaling.
HTML export with full formatting preservation.
Synchronize changes via AJAX, form submits or custom API.
Works with React, Vue, Angular, Svelte and Vanilla JavaScript.
Full TypeScript definitions and IntelliSense support.
Comprehensive API and event system.
Can be used without writing custom JavaScript.
Cross-browser compatibility (Chrome, Firefox, Safari, Edge).
Salesforce LWC & CSP compatibility.
Full theming support with JSON customization.
Built-in themes and custom theme creation.
Responsive design with mobile and touch support.
Customizable toolbar and context menu options.
Full manual and automatic toolbar arrangement.
Customizable cell styling and formatting.
Custom cell renderers and editors.
Flexible layout options with unlimited sections.
Localization to any language possible, including date and number formats.
Fully customizable key and mouse navigation action schemes.
User-managed configuration profiles.