clearPendingChanges Method

Clears the dirty, insert, and delete status from the current worksheet.

Syntax

Javascript (Usage)
Javascript (Specification)

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.

Javascript

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"/>

Reference

Worksheet type

Product Support Forum | Print this page