TableFiltering Event

Occurs when a table column is about to be automatically filtered.

Syntax

Javascript (Usage)
Javascript (Specification)

var instance; // Type: Events
instance.TableFiltering = function(sheet, sheetName, table, col, filterValues) { };

TableFiltering = function ( 
   sheet : Sheet,
   sheetName : string,
   table : SheetTable,
   col : number,
   filterValues : Array
) { };

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.

Example

This example uses the TableFiltering event.

Javascript

activeSheet.addTable("Table1", 0, 0, 3, 3, GcSpread.Sheets.TableStyles.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");

$("#spreadContainer").data("spread").getActiveSheet().bind(GcSpread.Sheets.Events.TableFiltering, function (e, info) {    
        alert("Sheet (" + info.sheetName + ")");
});

Reference

Events type