CubeField.LayoutForm Property

Definition

Namespace:

Microsoft.Office.Interop.Excel

Assembly:

Microsoft.Office.Interop.Excel.dll

Returns or sets the way the specified PivotTable items appear — in table format or in outline format.

public:
 property Microsoft::Office::Interop::Excel::XlLayoutFormType LayoutForm { Microsoft::Office::Interop::Excel::XlLayoutFormType get(); void set(Microsoft::Office::Interop::Excel::XlLayoutFormType value); };

public Microsoft.Office.Interop.Excel.XlLayoutFormType LayoutForm { get; set; }

Public Property LayoutForm As XlLayoutFormType

Property Value

XlLayoutFormType

Remarks

XlLayoutFormType can be one of these XlLayoutFormType constants:

xlTabular Default.

xlOutline The LayoutSubtotalLocation property specifies where the subtotal appears in the PivotTable report.

You can set this property for any PivotTable field; however, the formatting appears only if the specified field is a row field other than the innermost (lowest-level) row field. For non-OLAP data sources, the value of this property doesn’t change when the field is rearranged or when it is added to or removed from the PivotTable report.