按照你的需求,实际上是文本匹配,你参考demo中的第一个匹配方式Text Condition就行,下面这个代码可以写在你的input的change事件中,expected的值可以完全匹配你的input.value或者通过*号模糊匹配
- var sheet = spread.getActiveSheet();
- var filter = sheet.rowFilter();
- if (filter) {
- filter.removeFilterItems(1);
- if (this.checked) {
- var condition = new spreadNS.ConditionalFormatting.Condition(spreadNS.ConditionalFormatting.ConditionType.textCondition, {
- compareType: spreadNS.ConditionalFormatting.TextCompareType.contains,
- expected: "*e*"
- });
- filter.addFilterItem(1, condition);
- }
- filter.filter(1);
- sheet.invalidateLayout();
- sheet.repaint();
- }
复制代码 |