Excel spreadsheet formulas in javascript treegrid

Expand All

;

Summary in title row

This example leverages extensibility of Excel formulas by

defining a custom Excel formula SUMTREE which receives row Index as argument
adding pq_fn: { size: "SUMTREE(ROW()-1)" } in all folder nodes in JSON data

to display summary in the same row as folder nodes. Note that the reference to grid instance variable used in the formula has been taken with help of render event.

Javascript
HTML
CSS
ASP.NET (MVC)
PHP
Java

React

Vue

Summary in title row