PivotField.LayoutBlankLine Property
True if a blank row is inserted after the specified row field in a PivotTable report. The default value is False. Read/write Boolean.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Property LayoutBlankLine As Boolean
Get
Set
'Usage
Dim instance As PivotField
Dim value As Boolean
value = instance.LayoutBlankLine
instance.LayoutBlankLine = value
bool LayoutBlankLine { get; set; }
Property Value
Type: System.Boolean
Remarks
You can set this property for any PivotTable field; however, the blank row 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 added to the PivotTable report.
You cannot enter data in the blank row in the PivotTable report.