hasPendingChanges Method

Gets whether there is a dirty, insert, or delete status for the specified range.

Syntax

Javascript (Usage)
Javascript (Specification)

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.

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 () {
alert(activeSheet.hasPendingChanges());
   });

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

Reference

Worksheet type