Package org.apache.poi.ss.usermodel
Class ConditionType
java.lang.Object
org.apache.poi.ss.usermodel.ConditionType
Represents a type of a conditional formatting rule
-
Field Summary
FieldsModifier and TypeFieldDescriptionstatic final ConditionTypeThis conditional formatting rule compares a cell value to a formula calculated result, using an operatorstatic final ConditionTypeThis conditional formatting rule contains a color scale, with the cell background set according to a gradient.static final ConditionTypeThis conditional formatting rule sets a data bar, with the cell populated with bars based on their valuesstatic final ConditionTypeThis conditional formatting rule that files the valuesstatic final ConditionTypeThis conditional formatting rule contains a formula to evaluate.static final ConditionTypeThis conditional formatting rule sets a data bar, with the cell populated with bars based on their valuesfinal bytefinal String -
Method Summary
Modifier and TypeMethodDescriptionstatic ConditionTypeforId(byte id) static ConditionTypeforId(int id) toString()
-
Field Details
-
CELL_VALUE_IS
This conditional formatting rule compares a cell value to a formula calculated result, using an operator -
FORMULA
This conditional formatting rule contains a formula to evaluate. When the formula result is true, the cell is highlighted. -
COLOR_SCALE
This conditional formatting rule contains a color scale, with the cell background set according to a gradient. -
DATA_BAR
This conditional formatting rule sets a data bar, with the cell populated with bars based on their values -
FILTER
This conditional formatting rule that files the values -
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
-
-
Method Details