SpreadJS 13
GC.Spread.Sheets Namespace / Events type / RangeFilterClearing Event
The sheet that triggered the event.
The sheet's name.
The index of the sheet column to be automatically clear filter.
In This Topic
    RangeFilterClearing Event
    In This Topic
    Occurs when a range column is about to be automatically clear filter.
    Syntax
    var instance; // Type: Events
    instance.RangeFilterClearing = function(sheet, sheetName, col) { };
    RangeFilterClearing = function ( 
       sheet : Worksheet,
       sheetName : string,
       col : number
    ) { };

    Parameters

    sheet
    The sheet that triggered the event.
    sheetName
    The sheet's name.
    col
    The index of the sheet column to be automatically clear filter.
    Example
    //This example uses the RangeFilterClearing event.
    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");
    var cellRange =new GC.Spread.Sheets.Range(0, 0, 5, 1);
    var hideRowFilter =new GC.Spread.Sheets.Filter.HideRowFilter(cellRange);
    activeSheet.rowFilter(hideRowFilter);
    activeSheet.bind(GC.Spread.Sheets.Events.RangeFilterClearing, function (e, info) {
            alert("Col (" + info.col + ")");
    });
    See Also

    Reference

    Events type