SpreadJS 13
GC.Spread.Sheets Namespace / Events type / TableFilterCleared Event
The sheet that triggered the event.
The sheet's name.
The table column to be automatically filtered.
The index of the table column has just been clear filter.
In This Topic
    TableFilterCleared Event
    In This Topic
    Occurs when a table column has just been clear filter.
    Syntax
    var instance; // Type: Events
    instance.TableFilterCleared = function(sheet, sheetName, table, tableCol) { };
    TableFilterCleared = function ( 
       sheet : Worksheet,
       sheetName : string,
       table : Table,
       tableCol : number
    ) { };

    Parameters

    sheet
    The sheet that triggered the event.
    sheetName
    The sheet's name.
    table
    The table column to be automatically filtered.
    tableCol
    The index of the table column has just been clear filter.
    Example
    //This example uses the TableFilterCleared 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.TableFilterCleared, function (e, info) {
           alert("Sheet (" + info.sheetName + ")");
    });
    See Also

    Reference

    Events type