GrapeCity.Windows.SpreadSheet.Data Namespace > ThreeColorScaleRule Class : Create Method |
'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 )
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);
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)
Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6