GrapeCity.Documents.Excel.IconSetType

IconSetType Enum

Specifies the built-in icon set types used in icon set conditional formatting rules.

Use this enumeration with this[IconSetType] to retrieve a predefined IIconSet from the workbook and apply it to an IIconSetCondition.

Namespace: GrapeCity.Documents.Excel

Assembly: DS.Documents.Excel.dll

Syntax

public enum IconSetType

Public Enum IconSetType

Examples

worksheet.Range["A1:A5"].Value = new object[] {10, 30, 50, 70, 90};
IIconSetCondition condition = worksheet.Range["A1:A5"].FormatConditions.AddIconSetCondition();
IIconSet iconSet = workbook.IconSets[IconSetType.Icon3Symbols];
condition.IconSet = iconSet;

Fields

Name	Description
CustomSet	Specifies custom icons.
Icon3Arrows	Specifies 3 arrows.
Icon3ArrowsGray	Specifies 3 gray arrows.
Icon3Flags	Specifies 3 flags.
Icon3Signs	Specifies the three-sign icon set used in icon set conditional formatting.
Icon3Stars	Specifies the 3 stars icon set used in an icon set conditional formatting rule.
Icon3Symbols	Specifies the three-symbol icon set with circled symbols.
Icon3Symbols2	Specifies 3 symbols.
Icon3TrafficLights1	Specifies 3 traffic lights.
Icon3TrafficLights2	Specifies the three traffic lights icon set with black rectangle borders.
Icon3Triangles	Specifies the three-triangle icon set for conditional formatting.
Icon4Arrows	Specifies the four-arrow icon set used in icon set conditional formatting.
Icon4ArrowsGray	Specifies 4 gray arrows.
Icon4CRV	Specifies 4 CRV icons.
Icon4RedToBlack	Specifies the four-icon red-to-black icon set used in icon set conditional formatting.
Icon4TrafficLights	Specifies the 4-traffic-light icon set for an icon set conditional formatting rule.
Icon5Arrows	Specifies the five-arrow icon set used in icon set conditional formatting.
Icon5ArrowsGray	Specifies the five gray arrow icon set used in icon set conditional formatting.
Icon5Boxes	Specifies the 5 boxes icon set.
Icon5CRV	Specifies the five-icon CRV icon set used in icon set conditional formatting.
Icon5Quarters	Specifies the 5-quarters icon set used in icon set conditional formatting. This icon set uses quarter-filled circular icons to represent five value levels.