图标集范围内应用比较逻辑是什么呢,我理解是针对单个单元格独立的规则

Clark.Pan

但现象附件中有些奇怪, 麻烦老师解答一下

let activeSheet = spread.getActiveSheet()
         activeSheet.setValue(0, 0, 1);
         activeSheet.setValue(1, 0, 15);
         activeSheet.setValue(2, 0, 25);
         activeSheet.setValue(3, 0, -1);
         var iconSetRule = new GC.Spread.Sheets.ConditionalFormatting.IconSetRule();

         iconSetRule.ranges([new GC.Spread.Sheets.Range(0, 0, 10, 1)]);
         iconSetRule.iconSetType(GC.Spread.Sheets.ConditionalFormatting.IconSetType.fiveArrowsColored);
         var icons = iconSetRule.icons();
         // icons[0] = { iconSetType: GC.Spread.Sheets.ConditionalFormatting.IconSetType.fiveArrowsColored, iconIndex: 4 };
         // icons[1] = { iconSetType: GC.Spread.Sheets.ConditionalFormatting.IconSetType.fiveArrowsColored, iconIndex: 4 };
         // icons[2] = { iconSetType: GC.Spread.Sheets.ConditionalFormatting.IconSetType.fiveArrowsColored, iconIndex: 3 };

         var iconCriteria = iconSetRule.iconCriteria();
         iconCriteria[0] = new GC.Spread.Sheets.ConditionalFormatting.IconCriterion(true, GC.Spread.Sheets.ConditionalFormatting.IconValueType.number, 1);
         iconCriteria[1] = new GC.Spread.Sheets.ConditionalFormatting.IconCriterion(true, GC.Spread.Sheets.ConditionalFormatting.IconValueType.number, 3);
         iconCriteria[2] = new GC.Spread.Sheets.ConditionalFormatting.IconCriterion(true, GC.Spread.Sheets.ConditionalFormatting.IconValueType.number, 5);
         iconSetRule.reverseIconOrder(false);
         iconSetRule.showIconOnly(false);
         activeSheet.conditionalFormats.addRule(iconSetRule);