how to perform insert and delete operation after binding to a dataSource. I tried to solve in different ways but all ends in some issue.
Create a dojo snippet to reproduce issue.
1. After applying formula to a column data sheet.range("F2:F").formula("C2*D2"); try to add a row
Getting error - kendo.all.js:98306 Uncaught Error: Shifting nonblank cells off the worksheet is not supported!
2. Change formula to sheet.range("F2:F14").formula("C2*D2"); leaving one final row. Can insert one record.
Is there any way to apply formula to all cells in column without affecting the add functionality.
3. " dataSource.cancelChanges()" will copies the below row to current row.