Saving data incorrectly with sorted data

2 posts, 0 answers
  1. Scott
    Scott avatar
    2 posts
    Member since:
    Nov 2016

    Posted 07 Dec 2016 Link to this post

    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

     

  2. Veselin Tsvetanov
    Admin
    Veselin Tsvetanov avatar
    590 posts

    Posted 08 Dec 2016 Link to this post

    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
    Telerik UI for ASP.NET MVC is ready for Visual Studio 2017 RC! Learn more.
Back to Top