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.