Aggregates in virtual scrolling or pagination

[Piyush Bhatt]

We are using virtual scrolling in our grid. And the Grid allows InCell editing to users. Now when user updates the value in a cell, we immediately want to display the Total in the footer. We cannot refetch all the data for the page for each user edit. 

The client side data has only as many rows as the pagesize() - so calculating client side total is not accurate.

We can calculate the total on the server side but we need some function that only gets the Aggregates in the result and updates the footer portion - we cannot afford refetch the whole page data.

Please tell us what are our options.

[Kiril Nikolov]

Hi Piyush,

The idea behind virtual scrolling is to load only the data that is currently being displayed. This is why calculating aggregates for all the data is not supported as the data is actually not available on the client. Furthermore please note that editing mode is also not supported for the Kendo UI Grid with virtual scrolling, as the edited and newly added rows are not positioned correctly within the virtualized records.

Regards,
Kiril Nikolov
Telerik