[]
        
(Showing Draft Content)

GC.Spread.Sheets.ConditionalFormatting.IconSetType

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

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.