You can control the look of the spreadsheet printout in a number of ways, as illustrated in the following procedures. Setting Page and Sheet OptionsCalc 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.
Figure 19-22. Setting Page and Sheet printing options: Borders tab
Figure 19-23. Setting Page and Sheet printing options: Background tab
Setting Up Headers and FootersYou 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.
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 NumberingA 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 BreaksTo 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.
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 BreaksIf 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. |