PivotField.UseMemberPropertyAsCaption 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.

This property is used to control whether member property captions are used for PivotItem captions of the PivotField. Read/write.

public:
 property bool UseMemberPropertyAsCaption { bool get(); void set(bool value); };

public bool UseMemberPropertyAsCaption { get; set; }

Public Property UseMemberPropertyAsCaption As Boolean

Property Value

Boolean

Boolean

Remarks

If UseMemberPropertyAsCaption is set to True for a PivotField, then UseMemberPropertyAsCaption specifies which member property caption to display. If none is specified, the first member property of that PivotField (in data source order) will be displayed as the caption for items of that PivotField.

If UseMemberPropertyAsCaption is set to False, then the regular PivotItem captions are used for the PivotField.

If you try to set UseMemberPropertyAsCaption to True for a PivotField with no member properties, a run-time error is returned. For PivotFields with no member properties, the property will always be False.

Applies to