GrapeCity.Xaml.SpreadSheet.Data Namespace : ScaleValueType Enumeration |
'Declaration Public Enum ScaleValueType Inherits System.Enum
'Usage Dim instance As ScaleValueType
public enum ScaleValueType : System.Enum
Member | Description |
---|---|
Automax | Indicates whether to return the automatic maximum value in a specified range. |
Automin | Indicates whether to return the automatic minimum value in a specified range. |
Formula | Indicates whether to return the result of a formula calculation. |
HighestValue | Indicates whether to return the highest value in a specified cell range. |
LowestValue | Indicates whether to return the lowest value in a specified cell range. |
Number | Indicates whether to return a specified number directly. |
Percent | Indicates whether to return the percentage of a cell value in a specified cell range. |
Percentile | Indicates whether to return the percentile of a cell value in a specified cell range. |
var rule = GrapeCity.Xaml.SpreadSheet.Data.TwoColorScaleRule.Create(GrapeCity.Xaml.SpreadSheet.Data.ScaleValueType.Number, 1, Windows.UI.Colors.Yellow, GrapeCity.Xaml.SpreadSheet.Data.ScaleValueType.Number, 50, Windows.UI.Colors.Blue); rule.Ranges = new GrapeCity.Xaml.SpreadSheet.Data.CellRange[] { new GrapeCity.Xaml.SpreadSheet.Data.CellRange(0, 0, 20, 1) }; gcSpreadSheet1.Sheets[0].ConditionalFormats.AddRule(rule);
Dim rule = GrapeCity.Xaml.SpreadSheet.Data.TwoColorScaleRule.Create(GrapeCity.Xaml.SpreadSheet.Data.ScaleValueType.Number, 1, Windows.UI.Colors.Yellow, GrapeCity.Xaml.SpreadSheet.Data.ScaleValueType.Number, 50, Windows.UI.Colors.Blue) rule.Ranges = New GrapeCity.Xaml.SpreadSheet.Data.CellRange() {New GrapeCity.Xaml.SpreadSheet.Data.CellRange(0, 0, 20, 1)} GcSpreadSheet1.Sheets(0).ConditionalFormats.AddRule(rule)
System.Object
System.ValueType
System.Enum
GrapeCity.Xaml.SpreadSheet.Data.ScaleValueType
Target Platforms: Windows Server 2012, Windows RT