CubeField.LayoutForm Property
Returns or sets the way the specified PivotTable items appear — in table format or in outline format.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Property LayoutForm As XlLayoutFormType
Get
Set
'Usage
Dim instance As CubeField
Dim value As XlLayoutFormType
value = instance.LayoutForm
instance.LayoutForm = value
XlLayoutFormType LayoutForm { get; set; }
Property Value
Type: Microsoft.Office.Interop.Excel.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.