Spread WPF 15
GrapeCity.Windows.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.

In This Topic
    AddDataBarRule Method
    In This Topic
    Adds a data bar rule to the rule collection.
    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
    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


    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.

    Return Value

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