73 About Advanced Spreadsheet Printing

 <  Day Day Up  >  

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.

Before You Begin

46 Print a Spreadsheet

61 Set Up Calc Page Formatting


TIP

graphics/tipbw_icon.gif

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.

graphics/09inf07.jpg

TIP

graphics/tipbw_icon.gif

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.


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.

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.

graphics/09inf08.jpg
 <  Day Day Up  >  


Sams Teach Yourself OpenOffice.org All In One
Sams Teach Yourself OpenOffice.org All In One
ISBN: 0672326183
EAN: 2147483647
Year: 2003
Pages: 205
Authors: Greg Perry

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net