枚举: IconSetType

Sheets.ConditionalFormatting.IconSetType

图标集

代码示例

//本示例创建一个规则
activeSheet.setValue(0,0,1,3);
activeSheet.setValue(1,0,15,3);
activeSheet.setValue(2,0,25,3);
activeSheet.setValue(3,0,-1,3);
var iconSetRule = new GC.Spread.Sheets.ConditionalFormatting.IconSetRule();
iconSetRule.ranges([new GC.Spread.Sheets.Range(0,0,4,1)]);
iconSetRule.iconSetType(GC.Spread.Sheets.ConditionalFormatting.IconSetType.fourTrafficLights);
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, 10);
iconCriteria[2] = new GC.Spread.Sheets.ConditionalFormatting.IconCriterion(true, GC.Spread.Sheets.ConditionalFormatting.IconValueType.number, 20);
iconSetRule.reverseIconOrder(false);
iconSetRule.showIconOnly(false);
activeSheet.conditionalFormats.addRule(iconSetRule);

Table of contents

枚举值成员

• fiveArrowsColored
• fiveArrowsGray
• fiveBoxes
• fiveQuarters
• fiveRatings
• fourArrowsColored
• fourArrowsGray
• fourRatings
• fourRedToBlack
• fourTrafficLights
• noIcons
• threeArrowsColored
• threeArrowsGray
• threeFlags
• threeSigns
• threeStars
• threeSymbolsCircled
• threeSymbolsUncircled
• threeTrafficLightsRimmed
• threeTrafficLightsUnrimmed
• threeTriangles

枚举值成员

fiveArrowsColored

• fiveArrowsColored = 15

五个彩色箭头

---

fiveArrowsGray

• fiveArrowsGray = 16

五个灰色箭头

---

fiveBoxes

• fiveBoxes = 19

五个框

---

fiveQuarters

• fiveQuarters = 18

五个四等分

---

fiveRatings

• fiveRatings = 17

五个等级

---

fourArrowsColored

• fourArrowsColored = 10

四个彩色箭头

---

fourArrowsGray

• fourArrowsGray = 11

四个灰色箭头

---

fourRatings

• fourRatings = 13

四个等级

---

fourRedToBlack

• fourRedToBlack = 12

四个红色到黑色的图标

---

fourTrafficLights

• fourTrafficLights = 14

四个交通信号灯

---

noIcons

• noIcons = 20

不任何单元格图标

---

threeArrowsColored

• threeArrowsColored = 0

三个彩色箭头

---

threeArrowsGray

• threeArrowsGray = 1

三个灰色箭头

---

threeFlags

• threeFlags = 4

三个旗子

---

threeSigns

• threeSigns = 7

三个标志

---

threeStars

• threeStars = 3

三颗星星

---

threeSymbolsCircled

• threeSymbolsCircled = 8

三个符号(带圆圈)

---

threeSymbolsUncircled

• threeSymbolsUncircled = 9

三个符号(无圆圈)

---

threeTrafficLightsRimmed

• threeTrafficLightsRimmed = 6

三个交通信号灯(有边框)

---

threeTrafficLightsUnrimmed

• threeTrafficLightsUnrimmed = 5

三个交通信号灯(无边框)

---

threeTriangles

• threeTriangles = 2

三个三角形