aspose.cells

aspose.cells

Class PivotFormatCondition

Represents a PivotTable Format Condition in PivotFormatCondition Collection.

Property Getters/Setters Summary
functiongetFormatConditions()
Get formatconditions for the pivot table condition format .
functiongetRuleType()
function
setRuleType(value)
           Get and set rule type for the pivot table condition format . The value of the property is PivotConditionFormatRuleType integer constant.
functiongetScopeType()
function
setScopeType(value)
           Get and set scope type for the pivot table condition format . The value of the property is PivotConditionFormatScopeType integer constant.
 
Method Summary
functionaddColumnAreaCondition(columnField)
Adds PivotTable conditional format limit in the column fields.
functionaddColumnAreaCondition(fieldName)
Adds PivotTable conditional format limit in the column fields.
functionaddDataAreaCondition(dataField)
Adds PivotTable conditional format limit in the data fields.
functionaddDataAreaCondition(fieldName)
Adds PivotTable conditional format limit in the data fields.
functionaddRowAreaCondition(rowField)
Adds PivotTable conditional format limit in the row fields.
functionaddRowAreaCondition(fieldName)
Adds PivotTable conditional format limit in the row fields.
functionsetConditionalAreas()
Sets conditional areas of PivotFormatCondition object.
 

    • Property Getters/Setters Detail

      • getScopeType/setScopeType : Number 

        function getScopeType() / function setScopeType(value)
        Get and set scope type for the pivot table condition format . The value of the property is PivotConditionFormatScopeType integer constant.

      • getRuleType/setRuleType : Number 

        function getRuleType() / function setRuleType(value)
        Get and set rule type for the pivot table condition format . The value of the property is PivotConditionFormatRuleType integer constant.

      • getFormatConditions : FormatConditionCollection 

        function getFormatConditions()
        Get formatconditions for the pivot table condition format .

    • Method Detail

      • addDataAreaCondition

        function addDataAreaCondition(fieldName)
        Adds PivotTable conditional format limit in the data fields.
        Parameters:
        fieldName: String - The name of PivotField.

      • addDataAreaCondition

        function addDataAreaCondition(dataField)
        Adds PivotTable conditional format limit in the data fields.
        Parameters:
        dataField: PivotField - The PivotField in the data fields.

      • addRowAreaCondition

        function addRowAreaCondition(fieldName)
        Adds PivotTable conditional format limit in the row fields.
        Parameters:
        fieldName: String - The name of PivotField.

      • addRowAreaCondition

        function addRowAreaCondition(rowField)
        Adds PivotTable conditional format limit in the row fields.
        Parameters:
        rowField: PivotField - The PivotField in the row fields.

      • addColumnAreaCondition

        function addColumnAreaCondition(fieldName)
        Adds PivotTable conditional format limit in the column fields.
        Parameters:
        fieldName: String - The name of PivotField.

      • addColumnAreaCondition

        function addColumnAreaCondition(columnField)
        Adds PivotTable conditional format limit in the column fields.
        Parameters:
        columnField: PivotField - The PivotField in the column fields.

      • setConditionalAreas

        function setConditionalAreas()
        Sets conditional areas of PivotFormatCondition object.