Virtual scrolling makes grid more compatible for scenarios where huge data needs to be bound without paging layout. It uses on-demand loading for adding rows at the event of scrolling, thus improving the grid initial loading time by requesting only visible row data.
Grid provides full support for CRUD operations. Editing can be enabled and customized with simple property settings. There are several editing options available including different cell edit types and edit modes. Editing can be saved to database as a batch operation using “Excel-like editing” and as individual operations using dialog, inline, and external form editing options.
Aggregates for column values can be easily visualized using the summary feature of grid. The aggregates can be customized to display the value in individual summary rows, individual group summary rows, or in a group caption row. Different aggregates supported are sum, average, min, max, count, and custom.
All grid features are optimized for touch screens. This includes swipes for paging and scrolling, and tabs for selecting, sorting, filtering.
Grid columns can be set to freeze, resize, reorder, and show or hide at runtime and initial load. These features are useful when visualizing data that have a large number of columns.
Grid supports grouping and sorting to help users visualize the data in an organized way. The data can be sorted or grouped in ascending or descending order. Also, grid provides support for multicolumn sorting and grouping. Sorting can be performed with simple header clicks and Ctrl + Click can be used for multicolumn sorting. For grouping, an interactive drop area is available where columns can be dragged and dropped.
All grid control strings in the user interface can be localized as needed. The grid control also supports languages with right-to-left direction.
Templates can be used to create custom user experiences in grid. Grid provides template options in various areas, including header, column, row, details row, dialog edit, inline edit, and external edit.
Selection enables users to select the rows displayed in a grid. Based on the selection events, we can do any desired actions. There are two types of selection available in grid: single and multiple. Single selection is used to select a row and multiple selection is used to select multiple rows.
Any grid data can be exported to Excel, Word, or PDF files using the exporting feature of grid. It is possible to export grouped, sorted, filtered, and summary row data into Excel, Word, and PDF files.
Grid can be printed very easily by using the print grid feature. The print grid icon is available in the grid toolbar by simply clicking the print icon to print the grid.
The adaptive feature allows the grid to adapt to the screen size. There is a normal view and a details view to give your users the best look and feel of your application. The filtering also changes in mobile view. The grid has a larger, more finger-friendly interface to define filter parameters.
Stacked header allows you to display header type information above the grid columns. There is no limit to the number of stacked headers. The data columns can still be grouped, sorted, and filtered.