Data Sheet Enhancements

This page lists all the enhancements that are released for the Data Sheet.

Please check out the given walk-through to understand the enhancements for Data Sheet.

Data Sheet Enhancements

The following enhancements are provided for Data Sheet as a Data source connection:

Add Row

Provided the Add Row (+) option to add a new row in the Data Sheet.

Ability to Freeze Columns

The Freeze Column option can be enabled from the Properties tab provided for the Dataset.​

Edit the Frozen Column

  • Navigate to the Dataset Properties and select a column.

  • Enable the Frozen Column option from the Properties tab of the Dataset.

  • The selected column gets frozen and becomes non-editable in the Preview mode.

  • Add a new row using the Add new Row option, the cell added under the frozen column is editable.

Pagination Property

Provided pagination within the General Properties option. By enabling the Pagination option from the General properties, the page number gets displayed on the Data Sheet component.

Delete Row

Introduced the Delete Selected Row option with a confirmation message before a row gets deleted in the Preview mode.

Save Option Update

The Save option gets updated in red color when something is edited in the datasheet.​

Please Note: Other than the above listed enhancements the below given enhancements are also provided to the Data Sheet data source.

  • Updated the JExcel DataGrid and JSuites library with the latest stable version (4.6.1).

  • Able to retrieve more records of data.