Hi Rahesh,

The upper half (before the green Add button) is not a grid, it might be a form.

The grid itself can show calculated fields easily - you have two options for that:

• have the calculated field directly in your mode, and set it to the Field of a column
• Or, use the Template of a column to do the calculation you need

These are the two ways such calculations are done in a grid. Allowing the user to make up formulas is beyond the scope of a grid and would be available in the Spreadsheet component.

Regards,
Marin Bratanov
Progress Telerik

Hello Rajesh,

This is a task for a spreadsheet component, not for a grid. You can Follow the implementation of a spreadsheet here: https://feedback.telerik.com/blazor/1442151-spreadsheet-component.

A grid cannot provide that UX for a number of reasons, such as:

• it is not its goal and concept to be a spreadsheet
• the last row is usually on a certain page and fetching the new page is usually a slow operation that may even depend on application logic, so the grid can't arbitrarily decide to do that
• an insertion operation with incell editing happens immediately on the datasource, so the grid should not do this on its own either, it needs to have a meaningful use interaction
• an inserted row in the grid is at the top of the current page and not at the bottom. Perpahs that might change through this enhancement but still, adding a record is not the grid should do on its own

Regards,
Marin Bratanov
Progress Telerik