程序包 com.grapecity.documents.excel

接口 IIconCriterion

public interface IIconCriterion
Represents the criterion for an individual icon in an icon set. The criterion specifies the range of values and the threshold type associated with the icon in an icon set conditional formatting rule.

  • 方法概要

    修饰符和类型
    方法
    说明
    IconType
    getIcon()
    Gets the icon for a criterion in an icon set conditional formatting rule.
    int
    getIndex()
    Gets a value that indicates which threshold the criteria represents.
    FormatConditionOperator
    getOperator()
    Returns one of the constants of the FormatConditionOperator enumeration, which specifes if the threshold is "greater than" or "greater than or equal to" the threshold value.
    ConditionValueTypes
    getType()
    Returns one of the constants of the ConditionValueTypes enumeration, which specifies how the threshold value for an icon set is determined.
    Object
    getValue()
    Returns the threshold value for an icon in a conditional format.
    void
    setIcon(IconType value)
    Sets the icon for a criterion in an icon set conditional formatting rule.
    void
    setOperator(FormatConditionOperator value)
    Sets one of the constants of the FormatConditionOperator enumeration, which specifes if the threshold is "greater than" or "greater than or equal to" the threshold value.
    void
    setType(ConditionValueTypes value)
    Sets one of the constants of the ConditionValueTypes enumeration, which specifies how the threshold value for an icon set is determined.
    void
    setValue(Object value)
    Sets the threshold value for an icon in a conditional format.

  • 方法详细资料

    • getIcon

      IconType getIcon()
      Gets the icon for a criterion in an icon set conditional formatting rule.

    • setIcon

      void setIcon(IconType value)
      Sets the icon for a criterion in an icon set conditional formatting rule.

    • getIndex

      int getIndex()
      Gets a value that indicates which threshold the criteria represents.

    • getOperator

      FormatConditionOperator getOperator()
      Returns one of the constants of the FormatConditionOperator enumeration, which specifes if the threshold is "greater than" or "greater than or equal to" the threshold value.

    • setOperator

      void setOperator(FormatConditionOperator value)
      Sets one of the constants of the FormatConditionOperator enumeration, which specifes if the threshold is "greater than" or "greater than or equal to" the threshold value.

      For an icon set conditional formatting rule, this property can be set to only one of the following two constants: xlGreater or xlGreaterEqual.

    • getType

      ConditionValueTypes getType()
      Returns one of the constants of the ConditionValueTypes enumeration, which specifies how the threshold value for an icon set is determined.

    • setType

      void setType(ConditionValueTypes value)
      Sets one of the constants of the ConditionValueTypes enumeration, which specifies how the threshold value for an icon set is determined.

    • getValue

      Object getValue()
      Returns the threshold value for an icon in a conditional format.

    • setValue

      void setValue(Object value)
      Sets the threshold value for an icon in a conditional format.