Spread WinRT Documentation
GrapeCity.Xaml.SpreadSheet.Data Namespace / IconSetType Enumeration
Example Example


In This Topic
    IconSetType Enumeration
    In This Topic
    Specifies the icon set.
    Syntax
    'Declaration
     
    Public Enum IconSetType 
       Inherits System.Enum
    'Usage
     
    Dim instance As IconSetType
    public enum IconSetType : System.Enum 
    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.
    FourTrafficLightsSpecifies five traffic lights.
    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 uses the IconSetType enumeration.
    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; 
    
    GrapeCity.Xaml.SpreadSheet.Data.IconSetRule test = new GrapeCity.Xaml.SpreadSheet.Data.IconSetRule();
    test.IconSetType = GrapeCity.Xaml.SpreadSheet.Data.IconSetType.FourTrafficLights;
    test.ShowIconOnly = true;
    test.ReverseIconOrder = true;
    test.Ranges = new GrapeCity.Xaml.SpreadSheet.Data.CellRange[] { new GrapeCity.Xaml.SpreadSheet.Data.CellRange(0, 0, 5, 1) };
    gcSpreadSheet1.Sheets[0].ConditionalFormats.AddRule(test); 
    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
    
    Dim test As New GrapeCity.Xaml.SpreadSheet.Data.IconSetRule()       
    test.IconSetType = GrapeCity.Xaml.SpreadSheet.Data.IconSetType.FourTrafficLights
    test.ShowIconOnly = True
    test.ReverseIconOrder = True
    test.Ranges = New GrapeCity.Xaml.SpreadSheet.Data.CellRange() {New GrapeCity.Xaml.SpreadSheet.Data.CellRange(0, 0, 5, 1)}
    GcSpreadSheet1.Sheets(0).ConditionalFormats.AddRule(test)
    Inheritance Hierarchy

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

    See Also