ShowWhitespaceInPageLayoutView Property

Gets or sets the value which indicates whether to show whitespace between worksheet pages in page layout view.

Syntax

Visual Basic

'Declaration
 
Public Property ShowWhitespaceInPageLayoutView As Boolean

C#

public bool ShowWhitespaceInPageLayoutView {get; set;}

Property Value

The value which indicates whether to show white page between worksheet pages in page layout view.

Remarks

Note: For this value to affect the display of the worksheet, the View must be set to PageLayout. However, if a different view is used, this is still saved with the workbook.

Note: The WorksheetView value of PageLayout is only supported in Excel 2007. If a worksheet with that View is viewed in earlier versions of Microsoft Excel, the view will default to Normal view.

Requirements

Target Platforms: Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Server 2012, Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2