Page Setup

You can control the look of the spreadsheet printout in a number of ways, as illustrated in the following procedures.

Setting Page and Sheet Options

Calc page styles control many aspects of how a printed spreadsheet looks. They also control other printing aspects such as the paper size used, page numbering style, and the direction Calc uses to create the flow of pages (top to bottom or left to right).

You'll set the majority of these options on the Page and Sheet tabs of the Page Styles window.

  1. With the spreadsheet document open containing the sheets you want to set options for, choose Format > Page to display the Page Styles window.

    You can also get to this window from the Stylist (F11) by clicking the Page Styles icon, right-clicking the page style used for the sheet, and choosing Modify.

  2. Set the appropriate options in the Page and Sheet tabs. Use Figure 19-21 through Figure 19-24 for guidance.

    Figure 19-21. Setting Page and Sheet printing options: Page tab

    graphics/19fig21.jpg

    Figure 19-24. Setting Page and Sheet printing options: Sheet tab

    graphics/19fig24.jpg

  3. Click OK.

Figure 19-22. Setting Page and Sheet printing options: Borders tab

graphics/19fig22.jpg

Figure 19-23. Setting Page and Sheet printing options: Background tab

graphics/19fig23.jpg

Setting Up Headers and Footers

You can print spreadsheets with header and footer information that includes any text you type, the name of the spreadsheet file, the name of the sheet, page numbers , total page count, date, and time. You can also format the header and footer font.

Each page style has its own header and footer information.

  1. With the spreadsheet document open containing the sheets you want to set header and footer information for, choose Format > Page to display the Page Styles window.

    You can also get to this window from the Stylist (F11) by clicking the Page Styles icon, right-clicking the page style used for the sheet, and choosing Modify.

  2. Set the appropriate options in the Header and Footer tabs. Use Figure 19-25 and Figure 19-26 for guidance.

    Figure 19-25. Setting up headers and footers: basics

    graphics/19fig25.jpg

    Figure 19-26. Setting up headers and footers: specifying content

    graphics/19fig26.jpg

  3. Click OK.

You can also edit headers and footers for the active page style by choosing Edit > Headers & Footers.

If Calc won't let you insert page numbers in a header or footer, make sure you have a numbering style selected in the Page Style window on the Page tab. If numbering is set to None, you can't insert a page number in a header or footer.

Things That Affect Page Numbering

A whole bunch of things affect page numbering: the Format option for number formatting from Figure 19-21, the First Page Number option from Figure 19-24 for guidance, and the settings you specify for headers and footers formatting in Figure 19-26. In addition, the Page Layout selection you made in Figure 19-21 and the options under the Same Content Left/Right option in Figure 19-26 affect whether the numbering is the same on both sides. Header and footer settings override other settings.

Previewing Page Breaks

To give you an idea of how pages are going to break when you print your spreadsheet, and to show you the page flow direction Calc is going to create, turn on Calc's Page Break Preview feature by choosing View > Page Break Preview.

graphics/19inf13.jpg

Calc reduces the viewing percentage of the spreadsheet, displays large nonprinting page number watermarks behind each page, and inserts nonprinting page break lines (see figure at right).

With Page Break Preview activated, you can still work in the spreadsheet, and you can increase the viewing percentage by right-clicking the viewing percentage box in the status bar and choosing the viewing percentage you want.

To increase the amount of spreadsheet that fits on a page, choose Format > Page, and in the Page Style window, select the Pages tab and decrease the margin settings. If after that you still need to fit more on a page, try resizing the columns . You can also go to the Page Style window, select the Sheet tab, and adjust the Scale settings. See Figure 19-21 on page 547 for details

Inserting Manual Row and Column Breaks

If while in Page Break Preview (previous procedure) or by using the print preview (File > Page Preview) you see the need to create manual page breaks to better control the print output of your spreadsheet, select the row or column you want to break on and choose Insert > Manual Break > (Row Break or Column Break).

To remove manual breaks, choose Edit > Remove Manual Break > (Row Break or Column Break).

Manual breaks may not always be the answer, however. Sometimes creating good page breaks may just be a matter of resizing rows or columns.



OpenOffice. org 1.0 Resource Kit
OpenOffice.Org 1.0 Resource Kit
ISBN: 0131407457
EAN: 2147483647
Year: 2005
Pages: 407

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