PivotField.LayoutCompactRow Property
Specifies whether or not a PivotField is compacted (items of multiple PivotFields are displayed in a single column) when rows are selected. Read/write.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Property LayoutCompactRow As Boolean
Get
Set
'Usage
Dim instance As PivotField
Dim value As Boolean
value = instance.LayoutCompactRow
instance.LayoutCompactRow = value
bool LayoutCompactRow { get; set; }
Property Value
Type: System.Boolean
Boolean
Remarks
Setting this property to True (default) will have no immediate visual effect in the PivotTable if the LayoutForm property is set to xlTabular, but it can be set independently.