| GrapeCity.Windows.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.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)
System.Object
System.ValueType
System.Enum
GrapeCity.Windows.SpreadSheet.Data.ScaleValueType
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)