Create Method (ThreeColorScaleRule)

Creates a new three color scale with the specified parameters.

Syntax

Visual Basic
C#

'Declaration
 
Public Shared Function Create( _
   ByVal minType As ScaleValueType, _
   ByVal minValue As System.Object, _
   ByVal minColor As System.Windows.Media.Color, _
   ByVal midType As ScaleValueType, _
   ByVal midValue As System.Object, _
   ByVal midColor As System.Windows.Media.Color, _
   ByVal maxType As ScaleValueType, _
   ByVal maxValue As System.Object, _
   ByVal maxColor As System.Windows.Media.Color _
) As ThreeColorScaleRule

'Usage
 
Dim minType As ScaleValueType
Dim minValue As System.Object
Dim minColor As System.Windows.Media.Color
Dim midType As ScaleValueType
Dim midValue As System.Object
Dim midColor As System.Windows.Media.Color
Dim maxType As ScaleValueType
Dim maxValue As System.Object
Dim maxColor As System.Windows.Media.Color
Dim value As ThreeColorScaleRule
 
value = ThreeColorScaleRule.Create(minType, minValue, minColor, midType, midValue, midColor, maxType, maxValue, maxColor)

public static ThreeColorScaleRule Create( 
   ScaleValueType minType,
   System.object minValue,
   System.Windows.Media.Color minColor,
   ScaleValueType midType,
   System.object midValue,
   System.Windows.Media.Color midColor,
   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.
midType: The midpoint scale type.
midValue: The midpoint scale value.
midColor: The midpoint scale color.
maxType: The maximum scale type.
maxValue: The maximum scale value.
maxColor: The maximum scale color.

Return Value

The new three color scale rule

Example

This example uses three colors with the scale rule.

var rule = GrapeCity.Windows.SpreadSheet.Data.ThreeColorScaleRule.Create(GrapeCity.Windows.SpreadSheet.Data.ScaleValueType.Number, 1, Colors.Yellow, GrapeCity.Windows.SpreadSheet.Data.ScaleValueType.Number, 50, Colors.Blue, GrapeCity.Windows.SpreadSheet.Data.ScaleValueType.Number, 100, Colors.Red);
rule.Ranges = new GrapeCity.Windows.SpreadSheet.Data.CellRange[] { new GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 20, 1) };
gcSpreadSheet1.Sheets[0].ConditionalFormats.AddRule(rule);

VB.NET

Dim rule = GrapeCity.Windows.SpreadSheet.Data.ThreeColorScaleRule.Create(GrapeCity.Windows.SpreadSheet.Data.ScaleValueType.Number, 1, Colors.Yellow, GrapeCity.Windows.SpreadSheet.Data.ScaleValueType.Number, 50, Colors.Blue, _
 GrapeCity.Windows.SpreadSheet.Data.ScaleValueType.Number, 100, Colors.Red)
rule.Ranges = New GrapeCity.Windows.SpreadSheet.Data.CellRange() {New GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 20, 1)}
GcSpreadSheet1.Sheets(0).ConditionalFormats.AddRule(rule)

Requirements

Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional (SP4), Windows XP (SP2), Windows 2008, Windows 2003 Server (SP1)

Reference

ThreeColorScaleRule Class
ThreeColorScaleRule Members