GrapeCity.Xaml.SpreadSheet.Data Namespace > ConditionalFormat Class : AddThreeScaleRule Method |
'Declaration Public Function AddThreeScaleRule( _ ByVal minType As ScaleValueType, _ ByVal minValue As Object, _ ByVal minColor As Color, _ ByVal midType As ScaleValueType, _ ByVal midValue As Object, _ ByVal midColor As Color, _ ByVal maxType As ScaleValueType, _ ByVal maxValue As Object, _ ByVal maxColor As Color, _ ByVal ParamArray ranges() As CellRange _ ) As ThreeColorScaleRule
'Usage Dim instance As ConditionalFormat Dim minType As ScaleValueType Dim minValue As Object Dim minColor As Color Dim midType As ScaleValueType Dim midValue As Object Dim midColor As Color Dim maxType As ScaleValueType Dim maxValue As Object Dim maxColor As Color Dim ranges() As CellRange Dim value As ThreeColorScaleRule value = instance.AddThreeScaleRule(minType, minValue, minColor, midType, midValue, midColor, maxType, maxValue, maxColor, ranges)
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.AddThreeScaleRule(GrapeCity.Xaml.SpreadSheet.Data.ScaleValueType.Number, 1, Windows.UI.Colors.Yellow, GrapeCity.Xaml.SpreadSheet.Data.ScaleValueType.Number, 50, Windows.UI.Colors.Blue, 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.AddThreeScaleRule(GrapeCity.Xaml.SpreadSheet.Data.ScaleValueType.Number, 1, Windows.UI.Colors.Yellow, GrapeCity.Xaml.SpreadSheet.Data.ScaleValueType.Number, 50, Windows.UI.Colors.Blue, 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) })
Target Platforms: Windows Server 2012, Windows RT