AX3231

Setting up print views for Axiom files

You can set up one or more print views for an Axiom file. Using these print views, you can:

• Hide and/or size rows and columns for printing, by associating the print view with an existing sheet view
• Set the print orientation and paper size for the print view
• Set the repeating rows and columns for the print view
• Set the "fit to pages" and zoom for the print view
• Set headers and footers for the print views
• Set page breaks on specific rows and columns

Print views are defined on a per sheet basis. When a user wants to print an Axiom file, they can select from any defined print view in the file. If a sheet does not have any defined print views, then a "default" view is available, which uses the Excel print settings defined for the spreadsheet.

It is not required to set up print views in order to print an Axiom file—you can always use the standard spreadsheet printing features to print. The Axiom Software print views provide you with enhanced printing features such as the ability to print different "views" of a sheet.

Defining a print view

You define a print view by placing the Print tag in the first 500 rows of a sheet. You can manually type the tag into the cell, or you can use the Insert Print View wizard to create a tag.

To define a print view using the wizard:

1. Right-click the cell where you want to place the tag, and then select Axiom Wizards > Insert Print View.

2. In the Print View Options section, complete the following:

   Parameter	Description
   Print View Name	Enter the name of the print view. This is the name that will display to users in the print dialog.
   View Name	If desired, select the name of a sheet view to apply when printing. You can select from any sheet view that is defined within the current sheet. If you specify a sheet view, the view settings will be applied to the print copy. For example, if the view is configured to hide columns or rows, those columns and rows will be hidden in the print copy. Row and column sizing is also applied. For more information on sheet views, see Defining sheet views for a sheet.
   Paper Size	Select one of the following: Use Printing Default, Legal, or Letter. If Use Printing Default is selected, then the current print settings defined for the sheet are used. NOTE: When editing the tag manually, this parameter should be left blank if you want to use the printing default.
   Orientation	Select one of the following: Use Printing Default, Landscape, or Portrait. If Use Printing Default is selected, then the current print settings defined for the sheet are used. NOTE: When editing the tag manually, this parameter should be left blank if you want to use the printing default.
   RepeatRows	Optional. The rows to repeat at the top of the page. Enter the rows as a range; for example: 1:3. If left blank, and a freeze panes setting is defined on the Control Sheet, then the frozen rows are used as the rows to repeat. If freeze panes is not set, then the current print settings for the sheet are used.
   RepeatColumns	Optional. The columns to repeat at the left of the page. Enter the columns as a range; for example: A:C. If left blank, and a freeze panes setting is defined on the Control Sheet, then the frozen columns are used as the columns to repeat. If freeze panes is not set, then the current print settings for the sheet are used.

3. In the Scaling section, complete the following:
   • Fit to Pages Wide: If you want the print copy to scale to a certain number of pages wide, select this option and then type in the number of pages (such as 1 to fit to a single page).
   • Percent Zoom: If you want the print copy to scale to a particular zoom percentage, select this option and then type in the percentage. Specify the number without a percent sign. For example, to zoom by 90%, specify 90.

   If you want to use the spreadsheet's native print settings to define the scaling, then do nothing. It does not matter which radio button is selected, as long as the inputs for each item are both blank.

4. In the Headers and Footers section, define header text as desired. You can define left, center, and right text for the header and for the footer.

   Any header or footer item left blank will use the current print settings defined for the sheet.

   NOTE: Formulas and cell references cannot be entered into this dialog—for example, if you wanted to use GetFileGroupProperty or a cell reference to display the current plan code in the header or footer. However, after the tag has been placed into the cell, you can manually edit it to use a formula.

   TIP: If you intend to convert the tag to a formula, you may want to enter "placeholder" text into the field that you plan to convert to a formula or cell reference. This will make it easier to find the appropriate place in the tag when you manually edit it later.

5. Click OK to place the Print tag into the current cell.

Once the tag has been placed into the cell, you can edit the tag manually, or you can use the wizard to make further edits. To edit an existing tag using the wizard, double-click the cell. Keep in mind that if you edit a tag this way, the current contents of the cell will be overwritten with the revised print tag—so if you have manually edited the tag to be generated from a formula, that will be lost.

If you want to generate the print tag using a formula, then you can use the wizard to create the starting point, and then edit the cell to create the formula. Any subsequent edits must be made manually. Note that the starting bracket and the identifying Print keyword must be whole within the formula—meaning, the text "[Print" must be identifiable within the formula for Axiom Software to recognize it as a print tag; the rest of the tag can be generated using cell references and concatenation.

Setting page breaks for the print view

There are two ways that you can set page breaks for a print view:

• You can flag rows with a [Pagebreak] tag within the print view itself. These tags must be placed in the control column designated by the placement of the Print tag.
• If the Print tag references a sheet view, then you can place the Pagebreak tags within the sheet view. When using this approach, you can specify page breaks on both rows and columns (horizontal and vertical page breaks). For more information, see Defining sheet views for a sheet.

Page breaks are inserted before the row or column that is flagged with a Pagebreak tag. This means that the next page will start with the flagged row or column.

If you have Pagebreak tags defined in both your print view and in the sheet view, then Axiom Software will honor both sets of page breaks.

NOTE: If "fit to pages" is used for the print job, then page break tags are ignored. If page break tags are being ignored but no scaling behavior is specified in the print view, remember that the spreadsheet's native print settings apply if no scaling is defined in the print view.

Printing design considerations

• If a sheet has a defined print area, that print area is always honored by the Axiom Software print option. For example, in templates/plan files, the far right of the sheet often contains many "work columns" that you would not want to include in normal end user printing. You do not need to use a view to omit all of those columns from the print job; instead you would set the print area to the "visible" area of the plan file. The defined print area will always be printed, with the exception of any rows or columns that are hidden via the referenced view.

• If no print area is defined, then the used range defines the overall print area. However, the freeze panes and/or the repeating rows and columns settings define the start of the print area.

• All other printing features that are not controlled by the Print tag are inherited from the Excel print settings for the sheet.

• If a print view uses a sheet view, and that sheet view is not available when the user opens the Print Sheets dialog (for example, if the View tag is constructed using a conditional formula and the tag is not currently active in the sheet), then the corresponding print view will not display in the dialog.

Example print views

[Print;BudgetSummary;Summary]

This example defines a print view named "Budget Summary," which prints the sheet using the settings for the Summary sheet view.

[Print;BudgetSummary;;Landscape;20:25;F:H;1]

In this example, no sheet view is used, so the ViewName parameter is delimited with an "empty" semicolon. The print view is set to use Landscape orientation, with repeating rows and columns of 20:25 and F:H, with the print area fit to one page.

[Print;Payroll;NewHire;;;;;90]

In this example, the NewHire sheet view is used to print just the section of the Payroll sheet with new hires. All of the printing settings are taken from the spreadsheet except for the zoom, which is set to 90%.

="[Print;BudgetDetail;Detail;;;;;90;;"&D25&";;;;;Legal]"

This example is built using a formula so that the center header can read the current plan code from cell D25 (for example: "Dept 22000"). Once the tag is converted to a formula, you cannot edit the tag using the wizard (or else the formula will be overwritten with the plain tag).

This example also uses the PaperSize parameter to specify Legal-sized paper.