aspose.cells

Class FormatConditionValueType

Utility class containing constants. Condition value type.

Field Summary
const  NumberFORMULA
The minimum/ midpoint / maximum value for the gradient is determined by a formula.
const  NumberMAX
Indicates that the maximum value in the range shall be used as the maximum value for the gradient.
const  NumberMIN
Indicates that the minimum value in the range shall be used as the minimum value for the gradient.
const  NumberNUMBER
Indicates that the minimum / midpoint / maximum value for the gradient is specified by a constant numeric value.
const  NumberPERCENT
Value indicates a percentage between the minimum and maximum values in the range shall be used as the minimum / midpoint / maximum value for the gradient.
const  NumberPERCENTILE
Value indicates a percentile ranking in the range shall be used as the minimum / midpoint / maximum value for the gradient.
const  NumberAUTOMATIC_MAX
Indicates that the Automatic maximum value in the range shall be used as the Automatic maximum value for the gradient.
const  NumberAUTOMATIC_MIN
Indicates that the Automatic minimum value in the range shall be used as the Automatic minimum value for the gradient.
 

    • Field Detail

      • FORMULA

        const Number FORMULA
        The minimum/ midpoint / maximum value for the gradient is determined by a formula.
      • MAX

        const Number MAX
        Indicates that the maximum value in the range shall be used as the maximum value for the gradient.
      • MIN

        const Number MIN
        Indicates that the minimum value in the range shall be used as the minimum value for the gradient.
      • NUMBER

        const Number NUMBER
        Indicates that the minimum / midpoint / maximum value for the gradient is specified by a constant numeric value.
      • PERCENT

        const Number PERCENT
        Value indicates a percentage between the minimum and maximum values in the range shall be used as the minimum / midpoint / maximum value for the gradient.
      • PERCENTILE

        const Number PERCENTILE
        Value indicates a percentile ranking in the range shall be used as the minimum / midpoint / maximum value for the gradient.
      • AUTOMATIC_MAX

        const Number AUTOMATIC_MAX
        Indicates that the Automatic maximum value in the range shall be used as the Automatic maximum value for the gradient.
      • AUTOMATIC_MIN

        const Number AUTOMATIC_MIN
        Indicates that the Automatic minimum value in the range shall be used as the Automatic minimum value for the gradient.