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

Parameters

sheet
The sheet that triggered the event.
sheetName
The sheet's name.
table
The table column to be automatically filtered.
col
The index of the table column to be automatically filtered.
filterValues
The values by which to filter the column.
conditionInfo
The condition rule info by which to filter the column.
Example
This example uses the TableFiltering event.
activeSheet.tables.add("Table1", 0, 0, 3, 3, GC.Spread.Sheets.Tables.TableTheme.dark1);
activeSheet.getCell(0,0).text("Name");
activeSheet.getCell(0,1).text("Value");
activeSheet.getCell(0,2).text("T/F");
activeSheet.getCell(1,0).text("AW");
activeSheet.getCell(1,1).text("5");
activeSheet.getCell(1,2).text("T");

activeSheet.bind(GC.Spread.Sheets.Events.TableFiltering, function (e, info) {    
        alert("Sheet (" + info.sheetName + ")");
});
See Also

Reference

Events type