Top10.CalcFor Property

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

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