IconSetType Enumeration

Specifies the icon set.

Syntax

Visual Basic
C#

'Declaration
 
Public Enum IconSetType 
   Inherits System.Enum

'Usage
 
Dim instance As IconSetType

public enum IconSetType : System.Enum

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.
FourTrafficLights	Specifies five traffic lights.
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 an icon set rule.

gcSpreadSheet1.Sheets[0].Cells[0, 0].Value = 1;
gcSpreadSheet1.Sheets[0].Cells[1, 0].Value = 10;
gcSpreadSheet1.Sheets[0].Cells[2, 0].Value = 6;
gcSpreadSheet1.Sheets[0].Cells[3, 0].Value = 3;            
        }

        private void button1_Click(object sender, RoutedEventArgs e)
        {
            GrapeCity.Windows.SpreadSheet.Data.IconSetRule test = new GrapeCity.Windows.SpreadSheet.Data.IconSetRule();
            test.IconSetType = GrapeCity.Windows.SpreadSheet.Data.IconSetType.FourTrafficLights;
            test.Ranges = new GrapeCity.Windows.SpreadSheet.Data.CellRange[] { new GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 5, 1) };
            gcSpreadSheet1.Sheets[0].ConditionalFormats.AddRule(test);             
        }

VB.NET

GcSpreadSheet1.Sheets(0).Cells(0, 0).Value = 1
GcSpreadSheet1.Sheets(0).Cells(1, 0).Value = 10
GcSpreadSheet1.Sheets(0).Cells(2, 0).Value = 6
GcSpreadSheet1.Sheets(0).Cells(3, 0).Value = 3

    Private Sub Button1_Click(sender As System.Object, e As System.Windows.RoutedEventArgs) Handles Button1.Click
        Dim test As New GrapeCity.Windows.SpreadSheet.Data.IconSetRule()       
        test.IconSetType = GrapeCity.Windows.SpreadSheet.Data.IconSetType.FourTrafficLights
        test.Ranges = New GrapeCity.Windows.SpreadSheet.Data.CellRange() {New GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 5, 1)}
        GcSpreadSheet1.Sheets(0).ConditionalFormats.AddRule(test)
    End Sub

Inheritance Hierarchy

System.Object
   System.ValueType
      System.Enum
         GrapeCity.Windows.SpreadSheet.Data.IconSetType

Requirements

Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

Reference

GrapeCity.Windows.SpreadSheet.Data Namespace