Spread.Sheets Documentation
hasPendingChanges Method
Gets whether there is a dirty, insert, or delete status for the specified range.
Syntax
var instance = new GC.Spread.Sheets.Worksheet(name);
var value; // Type: boolean
value = instance.hasPendingChanges();
function hasPendingChanges() : boolean;

Return Value

true if any of the rows or cells in the range are dirty, or have been inserted or deleted; otherwise, false.
Example
This example checks for 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 () {
alert(activeSheet.hasPendingChanges());
   });

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

Reference

Worksheet type

 

 


Copyright © GrapeCity, inc. All rights reserved.

Send comments on this topic.