GrapeCity.Xaml.SpreadSheet.Data
IconSetType Enumeration
Example Example 


Specifies the icon set.
Syntax
'Declaration
 
Public Enum IconSetType 
   Inherits System.Enum
'Usage
 
Dim instance As IconSetType
public enum IconSetType : System.Enum 
Members
MemberDescription
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 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

Requirements

Target Platforms: Windows Server 2012, Windows RT

See Also

Reference

GrapeCity.Xaml.SpreadSheet.Data Namespace

 

 


Copyright © GrapeCity, inc. All rights reserved.

Support Options