HotXLS Docs

FitToPagesTall property

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

Syntax

property FitToPagesTall: Variant;

Remarks

If this property is False, the Worksheet will be scaled according to the FitToPagesWide property. If the Zoom property is True, the FitToPagesTall 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;