Page History

You can hide filtered rows. A filter button is displayed in the column header for a column that allows filtering. The user can click on the button and select the item they wish to filter by and they can sort the list of items.
Image Removed
The user can use the mouse or various keyboard keys to interact with the filter dialog. The Esc key can be used to cancel the dialog. The Tab key can be used to move to different sections and the up and down arrow keys can be used to move in the list of items. The Spacebar can be used to change the checked status.
Image Removed
You can create a filter in code with the rowFilter HideRowFilter class. You can hide the filter icon with the filterButtonVisible method.
Using Code
This example creates a filter.你可以隐藏不符合条件的行。筛选按钮将会显示在可被筛选列的列标题上。用户可以点击按钮并自定义筛选器和排序规则。

Image Added

用户可以使用鼠标和键盘快捷键来操作筛选对话框。

Esc 键与点击 “Cancel” 按钮的行为一致。

Tab 键可用于在筛选对话框中的不同区域之间来回移动。

上键和下键用于在列表中上移和下移。

空格键用于勾选和取消勾选选中行。

Image Added

你可以使用 rowFilter 方法来给工作表创建一个筛选器。

你可以使用 filterButtonVisible 来隐藏筛选器按钮。

示例代码
以下代码创建了一个筛选器：

JavaScript	Copy Code
var cellrange =new GC.Spread.Sheets.Range(0, 2, 5, 1);var hideRowFilter =new GC.Spread.Sheets.Filter.HideRowFilter(cellrange);activeSheet.rowFilter(hideRowFilter);//activeSheet.rowFilter(new GC.Spread.Sheets.Filter.HideRowFilter(new GC.Spread.Sheets.Range(0,0,4,4)));

Using Code
This example filters rows using code.示例代码
下列使用代码创建了一个筛选器规则。

JavaScript	Copy Code
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="5abe5659-0a55-471a-ab57-66fccd9390b2"><ac:plain-text-body><![CDATA[	$(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". 来过滤 Column1。 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 删除 Column1 的筛选条件 var rowFilter = $("#ss").data("workbook").getActiveSheet().rowFilter(); if(rowFilter){ rowFilter.removeFilterItems(0); rowFilter.filter(); } }); ]]></ac:plain-text-body></ac:structured-macro> });//Add button controls to page<input 给页面添加一个按钮<input type="button" id="button1" value="button1"/><input type="button" id="button2" value="button2"/>

Using Code
The following code creates a custom filter.示例代码
以下代码创建了一个自定义筛选器

JavaScript

Copy Code

//Create a custom condition.        创建一个自定义条件        function CustomFilter(){            GC.Spread.Sheets.ConditionalFormatting.Condition.apply(this, arguments);             //this.conditionType("CustomFilter");        };        CustomFilter.prototype = new GC.Spread.Sheets.ConditionalFormatting.Condition();        CustomFilter.prototype.evaluate = function (evaluator, row, col) {            var value = evaluator.getValue(row, col);
            if (value !== null && value >= 10 && value <= 50) {                //Return True only when the following conditions are satisfied当以下条件满足时才会返回 True.                // (1)Values are entered单元格中有值.                // (2)Values are not lower than 10单元格中的值小于等于10.                // (3)Values are not greater than 单元格中的值不大于 50.                return true;            } else {                return false;            }        };
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="3fe733f7-ae26-4d07-aca1-ed692904c471"><ac:plain-text-body><![CDATA[        $(function () {            var workbook = new GC.Spread.Sheets.Workbook($("#ss")[0]);            var activeSheet = workbook.getActiveSheet();            activeSheet.setValue(0, 0, 10);            activeSheet.setValue(1, 0, 100);            activeSheet.setValue(2, 0, 50);            activeSheet.setValue(3, 0, 40);            activeSheet.setValue(4, 0, 80);            activeSheet.setValue(5, 0, 1);            activeSheet.setValue(6, 0, 65);            activeSheet.setValue(7, 0, 20);            activeSheet.setValue(8, 0, 30);            activeSheet.setValue(9, 0, 35);
]]></ac:plain-text-body></ac:structured-macro>
            $("#button1").click(function(){                //Set a row Filter设置一个行筛选器.                var rowFilter = new GC.Spread.Sheets.Filter.HideRowFilter(new GC.Spread.Sheets.Range(0, 0, 7, 1));                activeSheet.rowFilter(rowFilter);                rowFilter.addFilterItem(0, new CustomFilter());                rowFilter.filter(0);            });        });
// Add a button at the bottom of the page<input 在页面的底部添加一个按钮<input id="button1" type="button" value="Button1"/>

See Also更多信息
HideRowFilter class

Page tree

Versions Compared

Old Version 1

New Version 2

Key