GrapeCity.Xaml.SpreadSheet.Data
AddDataBarRule Method
Example 


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.
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)})
Requirements

Target Platforms: Windows Server 2012, Windows RT

See Also

Reference

ConditionalFormat Class
ConditionalFormat Members

 

 


Copyright © GrapeCity, inc. All rights reserved.

Support Options