SpreadJS 13
GC.Spread.Sheets.Filter Namespace / RowFilterBase type / isFiltered Method
The column index.
In This Topic
    isFiltered Method
    In This Topic
    Gets a value that indicates whether any row or specified column is filtered.
    var instance = new GC.Spread.Sheets.Filter.RowFilterBase(range);
    var value; // Type: boolean
    value = instance.isFiltered(col);
    function isFiltered( 
       col : number
    ) : boolean;


    The column index.

    Return Value

    No parameter true if some rows are filtered; otherwise, false. One parameter col true if the specified column is filtered; otherwise, false.
    This example uses the isColumnFiltered method.
    activeSheet.setValue(0, 0, "North");
    activeSheet.setValue(1, 0, "South");
    activeSheet.setValue(2, 0, "East");
    activeSheet.setValue(3, 0, "South");
    activeSheet.setValue(4, 0, "North");
    activeSheet.setValue(5, 0, "North");
    activeSheet.setValue(6, 0, "West");
    activeSheet.setColumnWidth(0, 80);
    //Set a row filter.
    activeSheet.rowFilter(new GC.Spread.Sheets.Filter.HideRowFilter(new GC.Spread.Sheets.Range(0, 0, 7, 1)));
    $("#button1").click(function () {
        var rowFilter = spread.getActiveSheet().rowFilter();
        if (rowFilter.isFiltered(0)) {
            alert("Row-filtering executed for Column1");
        } else {
            alert("Row-filtering not executed for Column1");
    //Add button control to page
    <input type="button" id="button1" value="button1"/>
    See Also