Spread.Sheets Documentation
RangeFiltered Event
GC.Spread.Sheets Namespace > Events type : RangeFiltered Event
The sheet that triggered the event.
The sheet's name.
The index of the column that was automatically filtered.
The values by which the column was filtered.
The condition rule info which the column was filtered.
Occurs when a column has just been automatically filtered.
Syntax
var instance; // Type: Events
instance.RangeFiltered = function(sheet, sheetName, col, filterValues, conditionInfo) { };
RangeFiltered = function ( 
   sheet : Worksheet,
   sheetName : string,
   col : number,
   filterValues : Array,
   conditionInfo : Object
) { };

Parameters

sheet
The sheet that triggered the event.
sheetName
The sheet's name.
col
The index of the column that was automatically filtered.
filterValues
The values by which the column was filtered.
conditionInfo
The condition rule info which the column was filtered.
Example
This example uses the RangeFiltered event.
var cellrange =new GC.Spread.Sheets.Range(0, 2, 5, 1);
var hideRowFilter =new GC.Spread.Sheets.Filter.HideRowFilter(cellrange);
activeSheet.rowFilter(hideRowFilter);

activeSheet.bind(GC.Spread.Sheets.Events.RangeFiltered, function (e, info) {    
        alert("Col (" + info.col + ")");
});
See Also

Reference

Events type