[]
DEMOS DOCS API PRICING
FREE TRIAL
(Showing Draft Content)

AutoFilterOperator

Enum Class AutoFilterOperator

java.lang.Object
java.lang.Enum<AutoFilterOperator>
com.grapecity.documents.excel.AutoFilterOperator
All Implemented Interfaces:
Serializable, Comparable<AutoFilterOperator>, Constable
public enum AutoFilterOperator extends Enum<AutoFilterOperator>
Specifies the operator to use to associate two criteria applied by a filter.

  • Enum Constant Details

    • None

      public static final AutoFilterOperator None
      Specifies the default.

    • And

      public static final AutoFilterOperator And
      Specifies logical AND of Criteria1 and Criteria2.

    • Or

      public static final AutoFilterOperator Or
      Specifies logical OR of Criteria1 and Criteria2.

    • Top10Items

      public static final AutoFilterOperator Top10Items
      Specifies that the highest-valued items are displayed (number of items specified in Criteria1).

    • Bottom10Items

      public static final AutoFilterOperator Bottom10Items
      Specifies that the lowest-valued items are displayed (number of items specified in Criteria1).

    • Top10Percent

      public static final AutoFilterOperator Top10Percent
      Specifies that the lowest-valued items are displayed (percentage of items specified in Criteria1).

    • Bottom10Percent

      public static final AutoFilterOperator Bottom10Percent
      Specifies that the lowest-valued items are displayed (percentage specified in Criteria1).

    • Values

      public static final AutoFilterOperator Values
      Specifies filter values.

    • CellColor

      public static final AutoFilterOperator CellColor
      Specifies the cell color.

    • FontColor

      public static final AutoFilterOperator FontColor
      Specifies the font color.

    • Icon

      public static final AutoFilterOperator Icon
      Specifies the filter icon.

    • Dynamic

      public static final AutoFilterOperator Dynamic
      Specifies the dynamic filter.

    • NoFill

      public static final AutoFilterOperator NoFill
      Specifies that this is reserved for internal use.

    • AutomaticFontColor

      public static final AutoFilterOperator AutomaticFontColor
      Specifies that this is reserved for internal use.

    • NoIcon

      public static final AutoFilterOperator NoIcon
      Specifies that this is reserved for internal use.

  • Method Details

    • values

      public static AutoFilterOperator[] values()
      Returns an array containing the constants of this enum class, in the order they are declared.
      Returns:
      an array containing the constants of this enum class, in the order they are declared

    • valueOf

      public static AutoFilterOperator valueOf(String name)
      Returns the enum constant of this class with the specified name. The string must match exactly an identifier used to declare an enum constant in this class. (Extraneous whitespace characters are not permitted.)
      Parameters:
      name - the name of the enum constant to be returned.
      Returns:
      the enum constant with the specified name
      Throws:
      IllegalArgumentException - if this enum class has no constant with the specified name
      NullPointerException - if the argument is null