HotXLS Docs

FitToPagesWide property

Returns or sets the number of pages wide the Worksheet will be scaled to when it's printed. Read/write Variant.

Syntax

property FitToPagesWide: Word;

Remarks

If this property is False, the Worksheet will be scaled according to the FitToPagesTall property.If the Zoom property is True, the FitToPagesWide property is ignored.

Example

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

??????Workbook.Worksheets[1].PageSetup.Zoom := False;
Workbook.Worksheets[1].PageSetup.FitToPagesTall := 1;
Workbook.Worksheets[1].PageSetup.FitToPagesWide := 1;