Edit

Share via


AboveAverage.CalcFor Property

Definition

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.

public:
 property Microsoft::Office::Interop::Excel::XlCalcFor CalcFor { Microsoft::Office::Interop::Excel::XlCalcFor get(); void set(Microsoft::Office::Interop::Excel::XlCalcFor value); };
public Microsoft.Office.Interop.Excel.XlCalcFor CalcFor { get; set; }
Public Property CalcFor As XlCalcFor

Property Value

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 ScopeType property is set to xlFieldsScope.

Applies to