Spread WPF 14
GrapeCity.Excel Namespace / ExcelConditionalFormatValueObjectType Enumeration


In This Topic
    ExcelConditionalFormatValueObjectType Enumeration
    In This Topic
    This simple type expresses the type of the conditional formatting value object (cfvo). In general the cfvo specifies one value used in the gradated scale (max, min, midpoint, etc).
    Syntax
    'Declaration
     
    Public Enum ExcelConditionalFormatValueObjectType 
       Inherits System.Enum
    'Usage
     
    Dim instance As ExcelConditionalFormatValueObjectType
    public enum ExcelConditionalFormatValueObjectType : System.Enum 
    Members
    MemberDescription
    AutoMaxThe larger of zero or the maximum value from the range of cells that the conditional formatting rule applies to.
    AutoMinThe smaller of zero or the minimum value from the range of cells that the conditional formatting rule applies to.
    FormulaThe minimum/ midpoint / maximum value for the gradient is determined by a formula.
    MaxIndicates that the maximum value in the range shall be used as the maximum value for the gradient.
    MinIndicates that the minimum value in the range shall be used as the minimum value for the gradient.
    NumIndicates that the minimum / midpoint / maximum value for the gradient is specified by a constant numeric value.
    PercentValue indicates a percentage between the minimum and maximum values in the range shall be used as the minimum / midpoint / maximum value for the gradient.
    PercentileValue indicates a percentile ranking in the range shall be used as the minimum / midpoint / maximum value for the gradient
    StddevIndicates the item represents the "standard deviation" aggregate function.
    Inheritance Hierarchy

    System.Object
       System.ValueType
          System.Enum
             GrapeCity.Excel.ExcelConditionalFormatValueObjectType

    See Also