AX3230

Printing an Axiom file

You can print a spreadsheet Axiom file on a per sheet basis. You can decide to print one or more sheets, or all available sheets.

Each sheet can have one or more defined print views. The print views can be used to print different "views" of the sheet, and to set certain standard print options such as the print orientation. For example, for a plan file, you might have one print view that prints a "summary" view of the sheet (with certain columns and rows hidden for printing), and another print view that prints a "detail" view of the sheet (with all columns and rows visible).

If a sheet has no predefined print views, then the sheet can be printed using the settings defined for the spreadsheet using standard Excel printing features. For more information on defining print settings for a spreadsheet, see the Microsoft Excel Help. In the Windows Client, the spreadsheet print settings are defined in the Workbook Explorer, in the Page Setup section for each sheet.

NOTE: You can always print the file using standard spreadsheet print functionality, even if Axiom Software print views have been defined.

To print an Axiom file:

  1. On the Axiom tab, in the File Output group, select one of the following:

    • If you want to be able to select print views from all sheets in the workbook, click Print.

    • If you want to print only the current sheet, then click the arrow to the right of the Print button, and then click Print This Sheet.

    NOTE: In systems with installed products, this feature may be located on the Main tab—either directly on the ribbon or under Publish.

    The Print Sheets dialog opens. This dialog lists the available print views for the entire workbook or for the current sheet, depending on how you entered the dialog. To sort this list by the Sheet Name or Print View Name, click the column header.

    Example Print Sheets dialog

    NOTES:  

    • If a sheet does not have a defined print view, then it is listed with a print view name of "Default," and will use the print settings defined for the spreadsheet.

    • Control Sheets cannot be printed using the Axiom Software printing feature, whether they are visible or hidden. If you want to print a Control Sheet, use the standard spreadsheet printing features.

  2. In the Print Sheets dialog, select the sheet / print view combinations that you want to print.

    If you want to print all print views for all sheets, then select the check box in the column header to select all.

    If you opened this dialog by using Print This Sheet and the sheet has only one available print view, then that view is selected by default.

  3. You can also do any of the following before printing:

    • View and edit the print settings. If you want to view and potentially change the print settings for a selected view, click the View/Edit link. In the Print Options dialog, you can change any of the print settings, for the current print job only (the changes are not saved in the file). See Print Options dialog.

    • Preview a print view. If you want to preview a print view, click the Print Preview link. The native spreadsheet Print Preview feature will open to preview the print job. Only one view can be previewed at a time.

    • Select a printer. If you want to print to a different printer than your default printer, click Choose Printer at the bottom of the dialog. In the Printer Setup dialog, select the printer that you want to use, and then click OK.

      NOTE: In the Windows Client, the printer is always your default printer unless you change it for a particular print job. In the Excel Client, the printer starts as your default printer, but if you change the printer for a print job, the changed selection will be remembered for any future print jobs in the current session.

  4. Click Print.

The selected items are printed.

See also