AboveAverage.CalcFor Property
Returns or sets one of the constants of the XlCalcFor enumeration, which specifies the scope of data to be evaluated for the conditional format in a PivotTable report.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Property CalcFor As XlCalcFor
Get
Set
'Usage
Dim instance As AboveAverage
Dim value As XlCalcFor
value = instance.CalcFor
instance.CalcFor = value
XlCalcFor CalcFor { get; set; }
Property Value
Type: Microsoft.Office.Interop.Excel.XlCalcFor
XlCalcFor
Remarks
This property is applicable only when the conditional format is being applied to data in a PivotTable report.
This property can be set to xlAllValues, xlColGroups, or xlRowGroupsonly if the AboveAverage.ScopeType property is set to xlFieldsScope.