Basics

Formatting

Context menu

Drag n Drop

Spreadsheet

Tabs

Export (csv, html, pdf, xlsx )

RTL Layout

Layouts

Rows

Paging

Big data

Columns

Cells

Inline editing

Row Grouping

Pivot

Sorting

Filter

Selections

Nesting / Row details

Tree grid

Charts

Angular

React React

Vue Vue

Knockout

;

Summary with Excel formulas

Number of rows can be frozen at the bottom of grid depending upon the number of rows in summaryData option.
In this example, Excel formulas are used in the summaryData to calculate aggregates of the rows.

Summary is refreshed whenever:
  • data changes due to inline editing or copy/paste.
  • data is filtered.