This is a migrated thread and some comments may be shown as answers.

Copy & Paste multiple column at once, Change event only trigger the first column

3 Answers 244 Views

Spreadsheet

This is a migrated thread and some comments may be shown as answers.

Su Pei asked on 03 Mar 2017, 02:42 AM

Hi,

My spreadsheet might have hundred of records, but I'm intend to detect the changes row each time user click on save button.

I found that when user copy from external excel and paste to kendo spreadsheet, change event only trigger the first value changed.

Below are the code that I tried:

change: function (e) {
var row = e.range._ref.topLeft.row - 1;
if (rowIndexChanged.indexOf(row + "|") >= 0)
return;

rowIndexChanged += row.toString() + "|";
}

Is there any other simpler way to get the changes of row's index from spreadsheet?

Thank you!

Regards,

Su Pei

Copy & Paste multiple column at once, Change event only trigger the first column

3 Answers, 1 is accepted