|
|
|
|
|
|
|
|
- Properties specific to the description of xlsLayout variables
xlsLayout (Type of variable) 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 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.
|
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|