CODEWITHSUNDEEP
kendo-uikendospreadsheet
Dobin
Dobin

Reputation: 87

How to trigger the change event of Kendo Jquery Spreadsheet when using custom Paste function?

I tried the below custom paste function to paste only values but it doesn't trigger the change event in order for me to sync the data to the data source.

Dojo Demo Link

...
change: onExcelChange,
paste: function(e) {
            e.preventDefault()

            var currentRange = e.range;
            var fullData = e.clipboardContent.data;
            var mergedCells = e.clipboardContent.mergedCells;
            var topLeft = currentRange.topLeft();
            var initialRow = topLeft.row;
            var initialCol = topLeft.col;
            var origRef = e.clipboardContent.origRef;
            var numberOfRows = origRef.bottomRight.row - origRef.topLeft.row + 1;
            var numberOfCols = origRef.bottomRight.col - origRef.topLeft.col + 1;
            var spread = e.sender;
            var sheet = spread.activeSheet();
            var rangeToPaste =  sheet.range(initialRow, initialCol, numberOfRows, numberOfCols);

            sheet.batch(function() {
                for(var i = 0; i < fullData.length; i += 1) {
                    var currentFullData = fullData[i];

                    for(var j = 0; j < currentFullData.length; j += 1 ) {
                        var range = sheet.range(initialRow + i, initialCol + j);
                        var value = currentFullData[j].value;

                        if (value !== null) {
                            range.input(value);
                            range.format(null);
                        }
                    }
                }
                 sheet.select(rangeToPaste);
            }, { layout: true, recalc: true });        
        } ...

I have tried to use recalc: true in sheet.batch to trigger the change to no avail. Any help would be greatly appreciated.

Upvotes: 0

Views: 1002

Answers (1)

GaloisGirl
GaloisGirl

Reputation: 1516

All Kendo widgets inherit from Observable, which has a trigger method:

var obj = new kendo.Observable();
obj.bind("myevent", function(e) {
    console.log(e.data); // outputs "data"
});
obj.trigger("myevent", { data: "data" });

You need to manually trigger the Spreadheet's change event with its correct parameters.

Upvotes: 1

Related Questions