Printing Templates
Excel settings vs. Clausion settings
The default settings for ClausionPage Setup are retrieved from the Excel file or the XML definitions file.
The settings in the XML definitions file are the strongest. If a XML definition is missing, the default value is retrieved from the workbook settings. For exceptions, see the setting descriptions in the following sections.
The default settings can be changed in the Page Setup dialogue box. The selected option remains as the default.
If there is no corresponding setting in the Page Setup dialogue box (for example, page breaks), the setting defined in the Excel file is applied.
Printing to file
If you want to print to file, select Microsoft XPS Document Writer from the Select Printer list and click Print. Select a location and save.
Printing in Web Client
You can print directly by clicking Print in Web Client, however, excluding page orientation and page count, all other printing settings such as scaling can be configured only in template management.
The default settings for ClausionPage Setup are retrieved from the Excel file or the XML definitions file.
Page Setup
Location: input or report template window
Before printing, define Page Setup settings.
The options available in the Page Setup dialogue box depend on the default printer defined in the Windows printer settings.
Page tab
Setting |
Description |
|---|---|
Orientation |
Options for page orientation: Portrait and Landscape |
Scaling |
Adjust to: You can adjust the printout size to a specific percentage of the normal size. The minimum is 10 % of the normal size. Fit to page(s): You can define the number of pages to which the printout will be fit. Note that if page breaks are set in the Excel file, the Fit to page(s) setting is ignored. Exceptions to default settings: In the Page Setup dialogue box, the Fit to page(s) setting is always selected as the default scaling option with XLSX files, even if it has not been defined to be used in the XML or Excel file. |
Paper size |
The size of the printout paper. Exceptions to default settings: All settings defined in the Excel file are not shown as the default in the Page Setup dialogue box. |
Margins tab
Setting |
Description |
|---|---|
Margins |
The margins for the printout. Exceptions to default settings: In the Excel file, the margins are set according to the system of measurement based on Windows regional settings (metric or inches). In the input or report template Page Setup dialogue box, the unit of measurement is always inches. |
Center on page |
Center the content on the page horizontally and/or vertically. Exceptions to default settings: If the Horizontal option has been selected for the template in the workbook settings, this option is not shown as the default in the Page Setup dialogue box. |
Header/Footer tab
Select Header or Footer.
-
Set the options for the header/footer under Sections:
To use a predefined header or footer, select options from the Left, Center, and Right drop-down lists.
You can also type directly in the text boxes below the drop-down lists or use the buttons to insert data. The buttons listed in the following table are available. The default values are retrieved from the workbook settings.'
The &[Tab] (Insert Sheet Name), &[File] (Insert File Name), &[Path]&[File] (Insert File Path), and &[Picture] (Insert Picture) options available in Excel are not displayed in Clausioninput and report templates.
Button |
Description |
|---|---|
|
First select or type the value in the text box, then use this button to define the font for it. Do not select the text in the text box before defining the font, otherwise an empty page will be printed. When you select a value from a drop-down list, the text is automatically selected in the text box. Click outside the text to deselect it. |
|
|
Select text and use this button to define font color. Exceptions to default settings: The settings defined in the Excel file do not work. The color is not shown correctly and the code of the selected color is shown next to the text. In this case, delete the color code and then define the color again. |
|
Add page numbers. |
|
Add the number of pages. |
|
Add the date in a short format. |
|
Add the date in a long format. |
|
Add the time in a short format. |
|
Add the time in a long format. |
|
Add an image. |
Sheet tab
Setting |
Description |
|---|---|
Print Type |
All: If the template contains only one worksheet and a print area has been defined, the print area is printed. If the template contains more than one worksheet and the print area has been defined on the first worksheet, other sheets are printed as a whole. If no print area has been defined, the whole worksheet is printed. Selected: If the template contains only one worksheet and a print area has been defined, the print area is printed. If the template contains more than one worksheet and the print area has been defined on the first worksheet, other sheets are printed as a whole. If no print area has been defined, the whole sheet is printed even if an area has been selected. |
Print Titles |
The print titles setting is used to specify the areas that are printed on every template print page when the printout does not fit on a single sheet of paper.
Exceptions to default settings: The settings defined in Excel 2007 are not shown as the default in the Page Setup dialogue box. Note that if Freeze Panes is used in the Excel file, it is not applied in printing (the frozen section is not printed on every page). |
|
If you want to print the sheet with gridlines, select the Gridlines check box. Note that in addition to this selection, gridlines must be visible in the Excel file (View tab > Show group > Gridlines check box selected). If you use a color printer but want to use black and white only, select the Black and White option. If you use a printer that prints black and white only, you do not need to select this option. Note that colors are shown in print preview (in Input and Report Template management) or when you print to file (in Input and Reporting). If you want to print the column and row headings (the row numbers and column letters), select the Row Headings and/or Column Headings check boxes. |
Print Preview
Location: input or report template window
To preview a printout, select Print > Print Preview. In the Print Preview window, you can zoom the page or view 1 to 6 pages at the same time. You can also print from the Print Preview window, but note that you cannot select the printer (the template is printed to the default printer).
Printing External Workbooks
Printing is done according to the print area. If no print area has been defined, you must select the area you want to print on the sheet. Otherwise printing the external workbook is not possible.
Printing Generated Input and Report Templates
All generated rows are printed if the print area defined for the sheet extends to the generated rows. However, if the sheet includes a print area definition, but it does not cover the generated block, the generated rows are not printed. For example, if there are two area definitions on the sheet, the first of which is not a generated area and the printing area definition covers only this area, the generated rows are not printed.
The print titles and the orientation settings work in the same way as with normal Input and report templates (see Page Setup).
The XML definitions file may include a 'page break blocks' setting. This setting defines the number of generated blocks after which a page break will be inserted.
In the cusrrent version, printing works as described for row generation templates but not for column generation templates.
In case of problems with printing, contact your administrative user.