Spread.Sheets Documentation
IconSetType Enumeration
GC.Spread.Sheets.ConditionalFormatting Namespace : IconSetType Enumeration
Specifies the icon set.
Members
MemberDescription
fiveArrowsColoredSpecifies five colored arrows.
fiveArrowsGraySpecifies five gray arrows.
fiveBoxesSpecifies five boxes.
fiveQuartersSpecifies five quarters.
fiveRatingsSpecifies five ratings.
fourArrowsColoredSpecifies four colored arrows.
fourArrowsGraySpecifies four gray arrows.
fourRatingsSpecifies four ratings.
fourRedToBlackSpecifies four red to black icons.
fourTrafficLightsSpecifies four traffic lights.
noIconsSpecifies no cell icon.
threeArrowsColoredSpecifies three colored arrows.
threeArrowsGraySpecifies three gray arrows.
threeFlagsSpecifies three flags.
threeSignsSpecifies three signs.
threeStarsSpecifies three stars.
threeSymbolsCircledSpecifies three symbols (circled).
threeSymbolsUncircledSpecifies three symbols (uncircled).
threeTrafficLightsRimmedSpecifies three traffic lights (rimmed).
threeTrafficLightsUnrimmedSpecifies three traffic lights (unrimmed).
threeTrianglesSpecifies three trangles.
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);
Inheritance Hierarchy

Object
   GC.Spread.Sheets.ConditionalFormatting.IconSetType

See Also

Reference

GC.Spread.Sheets.ConditionalFormatting Namespace