Spread WinRT Documentation
GrapeCity.Xaml.SpreadSheet.Data Namespace / ConditionalFormat Class / AddDataBarRule Method
The minimum scale type.
The minimum scale value.
The maximum scale type.
The maximum scale value.
The color data bar to show on the view.
The cell ranges where the rule is applied.
Example


In This Topic
    AddDataBarRule Method
    In This Topic
    Adds a data bar rule to the rule collection.
    Syntax
    'Declaration
     
    Public Function AddDataBarRule( _
       ByVal minType As ScaleValueType, _
       ByVal minValue As Object, _
       ByVal maxType As ScaleValueType, _
       ByVal maxValue As Object, _
       ByVal setColor As Color, _
       ByVal ParamArray ranges() As CellRange _
    ) As DataBarRule
    'Usage
     
    Dim instance As ConditionalFormat
    Dim minType As ScaleValueType
    Dim minValue As Object
    Dim maxType As ScaleValueType
    Dim maxValue As Object
    Dim setColor As Color
    Dim ranges() As CellRange
    Dim value As DataBarRule
     
    value = instance.AddDataBarRule(minType, minValue, maxType, maxValue, setColor, ranges)
    public DataBarRule AddDataBarRule( 
       ScaleValueType minType,
       object minValue,
       ScaleValueType maxType,
       object maxValue,
       Color setColor,
       params CellRange[] ranges
    )

    Parameters

    minType
    The minimum scale type.
    minValue
    The minimum scale value.
    maxType
    The maximum scale type.
    maxValue
    The maximum scale value.
    setColor
    The color data bar to show on the view.
    ranges
    The cell ranges where the rule is applied.

    Return Value

    Returns the new data bar rule.
    Example
    This example creates a data bar 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.AddDataBarRule(GrapeCity.Xaml.SpreadSheet.Data.ScaleValueType.LowestValue, 0, GrapeCity.Xaml.SpreadSheet.Data.ScaleValueType.HighestValue, 10, Windows.UI.Colors.Yellow, 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.AddDataBarRule(GrapeCity.Xaml.SpreadSheet.Data.ScaleValueType.LowestValue, 0, GrapeCity.Xaml.SpreadSheet.Data.ScaleValueType.HighestValue, 10, Windows.UI.Colors.Yellow, New GrapeCity.Xaml.SpreadSheet.Data.CellRange() {New GrapeCity.Xaml.SpreadSheet.Data.CellRange(0, 0, 5, 1)})
    See Also