Spread.Sheets Documentation
getDeletedRows Method
GC.Spread.Sheets Namespace > Worksheet type : getDeletedRows Method
Gets the deleted row collection.
Syntax
var instance = new GC.Spread.Sheets.Worksheet(name);
var value; // Type: Array
value = instance.getDeletedRows();
function getDeletedRows() : Array;

Return Value

Deleted row.

The following values can be obtained.

row.row number Specifies the index of the deleted row
row.originalItem object Specifies the data item of the deleted row

 

Example
This example gets the deleted rows.
activeSheet.setValue(0, 0, "The 1st row", GC.Spread.Sheets.SheetArea.viewport);
activeSheet.setValue(1, 0, "The 2st row", GC.Spread.Sheets.SheetArea.viewport);
activeSheet.setValue(2, 0, "The 3st row", GC.Spread.Sheets.SheetArea.viewport);
activeSheet.deleteRows(1, 1);

$("#button1").click(function () {

 var deleteRows = activeSheet.getDeletedRows();
            var len = deleteRows.length;
            for (i = 0 ; i < len; i++) {
                var d = deleteRows[i];
             alert("rowIndex:" + d.row);       
}        
   });

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

Reference

Worksheet type