|
|
|
|
|
|
|
|
|
|
- Properties specific to xlsLayout variables
xlsLayout (Variable type) In french: xlsMiseEnPage
The xlsLayout type is used to define all the layout characteristics to print a sheet of an XLSX document in a Spreadsheet control. You can define and change the characteristics of this layout using different WLanguage properties. Note: For more details on the declaration of this type of variable and the use of WLanguage properties, see Declaring a variable.  New in version 2025
xLayout is xlsLayout = PSHEET_SpreadsheetControl.PageLayout
xLayout.LeftMargin = 0
xLayout.RightMargin = 0
PSHEET_SpreadsheetControl.PageLayout = xLayout
Properties Properties specific to xlsLayout variables The following properties can be used to manipulate the layout of an XLSX document: | | | | Property name | Type used | Effect |
|---|
| HeaderPrinted | Boolean | - True (default) to print the sheet header.
- False otherwise.
| | HeaderVisible | Boolean | - True (default) to show the sheet header in the Spreadsheet control.
- False otherwise.
| | PageHeader | Real | Height of the page header in the printed sheet, expressed in millimeters. | | PageHeight | Real | Height of the printed page, expressed in millimeters. | | PageWidth | Real | Width of the printed page, expressed in millimeters. | | BottomMargin | Double real | Bottom margin of the printed page, expressed in millimeters. | | RightMargin | Real | Right margin of the printed page, expressed in millimeters. | | LeftMargin | Real | Left margin of the printed page, expressed in millimeters. | | TopMargin | Real | Top margin of the printed page, expressed in millimeters. | | AdjustmentMode | Integer constant | - adjustmentModeNone: No adjustment is applied.
- adjustmentModeColumns: All columns are adjusted to the width of the control.
- adjustmentModeRows: All rows are adjusted to the height of the control.
- adjustmentModeRowsAndColumns: The spreadsheet is adjusted to the dimensions of the Spreadsheet control.
| | LandscapeOrientation | Boolean | - True (default) for landscape orientation,
- False for portrait orientation.
| | PageFooter | Real | Height of the footer in the printed page, expressed in millimeters. | | GridlinesPrinted | Boolean | - True (default) to print the gridlines around the cells,
- False to print without gridlines.
| | GridlinesVisible | Boolean | - True (default) to show the gridlines around the cells in the Spreadsheet control,
- False otherwise.
|
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|