Enumeration: IconSetType

Sheets.ConditionalFormatting.IconSetType

Specifies the icon set.

example

//This example creates a rule.
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

Enumeration members

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

Enumeration members

fiveArrowsColored

• fiveArrowsColored = 15

Specifies five colored arrows.

---

fiveArrowsGray

• fiveArrowsGray = 16

Specifies five gray arrows.

---

fiveBoxes

• fiveBoxes = 19

Specifies five boxes.

---

fiveQuarters

• fiveQuarters = 18

Specifies five quarters.

---

fiveRatings

• fiveRatings = 17

Specifies five ratings.

---

fourArrowsColored

• fourArrowsColored = 10

Specifies four colored arrows.

---

fourArrowsGray

• fourArrowsGray = 11

Specifies four gray arrows.

---

fourRatings

• fourRatings = 13

Specifies four ratings.

---

fourRedToBlack

• fourRedToBlack = 12

Specifies four red to black icons.

---

fourTrafficLights

• fourTrafficLights = 14

Specifies four traffic lights.

---

noIcons

• noIcons = 20

Specifies no cell icon.

---

threeArrowsColored

• threeArrowsColored = 0

Specifies three colored arrows.

---

threeArrowsGray

• threeArrowsGray = 1

Specifies three gray arrows.

---

threeFlags

• threeFlags = 4

Specifies three flags.

---

threeSigns

• threeSigns = 7

Specifies three signs.

---

threeStars

• threeStars = 3

Specifies three stars.

---

threeSymbolsCircled

• threeSymbolsCircled = 8

Specifies three symbols (circled).

---

threeSymbolsUncircled

• threeSymbolsUncircled = 9

Specifies three symbols (uncircled).

---

threeTrafficLightsRimmed

• threeTrafficLightsRimmed = 6

Specifies three traffic lights (rimmed).

---

threeTrafficLightsUnrimmed

• threeTrafficLightsUnrimmed = 5

Specifies three traffic lights (unrimmed).

---

threeTriangles

• threeTriangles = 2

Specifies three trangles.