PivotTable.CompactRowIndent Property
Returns or sets the indent increment for PivotItems when compact row layout form is turned on. Read/write.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Property CompactRowIndent As Integer
Get
Set
'Usage
Dim instance As PivotTable
Dim value As Integer
value = instance.CompactRowIndent
instance.CompactRowIndent = value
int CompactRowIndent { get; set; }
Property Value
Type: System.Int32
Integer
Remarks
The default value is 1. The valid values for this setting are 0 to the maximum indent specified in Microsoft Excel.