java.lang.Object
com.aspose.cells.FormatCondition
public class FormatCondition
- extends java.lang.Object
Represents conditional formatting condition.
Example:
//Instantiating a Workbook object
Workbook workbook = new Workbook();
Worksheet sheet = workbook.getWorksheets().get(0);
//Adds an empty conditional formatting
int index = sheet.getConditionalFormattings().add();
FormatConditionCollection fcs = sheet.getConditionalFormattings().get(index);
//Sets the conditional format range.
CellArea ca = new CellArea();
ca.StartRow = 0;
ca.EndRow = 0;
ca.StartColumn = 0;
ca.EndColumn = 0;
fcs.addArea(ca);
ca = new CellArea();
ca.StartRow = 1;
ca.EndRow = 1;
ca.StartColumn = 1;
ca.EndColumn = 1;
fcs.addArea(ca);
//Adds condition.
int conditionIndex = fcs.addCondition(FormatConditionType.CELL_VALUE, OperatorType.BETWEEN, "=A2", "100");
//Adds condition.
int conditionIndex2 = fcs.addCondition(FormatConditionType.CELL_VALUE, OperatorType.BETWEEN, "50", "100");
//Sets the background color.
FormatCondition fc = fcs.get(conditionIndex);
fc.getStyle().setBackgroundColor(Color.getRed());
//Saving the Excel file
workbook.save("C:\\output.xls");
Property Getters/Setters Summary |
AboveAverage | getAboveAverage() | |
|
Get the conditional formatting's "AboveAverage" instance.
The default instance's rule highlights cells that are
above the average for all values in the range.
Valid only for type = AboveAverage.
|
ColorScale | getColorScale() | |
|
Get the conditional formatting's "ColorScale" instance.
The default instance is a "green-yellow-red" 3ColorScale .
Valid only for type = ColorScale.
|
DataBar | getDataBar() | |
|
Get the conditional formatting's "DataBar" instance.
The default instance's color is blue.
Valid only for type = DataBar.
|
java.lang.String | getFormula1() | |
void | setFormula1(java.lang.String value) | |
|
Gets and sets the value or expression associated with conditional formatting.
|
java.lang.String | getFormula2() | |
void | setFormula2(java.lang.String value) | |
|
Gets and sets the value or expression associated with conditional formatting.
|
IconSet | getIconSet() | |
|
Get the conditional formatting's "IconSet" instance.
The default instance's IconSetType is TrafficLights31.
Valid only for type = IconSet.
|
int | getOperator() | |
void | setOperator(int value) | |
|
Gets and sets the conditional format operator type.
The value of the property is OperatorType integer constant. |
int | getPriority() | |
void | setPriority(int value) | |
|
The priority of this conditional formatting rule. This value is used to determine which
format should be evaluated and rendered. Lower numeric values are higher priority than
higher numeric values, where '1' is the highest priority.
|
boolean | getStopIfTrue() | |
void | setStopIfTrue(boolean value) | |
|
True, no rules with lower priority may be applied over this rule, when this rule evaluates to true.
Only applies for Excel 2007;
|
Style | getStyle() | |
void | setStyle(Style value) | |
|
Gets or setts style of conditional formatted cell ranges.
|
java.lang.String | getText() | |
void | setText(java.lang.String value) | |
|
The text value in a "text contains" conditional formatting rule.
Valid only for type = containsText, notContainsText, beginsWith and endsWith.
The default value is null.
|
int | getTimePeriod() | |
void | setTimePeriod(int value) | |
|
The applicable time period in a "date occurring…" conditional formatting rule.
Valid only for type = timePeriod.
The default value is TimePeriodType.Today.
The value of the property is TimePeriodType integer constant. |
Top10 | getTop10() | |
|
Get the conditional formatting's "Top10" instance.
The default instance's rule highlights cells whose
values fall in the top 10 bracket.
Valid only for type = Top10.
|
int | getType() | |
void | setType(int value) | |
|
Gets and sets whether the conditional format Type.
The value of the property is FormatConditionType integer constant. |
Method Summary |
java.lang.String | getFormula1(int row, int column) | |
Gets the formula of the conditional formatting of the cell.
|
java.lang.String | getFormula2(int row, int column) | |
Gets the formula of the conditional formatting of the cell.
|
Property Getters/Setters Detail |
getFormula1/setFormula1 | |
public java.lang.String getFormula1() / public void setFormula1(java.lang.String value)
|
-
Gets and sets the value or expression associated with conditional formatting.
Please add all areas before setting formula.
getFormula2/setFormula2 | |
public java.lang.String getFormula2() / public void setFormula2(java.lang.String value)
|
-
Gets and sets the value or expression associated with conditional formatting.
Please add all areas before setting formula.
getOperator/setOperator | |
public int getOperator() / public void setOperator(int value)
|
-
Gets and sets the conditional format operator type.
The value of the property is OperatorType integer constant.OperatorType
getStopIfTrue/setStopIfTrue | |
public boolean getStopIfTrue() / public void setStopIfTrue(boolean value)
|
-
True, no rules with lower priority may be applied over this rule, when this rule evaluates to true.
Only applies for Excel 2007;
getPriority/setPriority | |
public int getPriority() / public void setPriority(int value)
|
-
The priority of this conditional formatting rule. This value is used to determine which
format should be evaluated and rendered. Lower numeric values are higher priority than
higher numeric values, where '1' is the highest priority.
getStyle/setStyle | |
public Style getStyle() / public void setStyle(Style value)
|
-
Gets or setts style of conditional formatted cell ranges.
getType/setType | |
public int getType() / public void setType(int value)
|
-
Gets and sets whether the conditional format Type.
The value of the property is FormatConditionType integer constant.FormatConditionType
getIconSet | |
public IconSet getIconSet()
|
-
Get the conditional formatting's "IconSet" instance.
The default instance's IconSetType is TrafficLights31.
Valid only for type = IconSet.
- Returns:
getDataBar | |
public DataBar getDataBar()
|
-
Get the conditional formatting's "DataBar" instance.
The default instance's color is blue.
Valid only for type = DataBar.
- Returns:
-
Get the conditional formatting's "ColorScale" instance.
The default instance is a "green-yellow-red" 3ColorScale .
Valid only for type = ColorScale.
- Returns:
getTop10 | |
public Top10 getTop10()
|
-
Get the conditional formatting's "Top10" instance.
The default instance's rule highlights cells whose
values fall in the top 10 bracket.
Valid only for type = Top10.
- Returns:
-
Get the conditional formatting's "AboveAverage" instance.
The default instance's rule highlights cells that are
above the average for all values in the range.
Valid only for type = AboveAverage.
- Returns:
getText/setText | |
public java.lang.String getText() / public void setText(java.lang.String value)
|
-
The text value in a "text contains" conditional formatting rule.
Valid only for type = containsText, notContainsText, beginsWith and endsWith.
The default value is null.
getTimePeriod/setTimePeriod | |
public int getTimePeriod() / public void setTimePeriod(int value)
|
-
The applicable time period in a "date occurring…" conditional formatting rule.
Valid only for type = timePeriod.
The default value is TimePeriodType.Today.
The value of the property is TimePeriodType integer constant.
getFormula1 | |
public java.lang.String getFormula1(int row, int column) |
-
Gets the formula of the conditional formatting of the cell.
- Parameters:
row
- The row index.column
- The column index.
- Returns:
- The formula.
getFormula2 | |
public java.lang.String getFormula2(int row, int column) |
-
Gets the formula of the conditional formatting of the cell.
- Parameters:
row
- The row index.column
- The column index.
- Returns:
- The formula.
See Also:
Aspose.Cells Documentation - the home page for the Aspose.Cellss Product Documentation.
Aspose.Cells Support Forum - our preferred method of support.