Spread WPF Documentation
AddIconSetRule Method
Example 


GrapeCity.Windows.SpreadSheet.Data Namespace > ConditionalFormat Class : AddIconSetRule Method
The type of IconSetType icon collection.
The cell ranges where the rule is applied.
Adds an icon set rule to the rule collection.
Syntax
'Declaration
 
Public Function AddIconSetRule( _
   ByVal iconSetTye As IconSetType, _
   ByVal ParamArray ranges() As CellRange _
) As IconSetRule
'Usage
 
Dim instance As ConditionalFormat
Dim iconSetTye As IconSetType
Dim ranges() As CellRange
Dim value As IconSetRule
 
value = instance.AddIconSetRule(iconSetTye, ranges)
public IconSetRule AddIconSetRule( 
   IconSetType iconSetTye,
   params CellRange[] ranges
)

Parameters

iconSetTye
The type of IconSetType icon collection.
ranges
The cell ranges where the rule is applied.

Return Value

Returns the new icon set rule.
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;   
GcSpreadSheet1.Sheets[0].ConditionalFormats.AddIconSetRule(GrapeCity.Windows.SpreadSheet.Data.IconSetType.FourTrafficLights, new GrapeCity.Windows.SpreadSheet.Data.CellRange[] { new GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 5, 1) });
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
GcSpreadSheet1.Sheets(0).ConditionalFormats.AddIconSetRule(GrapeCity.Windows.SpreadSheet.Data.IconSetType.FourTrafficLights, New GrapeCity.Windows.SpreadSheet.Data.CellRange() { New GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 5, 1) })
See Also

Reference

ConditionalFormat Class
ConditionalFormat Members