public enum FormatConditionType extends Enum<FormatConditionType>
FormatCondition
type.Enum Constant and Description |
---|
ABOVE_OR_BELOW_AVERAGE
Formats only cells with values that are above or below average.
|
COLOR_SCALE
Formats fill of all cells based on their values using a specified 2-point or 3-point color scale.
|
CONTAIN
Formats only cells that contain value which satisfies the specified criteria.
|
DATA_BAR
Formats all cells based on their values by displaying a data bar whose length is proportional to cell's value.
|
FORMULA
Formats only cells for which the specified formula result evaluates to
true . |
ICON_SET
Formats all cells based on their values by displaying an icon from the specified icon set according to cell's value.
|
TOP_OR_BOTTOM_RANKED
Formats only cells with top or bottom ranked values.
|
UNIQUE_OR_DUPLICATE
Formats only cells with unique or duplicate values.
|
Modifier and Type | Method and Description |
---|---|
static FormatConditionType |
valueOf(String name)
Returns the enum constant of this type with the specified name.
|
static FormatConditionType[] |
values()
Returns an array containing the constants of this enum type, in
the order they are declared.
|
public static final FormatConditionType ABOVE_OR_BELOW_AVERAGE
public static final FormatConditionType COLOR_SCALE
public static final FormatConditionType CONTAIN
public static final FormatConditionType DATA_BAR
public static final FormatConditionType FORMULA
true
.public static final FormatConditionType ICON_SET
public static final FormatConditionType TOP_OR_BOTTOM_RANKED
public static final FormatConditionType UNIQUE_OR_DUPLICATE
public static FormatConditionType valueOf(String name)
name
- the name of the enum constant to be returned.IllegalArgumentException
- if this enum type has no constant with the specified nameNullPointerException
- if the argument is nullpublic static FormatConditionType[] values()
for (FormatConditionType c : FormatConditionType.values()) System.out.println(c);
© GemBox d.o.o. — All rights reserved.