com.aspose.cells

Class PivotFormatCondition

  • java.lang.Object
    • com.aspose.cells.PivotFormatCondition
public class PivotFormatCondition 
extends java.lang.Object

Represents a PivotTable Format Condition in PivotFormatCondition Collection.

Property Getters/Setters Summary
FormatConditionCollectiongetFormatConditions()
Get formatconditions for the pivot table condition format .
intgetRuleType()
void
           Get and set rule type for the pivot table condition format . The value of the property is PivotConditionFormatRuleType integer constant.
intgetScopeType()
void
           Get and set scope type for the pivot table condition format . The value of the property is PivotConditionFormatScopeType integer constant.
 
Method Summary
voidaddColumnAreaCondition(PivotField columnField)
Adds PivotTable conditional format limit in the column fields.
voidaddColumnAreaCondition(java.lang.String fieldName)
Adds PivotTable conditional format limit in the column fields.
voidaddDataAreaCondition(PivotField dataField)
Adds PivotTable conditional format limit in the data fields.
voidaddDataAreaCondition(java.lang.String fieldName)
Adds PivotTable conditional format limit in the data fields.
voidaddRowAreaCondition(PivotField rowField)
Adds PivotTable conditional format limit in the row fields.
voidaddRowAreaCondition(java.lang.String fieldName)
Adds PivotTable conditional format limit in the row fields.
voidsetConditionalAreas()
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 .

    setScopeType

    public voidsetScopeType(intvalue)
    
    Get and set scope type for the pivot table condition format . The value of the property is PivotConditionFormatScopeType integer constant.

    setRuleType

    public voidsetRuleType(intvalue)
    
    Get and set rule type for the pivot table condition format . The value of the property is PivotConditionFormatRuleType integer constant.
    • 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.