HotXLS Docs

PageBreakPreviewZoom property

Yields or sets the Page Break Preview zoom percentage for a classic XLS worksheet. Read/write Integer. Employ NormalViewZoom to set the cached Normal view zoom while the worksheet remains in Page Break Preview

Syntax

property PageBreakPreviewZoom: Integer;

Notes

Values from 10 through 400 are accepted. When the worksheet is in Normal view, this property stores the cached Page Break Preview zoom that Excel restores when the user switches views. When the worksheet is already in Page Break Preview, this property matches the active view zoom

Example

This example keeps the worksheet in Normal view while setting the Page Break Preview zoom

Workbook.Sheets[1].View := xlNormalView;
Workbook.Sheets[1].Zoom := 125;
Workbook.Sheets[1].PageBreakPreviewZoom := 75;