SpreadJS 13
SpreadJS Documentation / Sample Code / Sample Code for Row Filtering / Creating Row Filters
In This Topic
    Creating Row Filters
    In This Topic

    You can filter rows by selecting the row filter icon.

    Row filters

    Using Code

    This example creates a 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 row Filter
        activeSheet.rowFilter(new GC.Spread.Sheets.Filter.HideRowFilter
        (new GC.Spread.Sheets.Range(-1, 0, -1, 1)));
    });
    
    See Also

    Developer's Guide