Saving data incorrectly with sorted data

[Scott]

I'm evaluating the spreadsheet component for possible use and I ran into an issue with saving changes to sorted data in the spreadsheet.  I'm binding a datasource into a sheet with CRUD references to the controller.  When the data is sorted and a user edits a row, on saving the update, the wrong row in the datasource is updated/sent to the controller.  Is this a known issue?  If so, do you know when this will be corrected?

Thanks.

Scott

 

[Veselin Tsvetanov]

Hello Scott,

The observed is a limitation that is present, when the Spreadsheet is bound to a DataSource. The Sorting and Filtering functionality will work correctly after the widget has been populated with data. However, making changes on the data after performing some of the above operations would result in incorrect data update. The reason for that is the fact that the Spreadsheet internally depends on the order in which the rows are loaded to the widget and updates the item by getting its row index.

Regards,
Veselin Tsvetanov
Telerik by Progress