Spread.Sheets Documentation
clearPendingChanges Method
GC.Spread.Sheets Namespace > Worksheet type : clearPendingChanges Method
Clears the dirty, insert, and delete status from the current worksheet.
Syntax
var instance = new GC.Spread.Sheets.Worksheet(name);
var value; // Type: any
value = instance.clearPendingChanges();
function clearPendingChanges() : any;
Example
This example clears the dirty cells.
var customers = [
               { ID: 0, Name: 'A', Info1: 'Info0' },
               { ID: 1, Name: 'B', Info1: 'Info1' },
               { ID: 2, Name: 'C', Info1: 'Info2' },
            ];
            activeSheet.autoGenerateColumns = true;
            activeSheet.setDataSource(customers);

$("#button1").click(function () {
activeSheet.clearPendingChanges();
   });

// Add button control to page
<input type="button" id="button1" value="button1"/>
See Also

Reference

Worksheet type