Hi,
I encountered a bug when using the spreadsheet control with a remote datasource which I was able to replicate using the datasource binding demo (https://demos.telerik.com/kendo-ui/spreadsheet/datasource).
When entering data on an empty cell in an empty row not adjacent to a non-empty row (e.g. a row that is two rows below the end of the data); then editing a cell in the same row, but adjacent column, this creates two items in the corresponding datasource.
Editing an empty row above this new row will modify one of the records created in this process.
Hello,
We are aware of the following Spreadsheet bug which reproduces similar issue to the one you report:
https://github.com/telerik/kendo-ui-core/issues/4044
I've performed the following steps in order to replicate the issue you are describing:
1. Open this demo https://demos.telerik.com/kendo-ui/spreadsheet/datasource
2. Enter "Test" in B81
3. Enter 10 in C81
4. Save the changes
5. Edit B82 and save
Result: B81 is also changed unexpectedly
Could you please confirm that this is the problematic scenario that you've stumbled upon or if not, send us the reproduction steps?
Thank you for your feedback and collaboration.
Best Regards,
Misho
Progress Telerik