Skip to main content

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

TdxSpreadSheetTableViewOptionsPrintPage.FitToHeight Property

Specifies the number of printout pages that must accommodate all occupied worksheet rows.

#Declaration

Delphi
property FitToHeight: Cardinal read; write; default 0;

#Property Value

Type Default
Cardinal 0

#Remarks

This property is used either individually or in conjunction with the FitToWidth property to limit the number of pages on which the worksheet contents must be printed. The FitToHeight property is particularly useful if your worksheet has a lot of rows, providing the option to reduce the row height to fit the specified number of printout pages.

To specify the number of printout pages that must accommodate all occupied worksheet columns use the FitToWidth property instead.

Note

The worksheet print setting, provided by the FitToHeight property, is supported only by the XLSX, XLTX, XLS, and XLT file formats. If you save the workbook in other file formats, this print setting is ignored. The FitToHeight property value is applied to the printout page layout only if the ScaleMode property is set to oppsmFitToPage.

The default FitToHeight property value is 0.

See Also