Spread WinRT Documentation
GrapeCity.Xaml.SpreadSheet.Data Namespace / ConditionalFormat Class / AddIconSetRule Method
The type of IconSetType icon collection.
The cell ranges where the rule is applied.
Example


In This Topic
    AddIconSetRule Method
    In This Topic
    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.Xaml.SpreadSheet.Data.IconSetType.FourTrafficLights, new GrapeCity.Xaml.SpreadSheet.Data.CellRange[] { new GrapeCity.Xaml.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.Xaml.SpreadSheet.Data.IconSetType.FourTrafficLights, New GrapeCity.Xaml.SpreadSheet.Data.CellRange() { New GrapeCity.Xaml.SpreadSheet.Data.CellRange(0, 0, 5, 1) })
    See Also