FormatConditionType
Overview
FormatConditionType is a enum in Aspose.Cells FOSS for Java.
Represents the type of a format condition.
This enumeration defines 16 values: CELL_VALUE, EXPRESSION, CONTAINS_TEXT, NOT_CONTAINS_TEXT, begins_with, ENDS_WITH, TIME_PERIOD, DUPLICATE_VALUES, UNIQUE_VALUES, TOP_10, BOTTOM_10, ABOVE_AVERAGE, and 4 more.
Values
| Value | Description |
|---|---|
CELL_VALUE | Represents a condition based on the cell’s numeric or text value |
EXPRESSION | Represents a condition defined by a custom formula expression |
CONTAINS_TEXT | Represents a condition where the cell contains the specified text |
NOT_CONTAINS_TEXT | Represents a condition where the cell does not contain the specified text |
begins_with | Represents a condition where the cell’s text begins with the given string |
ENDS_WITH | |
TIME_PERIOD | Represents a condition that checks if a date falls within a specific time period |
DUPLICATE_VALUES | Represents a condition that highlights duplicate values in a range |
UNIQUE_VALUES | Represents a condition that highlights unique values in a range |
TOP_10 | Represents a condition that formats the top N values in a range |
BOTTOM_10 | |
ABOVE_AVERAGE | Represents a condition that formats values above the average of the range |
BELOW_AVERAGE | |
COLOR_SCALE | Represents a condition that applies a color gradient based on cell values |
DATA_BAR | Represents a condition that displays data bars proportional to cell values |
ICON_SET | Represents a condition that shows icons based on cell value thresholds |