The
xlsLayout type is used to define all the layout characteristics to print a sheet of an XLSX document in a Spreadsheet control or in a variable of type
xlsDocument. The characteristics of this layout can be defined and changed using different WLanguage properties.
Remark: For more details on the declaration of this type of variable and the use of WLanguage properties, see
Declaring a variable.
// Current sheet [NoMargins]
xLayout is xlsLayout = PSHEET_SpreadsheetControl.PageLayout
xLayout.LeftMargin = 0
xLayout.RightMargin = 0
PSHEET_SpreadsheetControl.PageLayout = xLayout
Remarks
Properties specific to the description of xlsLayout variables
The following properties can be used to handle layouts:
| | |
| 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 scaling is performed.
- adjustementModeColumns: All the columns are adjusted to the control width.
- adjustementModeRows: All the rows are adjusted to the control height.
- adjustmentModeRowsAndColumns: The worksheet is adjusted to the dimensions of a 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.
|