Spread WPF 14
GrapeCity.Windows.SpreadSheet.Data Namespace / ScaleValueType Enumeration
Example Example


In This Topic
    ScaleValueType Enumeration
    In This Topic
    Specifies the scale type for the value.
    Syntax
    'Declaration
     
    Public Enum ScaleValueType 
       Inherits System.Enum
    'Usage
     
    Dim instance As ScaleValueType
    public enum ScaleValueType : System.Enum 
    Members
    MemberDescription
    AutomaxIndicates whether to return the automatic maximum value in a specified range.
    AutominIndicates whether to return the automatic minimum value in a specified range.
    FormulaIndicates whether to return the result of a formula calculation.
    HighestValueIndicates whether to return the highest value in a specified cell range.
    LowestValueIndicates whether to return the lowest value in a specified cell range.
    NumberIndicates whether to return a specified number directly.
    PercentIndicates whether to return the percentage of a cell value in a specified cell range.
    PercentileIndicates whether to return the percentile of a cell value in a specified cell range.
    Example
    This example uses the ScaleValueType enumeration.
    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)
    Inheritance Hierarchy

    System.Object
       System.ValueType
          System.Enum
             GrapeCity.Windows.SpreadSheet.Data.ScaleValueType

    See Also