asposecells.api

Property Getters/Setters Detail

• getScopeType/setScopeType : int 

  int getScopeType() / setScopeType(value)
  

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

• getRuleType/setRuleType : int 

  int getRuleType() / setRuleType(value)
  

  Get and set rule type for the pivot table condition format . The value of the property is PivotConditionFormatRuleType integer constant.

• getFormatConditions : FormatConditionCollection 

  FormatConditionCollection getFormatConditions()
  

  Get formatconditions for the pivot table condition format .

Method Detail

• addDataAreaCondition

   addDataAreaCondition(fieldName)

  Adds PivotTable conditional format limit in the data fields.

  Parameters:

  fieldName: String - The name of PivotField.

• addDataAreaCondition

   addDataAreaCondition(dataField)

  Adds PivotTable conditional format limit in the data fields.

  Parameters:

  dataField: PivotField - The PivotField in the data fields.

• addRowAreaCondition

   addRowAreaCondition(fieldName)

  Adds PivotTable conditional format limit in the row fields.

  Parameters:

  fieldName: String - The name of PivotField.

• addRowAreaCondition

   addRowAreaCondition(rowField)

  Adds PivotTable conditional format limit in the row fields.

  Parameters:

  rowField: PivotField - The PivotField in the row fields.

• addColumnAreaCondition

   addColumnAreaCondition(fieldName)

  Adds PivotTable conditional format limit in the column fields.

  Parameters:

  fieldName: String - The name of PivotField.

• addColumnAreaCondition

   addColumnAreaCondition(columnField)

  Adds PivotTable conditional format limit in the column fields.

  Parameters:

  columnField: PivotField - The PivotField in the column fields.

• setConditionalAreas

   setConditionalAreas()

  Sets conditional areas of PivotFormatCondition object.