SpreadJS 13
SpreadJS Documentation / Sample Code / Sample Code for Row Filtering / Getting the Row Filter Status
In This Topic
    Getting the Row Filter Status
    In This Topic

    You can get the status of the row filter.

    Using Code

    This example gets the status of the row filter.

    JavaScript
    Copy Code
    $(document).ready(function ()
    {
        var spread =
        new GC.Spread.Sheets.Workbook(document.getElementById("ss"),
        {sheetCount:3});
        var activeSheet = spread.getActiveSheet();
        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 rowFilter.
        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))
            {
                console.log("Row-filtering executed for Column1");
            }
           else
            {
                console.log("Row-filtering not executed for Column1");
            }
        });
    });
    
    See Also

    Developer's Guide