如果是要等于某个值才显示的话就用equalsTo,例如这个例子,我在B列设置了1、2、3,设置了筛选等于3,然后筛选后就只剩下3。如果仍未解决您的问题,建议您将您的demo上传,这边调研一下。sheet.setValue(0,1,1);
sheet.setValue(1,1,2);
sheet.setValue(2,1,3);
var range = new GC.Spread.Sheets.Range(-1, 1, -1, 1);
sheet.rowFilter(new GC.Spread.Sheets.Filter.HideRowFilter(range));
var compareType = GC.Spread.Sheets.ConditionalFormatting.TextCompareType.equalsTo;
var condition = new GC.Spread.Sheets.ConditionalFormatting.Condition(GC.Spread.Sheets.ConditionalFormatting.ConditionType.textCondition, {compareType: compareType, expected: '3'});
var rowfilter = sheet.rowFilter();
rowfilter.addFilterItem(1, condition);
rowfilter.filter(1);
|