Spread.Sheets 提供了筛选前和筛选后的接口，你可以自定义筛选器在筛选前和筛选后的行为。
如果要自定义筛选器的行为，你需要做如下事情：
- 从 RowFilterBase 派生一个类
- 重写 onFilter 方法，并处理筛选时候的事件。
如果要自定义取消筛选时的行为，你需要做以下事情：
- 从 RowFilterBase 派生一个类
- 重写 onFilter 方法，并处理 unfilter 事件。
你可以使用筛选器来改变筛选后行的颜色，如下图：
示例代码
以下代码扩展了 RowFilterBase 类，并且将 onFilter 方法重写了：
JavaScript
$(function () {
var spread = new GC.Spread.Sheets.Workbook($("#ss")[0]);
var activeSheet = spread.getActiveSheet();
spread.suspendPaint();
activeSheet.setColumnWidth(0, 100);
activeSheet.setColumnWidth(1, 200);
activeSheet.addSpan(0, 0, 1, 2);
activeSheet.getCell(0, 0).value("Students' Math Scores").hAlign(GC.Spread.Sheets.HorizontalAlign.center);
activeSheet.setValue(1, 0, "Name");
activeSheet.setValue(1, 1, "SCORE");
var score = [
{name: "Simon", score: 59},
{name: "Jack", score: 70},
{name: "Lily", score: 86},
{name: "Bob", score: 54},
{name: "Lucy", score: 84},
{name: "John", score: 99}
];
for (var i = 0, len = score.length; i < len; i++) {
var student = score[i];
activeSheet.setValue(i + 2, 0, student.name);
activeSheet.setValue(i + 2, 1, student.score);
}
var b1 = new GC.Spread.Sheets.CellTypes.Button();
b1.text("Filter Score < 60");
activeSheet.setCellType(8, 1, b1);
var b2 = new GC.Spread.Sheets.CellTypes.Button();
b2.text("Unfilter this column");
activeSheet.setCellType(9, 1, b2);
function HighLightFilter(range) {
GC.Spread.Sheets.Filter.RowFilterBase.call(this, range);
}
HighLightFilter.prototype = new GC.Spread.Sheets.Filter.RowFilterBase();
HighLightFilter.prototype.onFilter = function (args) {
if (!args) {
return;
}
var sheet = args.sheet, range = args.range, filterRows = args.filteredRows, filterActionType = args.action;
if (filterActionType === GC.Spread.Sheets.Filter.FilterActionType.Filter) {
if (range.col < 0) {
range.col = 0;
range.colCount = sheet.getColumnCount();
}
for (var i = 0, len = filterRows.length; i < len; i++) {
var r = filterRows[i];
for (var c = range.col, len1 = range.col + range.colCount; c < len1; c++) {
sheet.getCell(r, c).backColor("red");
}
}
sheet.setValue(9, 1, "Highlight the score less than 60");
} else if (filterActionType === GC.Spread.Sheets.Filter.FilterActionType.Unfilter) {
if (range.col < 0) {
range.col = 0;
range.colCount = sheet.getColumnCount();
}
for (var i = 0, len = filterRows.length; i < len; i++) {
var r = filterRows[i];
for (var c = range.col, len1 = range.col + range.colCount; c < len1; c++) {
sheet.getCell(r, c).backColor(undefined);
}
}
}
}
var hlf = new HighLightFilter(new GC.Spread.Sheets.Range(2, 1, 6, 1));
activeSheet.rowFilter(hlf);
var condition = new GC.Spread.Sheets.ConditionalFormatting.Condition(GC.Spread.Sheets.ConditionalFormatting.ConditionType.NumberCondition,
{
compareType: GC.Spread.Sheets.ConditionalFormatting.GeneralComparisonOperators.LessThan,
expected: 60
});
hlf.addFilterItem(1, condition);
hlf.filterButtonVisible(false);
spread.bind(GC.Spread.Sheets.Events.ButtonClicked, function (e, args) {
if (args.row === 8) {
if (args.col !== undefined) {
hlf.filter(args.col);
}
} else if (args.row === 9) {
if (args.col !== undefined) {
hlf.unfilter(args.col);
}
}
});
spread.resumePaint();
});