SpreadJS 13
GC.Spread.Sheets Namespace / Events type / RangeFiltered Event
The sheet that triggered the event.
The sheet's name.
The index of the column that was automatically filtered.
The values by which the column was filtered.
The condition rule info that which the column was filtered.
In This Topic
    RangeFiltered Event
    In This Topic
    Occurs when a column has just been automatically filtered.
    Syntax
    var instance; // Type: Events
    instance.RangeFiltered = function(sheet, sheetName, col, filterValues, conditionInfo) { };
    RangeFiltered = function ( 
       sheet : Worksheet,
       sheetName : string,
       col : number,
       filterValues : Array,
       conditionInfo : Array
    ) { };

    Parameters

    sheet
    The sheet that triggered the event.
    sheetName
    The sheet's name.
    col
    The index of the column that was automatically filtered.
    filterValues
    The values by which the column was filtered.
    conditionInfo
    The condition rule info that which the column was filtered.
    Example
    This example uses the RangeFiltered event.
    var cellrange =new GC.Spread.Sheets.Range(0, 2, 5, 1);
    var hideRowFilter =new GC.Spread.Sheets.Filter.HideRowFilter(cellrange);
    activeSheet.rowFilter(hideRowFilter);
    
    activeSheet.bind(GC.Spread.Sheets.Events.RangeFiltered, function (e, info) {    
            alert("Col (" + info.col + ")");
    });
    See Also

    Reference

    Events type