CF_XLS_PrintSetup
Description
This tag specifies how the sheet is
printed. Margins for the top, left, right, bottom, header
and footer can be specified. The orientation can be either
landscape or portrait. The sheet can also be forced to fit
a certain number of pages in height or width. The sheet can
be scaled and centerd horizontally or vertically. And
finally this tag specifies whether the gridlines are
printed or not. This tag can only be used within the
CF_XLS_Sheet tag.
Syntax
<CF_XLS_PrintSetup
BottomMargin = "Float" (inches)
FooterMargin = "Float" (inches)
FitHeight = "Integer" (number of pages)
FitWidth = "Integer" (number of pages)
HeaderMargin = "Float" (inches)
HorizontallyCenter = "Yes" or "No"
LeftMargin = "Float" (inches)
Orientation = "Portrait" or "Landscape"
PrintGridLines = "Yes" or "No"
RightMargin = "Float" (inches)
Scale = "Integer" (percentage)
TopMargin = "Float" (inches)
VerticallyCenter = "Yes" or "No"/>
Attributes
| Attribute |
Req/Opt |
Default |
Description |
| BottomMargin |
Opt |
1.0 |
The margin for the bottom of the
page. |
| FooterMargin |
Opt |
0.5 |
The margin for the footer of the
page. |
| FitHeight |
Opt |
|
The number of pages to make the sheet
fit in width when printed. |
| FitWidth |
Opt |
|
The number of pages to make the sheet
fit in height when printed. |
| HeaderMargin |
Opt |
0.5 |
The margin for the header of the
page. |
| HorizontallyCenter |
Opt |
No |
Determines whether to center the output on the page.
- Yes - centers the output to the page.
- No - the output is left to the default.
|
| LeftMargin |
Opt |
1.0 |
The margin for the left of the
page. |
| Orientation |
Opt |
Portrait |
Sets the orientation to print the current sheet.
- Portrait - prints the page vertically.
- Landscape - prints the page horizontally.
|
| PrintGridLines |
Opt |
No |
Determines whether to print the gridlines of the
sheet.
- Yes - gridlines appear on the output.
- No - gridlines are omitted.
|
| RightMargin |
Opt |
1.0 |
The margin for the right of the
page. |
| Scale |
Opt |
|
A number represented the percentage
to scale the sheet. Ex. The value 90 will reduce the
printed size of the page by 10%. |
| TopMargin |
Opt |
1.0 |
The margin for the top of the
page. |
| VerticallyCenter |
Opt |
No |
Determines whether to center the output on the page.
- Yes - centers the output to the page.
- No - the output is left to the default.
|
Example
See the examples
page.