GrapeCity.Xaml.SpreadSheet.Data
AddTwoScaleRule Method
Example 


The minimum scale type.
The minimum scale value.
The minimum scale color.
The maximum scale type.
The maximum scale value.
The maximum scale color.
The cell ranges where the rule is applied.
Adds the two color scale rule to the rule collection.
Syntax
'Declaration
 
Public Function AddTwoScaleRule( _
   ByVal minType As ScaleValueType, _
   ByVal minValue As Object, _
   ByVal minColor As Color, _
   ByVal maxType As ScaleValueType, _
   ByVal maxValue As Object, _
   ByVal maxColor As Color, _
   ByVal ParamArray ranges() As CellRange _
) As TwoColorScaleRule
'Usage
 
Dim instance As ConditionalFormat
Dim minType As ScaleValueType
Dim minValue As Object
Dim minColor As Color
Dim maxType As ScaleValueType
Dim maxValue As Object
Dim maxColor As Color
Dim ranges() As CellRange
Dim value As TwoColorScaleRule
 
value = instance.AddTwoScaleRule(minType, minValue, minColor, maxType, maxValue, maxColor, ranges)
public TwoColorScaleRule AddTwoScaleRule( 
   ScaleValueType minType,
   object minValue,
   Color minColor,
   ScaleValueType maxType,
   object maxValue,
   Color maxColor,
   params CellRange[] ranges
)

Parameters

minType
The minimum scale type.
minValue
The minimum scale value.
minColor
The minimum scale color.
maxType
The maximum scale type.
maxValue
The maximum scale value.
maxColor
The maximum scale color.
ranges
The cell ranges where the rule is applied.

Return Value

Returns the new two color scale rule.
Example
This example creates a two scale rule.
GcSpreadSheet1.Sheets[0].Cells[0, 0].Value = -1;
GcSpreadSheet1.Sheets[0].Cells[1, 0].Value = 49;
GcSpreadSheet1.Sheets[0].Cells[2, 0].Value = 101;
GcSpreadSheet1.Sheets[0].ConditionalFormats.AddTwoScaleRule(GrapeCity.Xaml.SpreadSheet.Data.ScaleValueType.Number, 1, Windows.UI.Colors.Yellow, GrapeCity.Xaml.SpreadSheet.Data.ScaleValueType.Number, 100, Windows.UI.Colors.Red, new GrapeCity.Xaml.SpreadSheet.Data.CellRange[] { new GrapeCity.Xaml.SpreadSheet.Data.CellRange(0, 0, 20, 1) });
GcSpreadSheet1.Sheets(0).Cells(0, 0).Value = -1
GcSpreadSheet1.Sheets(0).Cells(1, 0).Value = 49
GcSpreadSheet1.Sheets(0).Cells(2, 0).Value = 101
GcSpreadSheet1.Sheets(0).ConditionalFormats.AddTwoScaleRule(GrapeCity.Xaml.SpreadSheet.Data.ScaleValueType.Number, 1, Windows.UI.Colors.Yellow, GrapeCity.Xaml.SpreadSheet.Data.ScaleValueType.Number, 100, Windows.UI.Colors.Red, New GrapeCity.Xaml.SpreadSheet.Data.CellRange() { New GrapeCity.Xaml.SpreadSheet.Data.CellRange(0, 0, 20, 1) })
Requirements

Target Platforms: Windows Server 2012, Windows RT

See Also

Reference

ConditionalFormat Class
ConditionalFormat Members

 

 


Copyright © GrapeCity, inc. All rights reserved.

Support Options