IconSetType Enumeration

Specifies the icon set.

Members

Member	Description
fiveArrowsColored	Specifies five colored arrows.
fiveArrowsGray	Specifies five gray arrows.
fiveBoxes	Specifies five boxes.
fiveQuarters	Specifies five quarters.
fiveRatings	Specifies five ratings.
fourArrowsColored	Specifies four colored arrows.
fourArrowsGray	Specifies four gray arrows.
fourRatings	Specifies four ratings.
fourRedToBlack	Specifies four red to black icons.
fourTrafficLights	Specifies four traffic lights.
noIcons	Specifies no cell icon.
threeArrowsColored	Specifies three colored arrows.
threeArrowsGray	Specifies three gray arrows.
threeFlags	Specifies three flags.
threeSigns	Specifies three signs.
threeStars	Specifies three stars.
threeSymbolsCircled	Specifies three symbols (circled).
threeSymbolsUncircled	Specifies three symbols (uncircled).
threeTrafficLightsRimmed	Specifies three traffic lights (rimmed).
threeTrafficLightsUnrimmed	Specifies three traffic lights (unrimmed).
threeTriangles	Specifies three trangles.

Example

This example creates a rule.

Javascript

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);

Inheritance Hierarchy

Object
GC.Spread.Sheets.ConditionalFormatting.IconSetType

Reference

GC.Spread.Sheets.ConditionalFormatting Namespace