Edit

Share via


Top10.CalcFor Property

Definition

Returns or sets how the conditional format in a PivotTable report should be evaluated.

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 xlRowGroups only if the ScopeType property is set to xlFieldsScope.

Applies to