SpreadJS 13
SpreadJS Documentation / Sample Code / Sample Code for Row Filtering / Filtering a Row with Code
In This Topic
    Filtering a Row with Code
    In This Topic

    You can filter a row using code.

    Using Code

    This example filters a row with code.

    JavaScript
    Copy Code
    $(function ()
    {
       var workbook = new GC.Spread.Sheets.Workbook($("#ss")[0]);
       var activeSheet = workbook.getActiveSheet();
       activeSheet.setRowCount(7);
       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);
       activeSheet.rowFilter(new GC.Spread.Sheets.Filter.HideRowFilter
       (new GC.Spread.Sheets.Range(0, 0, 7, 1)));
       
        $("#button1").click(function()
         {
           // Filter Column1 by "North".
           var rowFilter = $("#ss").data("workbook").getActiveSheet().rowFilter();
           var condition = new GC.Spread.Sheets.
           ConditionalFormatting.Condition(GC.Spread.Sheets.
           ConditionalFormatting.ConditionType.textCondition,           
           {
             compareType: GC.Spread.Sheets.ConditionalFormatting.TextCompareType.equalsTo,
             expected: "North"
           });
    
            rowFilter.addFilterItem(0, condition);
            rowFilter.filter(0);
    
        });
                
       $("#button2").click(function()
          {
           // Remove filtering for Column1
           var rowFilter = $("#ss").data("workbook").getActiveSheet().rowFilter();
           if(rowFilter)
             {
               rowFilter.removeFilterItems(0);
               rowFilter.filter();
             }
          });
    });
    
    // Add button controls to page
    <input type="button" id="button1" value="button1"/>
    <input type="button" id="button2" value="button2"/>
    
    See Also

    Developer's Guide