SpreadJS 13
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.
In This Topic
    TableFiltering Event
    In This Topic
    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