com.aspose.cells.PivotFormatCondition.html Maven / Gradle / Ivy
PivotFormatCondition
com.aspose.cells
Class PivotFormatCondition
java.lang.Object
com.aspose.cells.PivotFormatCondition
public class PivotFormatCondition
- extends java.lang.Object
| Property Getters/Setters Summary | ||
|---|---|---|
FormatConditionCollection | getFormatConditions() | |
| Get formatconditions for the pivot table condition format . | ||
int | getRuleType() | |
void | setRuleType(int) | |
| Get and set rule type for the pivot table condition format . The value of the property is PivotConditionFormatRuleType integer constant. | ||
int | getScopeType() | |
void | setScopeType(int) | |
| Get and set scope type for the pivot table condition format . The value of the property is PivotConditionFormatScopeType integer constant. | ||
| Method Summary | ||
|---|---|---|
void | addColumnAreaCondition(PivotField columnField) | |
| Adds PivotTable conditional format limit in the column fields. | ||
void | addColumnAreaCondition(java.lang.String fieldName) | |
| Adds PivotTable conditional format limit in the column fields. | ||
void | addDataAreaCondition(PivotField dataField) | |
| Adds PivotTable conditional format limit in the data fields. | ||
void | addDataAreaCondition(java.lang.String fieldName) | |
| Adds PivotTable conditional format limit in the data fields. | ||
void | addRowAreaCondition(PivotField rowField) | |
| Adds PivotTable conditional format limit in the row fields. | ||
void | addRowAreaCondition(java.lang.String fieldName) | |
| Adds PivotTable conditional format limit in the row fields. | ||
void | setConditionalAreas() | |
| Sets conditional areas of PivotFormatCondition object. | ||
| Property Getters/Setters Detail |
|---|
getScopeType/setScopeType | |
public int getScopeType() / public void setScopeType(int value) | |
Get and set scope type for the pivot table condition format . The value of the property is PivotConditionFormatScopeType integer constant.
getRuleType/setRuleType | |
public int getRuleType() / public void setRuleType(int value) | |
Get and set rule type for the pivot table condition format . The value of the property is PivotConditionFormatRuleType integer constant.
getFormatConditions | |
public FormatConditionCollection getFormatConditions() | |
Get formatconditions for the pivot table condition format .
| Method Detail |
|---|
addDataAreaCondition | |
public void addDataAreaCondition(java.lang.String fieldName) | |
Adds PivotTable conditional format limit in the data fields. - Parameters:
fieldName- The name of PivotField.
addDataAreaCondition | |
public void addDataAreaCondition(PivotField dataField) | |
Adds PivotTable conditional format limit in the data fields. - Parameters:
dataField- The PivotField in the data fields.
addRowAreaCondition | |
public void addRowAreaCondition(java.lang.String fieldName) | |
Adds PivotTable conditional format limit in the row fields. - Parameters:
fieldName- The name of PivotField.
addRowAreaCondition | |
public void addRowAreaCondition(PivotField rowField) | |
Adds PivotTable conditional format limit in the row fields. - Parameters:
rowField- The PivotField in the row fields.
addColumnAreaCondition | |
public void addColumnAreaCondition(java.lang.String fieldName) | |
Adds PivotTable conditional format limit in the column fields. - Parameters:
fieldName- The name of PivotField.
addColumnAreaCondition | |
public void addColumnAreaCondition(PivotField columnField) | |
Adds PivotTable conditional format limit in the column fields. - Parameters:
columnField- The PivotField in the column fields.
setConditionalAreas | |
public void setConditionalAreas()
throws java.lang.Exception | |
Sets conditional areas of PivotFormatCondition object.
See Also:
Aspose.Cells Documentation - the home page for the Aspose.Cells Product Documentation.
Aspose.Cells Support Forum - our preferred method of support.