本帖最后由 spreadjs666 于 2023-10-26 19:44 编辑
使用以下代码进行筛选 var condition1 = new GC.Spread.Sheets.ConditionalFormatting.Condition(GC.Spread.Sheets.ConditionalFormatting.ConditionType.textCondition, {
compareType: GC.Spread.Sheets.ConditionalFormatting.GeneralComparisonOperators.equalsTo,
expected: '社区1'}); var condition2 = new GC.Spread.Sheets.ConditionalFormatting.Condition(GC.Spread.Sheets.ConditionalFormatting.ConditionType.textCondition, {
compareType: GC.Spread.Sheets.ConditionalFormatting.GeneralComparisonOperators.equalsTo,
expected: '社区2'}); ... var conditionn = new GC.Spread.Sheets.ConditionalFormatting.Condition(GC.Spread.Sheets.ConditionalFormatting.ConditionType.textCondition, {
compareType: GC.Spread.Sheets.ConditionalFormatting.GeneralComparisonOperators.equalsTo,
expected: '社区n'}); filter.addFilterItem(col, condition1);
filter.addFilterItem(col, condition2);
...
filter.addFilterItem(col, conditionn);
filter.filter() 如何单独去除社区n这一项的筛选条件,重新进行筛选? |
|