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

FormatConditionOperator

Enum Class FormatConditionOperator

java.lang.Object
java.lang.Enum<FormatConditionOperator>
com.grapecity.documents.excel.FormatConditionOperator
All Implemented Interfaces:
Serializable, Comparable<FormatConditionOperator>, Constable
public enum FormatConditionOperator extends Enum<FormatConditionOperator>
Specifies the operator used by a conditional formatting rule to compare a formula with a cell value, or, for Between and NotBetween, to compare two formulas.

Use this enum with cell-value conditional formatting rules to define how the condition is evaluated. Between and NotBetween require two formula arguments, while the other operators use a single comparison value.


 worksheet.getRange("A1:A5").setValue(new Object[][] {
     {80}, {95}, {110}, {140}, {180}
 });
 IFormatCondition condition = (IFormatCondition) worksheet.getRange("A1:A5")
     .getFormatConditions()
     .add(FormatConditionType.CellValue, FormatConditionOperator.Between, 100, 150);
 condition.setNumberFormat("0");

  • Enum Constant Details

    • None

      public static final FormatConditionOperator None
      None.

    • Between

      public static final FormatConditionOperator Between
      Specifes to compare between values. Can only be used if two formulas are provided.

    • NotBetween

      public static final FormatConditionOperator NotBetween
      Specifies to check if values are not between the conditions. Can only be used if two formulas are provided.

    • Equal

      public static final FormatConditionOperator Equal
      Specifies values are equal.

    • NotEqual

      public static final FormatConditionOperator NotEqual
      Specifies values are not equal.

    • Greater

      public static final FormatConditionOperator Greater
      Specifies values are greater than the condition.

    • Less

      public static final FormatConditionOperator Less
      Specifies values are less than the condition.

    • GreaterEqual

      public static final FormatConditionOperator GreaterEqual
      Specifies values are greater than or equal to the condition.

    • LessEqual

      public static final FormatConditionOperator LessEqual
      Specifies values are less than or equal to the condition.

  • Method Details

    • values

      public static FormatConditionOperator[] 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 FormatConditionOperator 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