TExportPageSettings stores the print page settings of a worksheet.
Name | Type | Description |
---|---|---|
MarginLeft | Double | Left margin of the page in centimeters. |
MarginTop | Double | Top margin of the page in centimeters. |
MarginRight | Double | Right margin of the page in centimeters. |
MarginBottom | Double | Bottom margin of the page in centimeters. |
CenterTable | TExportCenterTable |
Defines if the table will be centered on the print page. Use a set of these parameters:
|
PageOrientation | TPrinterOrientation |
Defines the page orientation:
|
PageOrder | TExportFlowOrientation |
Defines the table flow if the table is bigger than one page:
|
FirstPageNumber | Integer | The number of the first page in the sheet. XLS and XLSX support even negative page numbers, ODS supports only numbers greater than 1. |
PrintRange | TExportRange | Table print range. If a valid range is specified, only the cells defined by the range will be printed. Valid range must have defined a rectangle area (both left/right columns and top/bottom rows must be defined). |
RowsToRepeat | TExportRange | Row range that will be printed on top of every page. Useful for table header. Only row range is used. |
ColsToRepeat | TExportRange | Column range that will be printed on left side of every page. Useful for table header. Only column range is used. |
PrintHeaders | Boolean | Print column and row headers. |
PrintGridLines | Boolean | Print grid lines. |
ScaleType | TExportScaleType | estPercent: PrintScale is used estFitToPage: FitWidthToPages and FitHeightToPages are used. |
PrintScale | Integer | Print scale in percent. 100 means no scaling (100%). Check the ScaleType property as well. |
FitWidthToPages | Integer | The document's width will be scaled to this count of pages. 0 means no scaling used. Check the ScaleType property as well. |
FitHeightToPages | Integer | The document's height will be scaled to this count of pages. 0 means no scaling used. Check the ScaleType property as well. |