Enum IconSetType

IconSetType enumeration

Icon set type for conditional formatting. The threshold values for triggering the different icons within a set are configurable, and the icon order is reversible.

public enum IconSetType

Values

NameValueDescription
Arrows303 arrows icon set.
ArrowsGray313 gray arrows icon set.
Flags323 flags icon set.
Signs333 signs icon set.
Symbols343 symbols icon set (circled).
Symbols3253 Symbols icon set (uncircled).
TrafficLights3163 traffic lights icon set (unrimmed).
TrafficLights3273 traffic lights icon set with thick black border.
Arrows484 arrows icon set.
ArrowsGray494 gray arrows icon set.
Rating4104 ratings icon set.
RedToBlack4114 ‘red to black’ icon set.
TrafficLights4124 traffic lights icon set.
Arrows5135 arrows icon set.
ArrowsGray5145 gray arrows icon set.
Quarters5155 quarters icon set.
Rating5165 rating icon set.
Stars3173 stars set
Boxes5185 boxes set
Triangles3193 triangles set
None20None
CustomSet21CustomSet. This element is read-only.
Smilies3223 smilies. Only for .ods.
ColorSmilies3233 color smilies. Only for .ods.

Examples

using System;
using Aspose.Cells;

namespace AsposeCellsExamples
{
    public class CellsClassIconSetTypeDemo
    {
        public static void Run()
        {
            Workbook wb = new Workbook();
            Worksheet sheet = wb.Worksheets[0];
            Cells cells = sheet.Cells;

            // Set sample values
            cells["A1"].PutValue(1);
            cells["A2"].PutValue("#DIV/0!");
            cells["A3"].PutValue(3);

            // Add conditional formatting with icon set
            ConditionalFormattingCollection cfs = sheet.ConditionalFormattings;
            FormatConditionCollection fcs = cfs[cfs.Add()];
            fcs.AddArea(CellArea.CreateCellArea(0, 0, 3, 0));
            
            FormatCondition fc = fcs[fcs.AddCondition(FormatConditionType.IconSet)];
            fc.IconSet.Type = IconSetType.TrafficLights31;

            // Get and display results
            ConditionalFormattingResult res1 = cells["A1"].GetConditionalFormattingResult();
            Console.WriteLine($"A1 Icon Type: {res1.ConditionalFormattingIcon.Type}, Index: {res1.ConditionalFormattingIcon.Index}");

            ConditionalFormattingResult res3 = cells["A3"].GetConditionalFormattingResult();
            Console.WriteLine($"A3 Icon Type: {res3.ConditionalFormattingIcon.Type}, Index: {res3.ConditionalFormattingIcon.Index}");

            ConditionalFormattingResult res2 = cells["A2"].GetConditionalFormattingResult();
            Console.WriteLine($"A2 has formatting: {res2 != null && res2.ConditionalFormattingIcon != null}");
        }
    }
}

See Also