条件过滤，多条件拼接

收藏

本帖最后由 zhanglibin 于 2021-10-11 14:49 编辑

怎么拼接大与2个条件；
var condtionbase = new spreadNS.ConditionalFormatting.Condition(spreadNS.ConditionalFormatting.ConditionType.textCondition, {
      compareType: 0,//0:等于
      expected: '3',
});
var condtionbase1 = new spreadNS.ConditionalFormatting.Condition(spreadNS.ConditionalFormatting.ConditionType.textCondition, {
      compareType: 0,//0:等于
      expected: '2',
});
var condtionbase2 = new spreadNS.ConditionalFormatting.Condition(spreadNS.ConditionalFormatting.ConditionType.textCondition, {
      compareType: 0,//0:等于
      expected: '1',
});
var conditions = new spreadNS.ConditionalFormatting.Condition(spreadNS.ConditionalFormatting.ConditionType.relationCondition, {
      compareType: spreadNS.ConditionalFormatting.LogicalOperators.or,
      item1: condtionbase,
      item2: condtionbase1,
      item3: condtionbase2
});
测试结果，发现or条件拼接不支持第三个条件item3，请问有解决方案吗？
最终想实现的效果就是自定义过滤；
如图：
image.png269887084.png