SpreadJS Documentation > Sample Code > Sample Code for Row Filtering > Getting the Row Filter Status |
You can get the status of the row filter.
This example gets the status of the row filter.
JavaScript |
Copy Code
|
---|---|
$(document).ready(function () { var spread = new GcSpread.Sheets.Spread($("#ss").get(0),{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 GcSpread.Sheets.HideRowFilter(new GcSpread.Sheets.Range(0, 0, 7, 1))); $("#button1").click(function(){ var rowFilter = $("#ss").data("spread").getActiveSheet().rowFilter(); if(rowFilter.isColumnFiltered(0)){ console.log("Row-filtering executed for Column1"); }else{ console.log("Row-filtering not executed for Column1"); } }); }); |