FitToPage Property

Returns a value indicating whether the FitToPage option is selected in the page setup dialog.

Syntax

Visual Basic
C#

'Declaration
 
Public ReadOnly Property FitToPage As System.Boolean

public System.bool FitToPage {get;}

Property Value

Boolean. The default value is False.

Remarks

If FitToPagesWide or FitToPagesTall was set since the last Zoom, this property will return True to indicate that the FitToPage option in the Page Setup dialog is selected. If Zoom was set since FitToPagesWide or FitToPagesTall (or none of these properties were set at all) this property returns False, indicating that the zoom/percentage scaling option is selected.

Example

sb.Sheets[0].PageSetup.FitToPagesTall = 2;
sb.Sheets[0].PageSetup.FitToPagesWide = 2;

if (sb.Sheets[0].PageSetup.FitToPage == true)
{
    MessageBox.Show("FitToPage");
}

Visual Basic

sb.Sheets(0).PageSetup.FitToPagesTall = 2
sb.Sheets(0).PageSetup.FitToPagesWide = 2

If sb.Sheets(0).PageSetup.FitToPage = True Then
    MsgBox("FitToPage")
End If

Requirements

Target Platforms: 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

Reference

PageSetup Class
PageSetup Members