Gets or sets a value that indicates whether the worksheet is scaled for printing using Zoom property or FitToPagesWide and FitToPagesTall properties.

[Visual Basic]
Property FitToPages As Boolean
[C#]
bool FitToPages { get; set; }
[C++]
__property bool get_FitToPages();
__property void set_FitToPages(bool );
[JScript]
function get FitToPages() : bool
function set FitToPages(bool);

Property Value

True if worksheet is scaled using FitToPagesWide and FitToPagesTall properties; False if worksheet is scaled using Zoom property.

Example

This example causes to print worksheet one exactly one page tall and wide.

[C#]
book.Worksheets[1].PageSetup.FitToPagesTall = 1;
book.Worksheets[1].PageSetup.FitToPagesWide = 1;
book.Worksheets[1].PageSetup.Zoom = 50;
book.Worksheets[1].PageSetup.FitToPages = true;

[Visual Basic]
book.Worksheets(1).PageSetup.FitToPagesTall = 1
book.Worksheets(1).PageSetup.FitToPagesWide = 1
book.Worksheets(1).PageSetup.Zoom = 50
book.Worksheets(1).PageSetup.FitToPages = True

[C++]
book->Worksheets->Item[1]->PageSetup->FitToPagesTall = 1;
book->Worksheets->Item[1]->PageSetup->FitToPagesWide = 1;
book->Worksheets->Item[1]->PageSetup->Zoom = 50;
book->Worksheets->Item[1]->PageSetup->FitToPages = true;

See Also

IPageSetup Interface | NativeExcel Namespace | FitToPagesWide Property | FitToPagesTall Property | Zoom Property

---