New grid control – general availability
|Enabled for||Public preview||General availability|
|Users by admins, makers, or analysts||Aug 3, 2020||Oct 2, 2020|
The new grid provides a number of benefits:
Performance: The new grid provides improved rendering speed and a faster scrolling experience.
Positional scrolling: Users can now positionally scroll in the data that has been loaded in the web browser. For example, if you have browsed through 10,000 rows in a grid, you can click the middle of the scrollbar to immediately go to record 5,000 without having to retrieve data from the server.
General improvements: Various enhancements have been made to improve the usability of the grid. For example, in the existing grid, users might run into situations occasionally where the grid headers and data are misaligned, or the grid jumps while users scroll through data or create new records. These issues do not occur with the new grid control.
Reorder columns: Users can now reorder columns by dragging them. Hover the mouse pointer over the column header and then drag the gripper control that appears on the left side of the column.
Pinned marking column: The marking column in the new grid is pinned to the left and so will always be visible and available regardless of the width of the grid.
SizeToAvailable width columns: Developers can set WidthMode=SizeToAvailable on columns inside grids, and these columns will start with the same width as the SizeToContent width mode setting, but will stretch to use any extra available width inside the grid. If multiple columns are set to SizeToAvailable, they will share any extra available space in the grid.
Mathematical formulas: Users can now enter mathematical formulas into numeric cells in a grid. For example, you can enter =15*4. To make the system recognize a value as an expression, start the value with an equal sign (=).
Totals: Business users can see totals for numeric columns in tabular grids. For example, financial users can view totals for a filtered set of transactions for a specific customer. Note that the entire dataset is required for this functionality, so it might take time to calculate totals for large datasets.
Fast data entry: This feature lets users enter data in a grid ahead of the server. Therefore, it minimizes the need for users to wait for the server to validate one row in the grid before they move to another row. Users can also paste copied tables from Excel directly into grids in the system.
Follow the link in the "See also" section of this article for:
- More details about some of the capabilities listed above.
- Instructions on how to enable the new grid control.
- A list of known issues with the new grid control as well as information on when these issues have been addressed.
Grid capabilities (docs)
Implicit personalization (learn)