Spread WPF Documentation
Create Method (TwoColorScaleRule)
Example 


GrapeCity.Windows.SpreadSheet.Data Namespace > TwoColorScaleRule Class : Create Method
The minimum scale type.
The minimum scale value.
The minimum scale color.
The maximum scale type.
The maximum scale value.
The maximum scale color.
Creates a new two color scale with the specified parameters.
Syntax
'Declaration
 
Public Shared Function Create( _
   ByVal minType As ScaleValueType, _
   ByVal minValue As System.Object, _
   ByVal minColor As System.Windows.Media.Color, _
   ByVal maxType As ScaleValueType, _
   ByVal maxValue As System.Object, _
   ByVal maxColor As System.Windows.Media.Color _
) As TwoColorScaleRule
'Usage
 
Dim minType As ScaleValueType
Dim minValue As System.Object
Dim minColor As System.Windows.Media.Color
Dim maxType As ScaleValueType
Dim maxValue As System.Object
Dim maxColor As System.Windows.Media.Color
Dim value As TwoColorScaleRule
 
value = TwoColorScaleRule.Create(minType, minValue, minColor, maxType, maxValue, maxColor)
public static TwoColorScaleRule Create( 
   ScaleValueType minType,
   System.object minValue,
   System.Windows.Media.Color minColor,
   ScaleValueType maxType,
   System.object maxValue,
   System.Windows.Media.Color maxColor
)

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.

Return Value

The new two color scale rule.
Example
This example uses the two color scale rule.
var rule = GrapeCity.Windows.SpreadSheet.Data.TwoColorScaleRule.Create(GrapeCity.Windows.SpreadSheet.Data.ScaleValueType.Number, 1, Colors.Yellow, GrapeCity.Windows.SpreadSheet.Data.ScaleValueType.Number, 50, Colors.Blue);
rule.Ranges = new GrapeCity.Windows.SpreadSheet.Data.CellRange[] { new GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 20, 1) };
gcSpreadSheet1.Sheets[0].ConditionalFormats.AddRule(rule);
Dim rule = GrapeCity.Windows.SpreadSheet.Data.TwoColorScaleRule.Create(GrapeCity.Windows.SpreadSheet.Data.ScaleValueType.Number, 1, Colors.Yellow,
GrapeCity.Windows.SpreadSheet.Data.ScaleValueType.Number, 50, Colors.Blue)
rule.Ranges = New GrapeCity.Windows.SpreadSheet.Data.CellRange() {New GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 20, 1)}
GcSpreadSheet1.Sheets(0).ConditionalFormats.AddRule(rule)
See Also

Reference

TwoColorScaleRule Class
TwoColorScaleRule Members