OpenOffice.org 2, Firefox, and Thunderbird for Windows All in One [Electronic resources]

74. About Advanced Spreadsheet Printing

47 Print a Spreadsheet

62 Set Up Calc Page Formatting

Printing Calc spreadsheets offers some challenges that other kinds of documents, such as Writer documents, do not require. For example, once you develop a comprehensive spreadsheet, you may want to print the spreadsheet with all its notes showing, perhaps even with formulas showing instead of values. Such reports serve as documentation to the spreadsheet and can help you pinpoint errors in the spreadsheet that might be more difficult to locate searching and scrolling around the screen.

TIP

Before printing, be sure to view a preview with

File, Page Preview . The preview ensures that your printed spreadsheet will look exactly the way you want it to look before you send the spreadsheet to paper.

The

Format, Page menu option displays the

Page Style dialog box. The

Sheet tab displays the

Sheet page, where you can specify the kinds of items you wish to print or to suppress during printing. For example, if you want to print formulas instead of the values they equate to, you would click to select the

Formulas option in the

Print area of the

Sheet page.

The Sheet page specifies how you want your spreadsheet to print.

[View full size image]

Normally, the gridlines that separate cells are suppressed during printing, but to help with your row and column alignment when studying large spreadsheets, you may opt to select the

Grid option so that Calc prints the gridlines to paper. In addition, Calc normally suppresses notes that you've attached to cells but will print those notes along with the rest of the spreadsheet if you click to select the

Notes option.

TIP

If your spreadsheet contains one or more charts along with data, you can print just the charts by unchecking every option in the

Print section except the

Charts option.

The

Print dialog box itself enables you to print only a selected range. If, for example, you wanted to print only certain rows in your spreadsheet, select those rows and then select

File, Print from the menu. Click the

Print dialog box's

Selection option before clicking

OK to start printing.

Calc can print only selected ranges if you wish.