Class ConditionType

java.lang.Object
org.apache.poi.ss.usermodel.ConditionType

public class ConditionType extends Object
Represents a type of a conditional formatting rule
  • Field Details

    • CELL_VALUE_IS

      public static final ConditionType CELL_VALUE_IS
      This conditional formatting rule compares a cell value to a formula calculated result, using an operator
    • FORMULA

      public static final ConditionType FORMULA
      This conditional formatting rule contains a formula to evaluate. When the formula result is true, the cell is highlighted.
    • COLOR_SCALE

      public static final ConditionType COLOR_SCALE
      This conditional formatting rule contains a color scale, with the cell background set according to a gradient.
    • DATA_BAR

      public static final ConditionType DATA_BAR
      This conditional formatting rule sets a data bar, with the cell populated with bars based on their values
    • FILTER

      public static final ConditionType FILTER
      This conditional formatting rule that files the values
    • ICON_SET

      public static final ConditionType ICON_SET
      This conditional formatting rule sets a data bar, with the cell populated with bars based on their values
    • id

      public final byte id
    • type

      public final String type
  • Method Details