Allow editing of sorted databound Spreadsheet

[jivanova]

Bug report

http://dojo.telerik.com/oHeWi/6

Reproduction of the problem

1. Check line 13 -> (ProductId: 12, ProductName: Queso Manchego la Pastora)
2. Once the spreadsheet is loaded, Sort range Z to A in column B (ProductName)
3. Change the ProductName of the line 13 (currently -> ProductId: 35, ProductName: Steeleye Stout)
4. Click on button "Save Changes"

Current behavior

Changes have been applied to ProductId 12 instead of ProductId 35, so now ProductId 12, which had ProductName: Queso Manchego la Pastora in step 0, has changed to the ProductName you introduced for ProductId 35

Expected/desired behavior

Changes to be applied to Product with ID 35.

Environment

• Kendo UI version: 2018.3.1017
• Browser: all

[veselints]

The current implementation of the Spreadsheet data-binding relies on the indexes of the items in the widget. Therefore, altering their position (by applying some sort rule) will result in the observed, which is considered a not supported scenario.

That is why, I have converted the current issue from Bug to Enhancement suggestion to provide support for sorting when editing data-bound Spreadsheet Sheet.

[Dimitar-Goshev]

Currently Unsupported Scenario - Feedback item.