[]
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);
• fiveArrowsColored = 15
Specifies five colored arrows.
• fiveArrowsGray = 16
Specifies five gray arrows.
• fiveBoxes = 19
Specifies five boxes.
• fiveQuarters = 18
Specifies five quarters.
• fiveRatings = 17
Specifies five ratings.
• fourArrowsColored = 10
Specifies four colored arrows.
• fourArrowsGray = 11
Specifies four gray arrows.
• fourRatings = 13
Specifies four ratings.
• fourRedToBlack = 12
Specifies four red to black icons.
• fourTrafficLights = 14
Specifies four traffic lights.
• noIcons = 20
Specifies no cell icon.
• threeArrowsColored = 0
Specifies three colored arrows.
• threeArrowsGray = 1
Specifies three gray arrows.
• threeFlags = 4
Specifies three flags.
• threeSigns = 7
Specifies three signs.
• threeStars = 3
Specifies three stars.
• threeSymbolsCircled = 8
Specifies three symbols (circled).
• threeSymbolsUncircled = 9
Specifies three symbols (uncircled).
• threeTrafficLightsRimmed = 6
Specifies three traffic lights (rimmed).
• threeTrafficLightsUnrimmed = 5
Specifies three traffic lights (unrimmed).
• threeTriangles = 2
Specifies three trangles.