Page Setup Dialog - Headers and Footers

Figure 15-11 Print Setup Headers and Footers Tab

Select a predefined format for either the header or the footer. You can define an header or a footer by clicking the Configure button next to the according drop-down field.

Figure 15-12 Print Setup Headers and Footers Configure Dialog

Headers and footers are divided into left, center and right area. Select the area you want to change. Insert a user-defined text or just select one or several of the given options. When selecting time and/or date you may choose the format by clicking on the arrow next to the symbol and click on the preferred option. Beside the according page number, the number of total pages and the name of the according worksheet, you may also insert the file name and/or path. Finally you can select a defined cell to appear in the header/footer. Additionally there are a number of special opcodes for common options. These are:

&[TAB]: Name of the worksheet.
&[PAGE]: Page number in the printing.
&[PAGES]: Total number of pages in the printout.
&[DATE]: Current date in format dd-mmm-yyyy. The format can be changed by specifying the desired format in the opcode: &[DATE:yyyy/mm/dd].
&[TIME]: Current time in format hh:mm. The format can be changed by specifying the desired format in the opcode: &[TIME:hh:mm:ss].
&[FILE]: The basename of the file. For the file /home/jdoe/file.gnumeric, this opcode prints file.gnumeric.
&[PATH]: The path of the file excluding the basename. For the file /home/jdoe/file.gnumeric, this opcode prints /home/jdoe/.
&[CELL:$A$1]: The content of the cell $A$1 on the sheet being printed. Instead of $A$1 any other absolutely addressed cell may be used.
&[CELL:A1]: The content of the top left cell on the current page. Instead of A1 any other relative cell address may be used. This relative address is interpreted with respect to the top left cell on the current page. Any repeating rows or columns are ignored.
&[CELL:rep|A1]: The content of the top left cell on the current page. Instead of A1 any other relative cell address may be used. This relative address is interpreted with respect to the top left cell on the current page. Repeating rows or columns are not ignored. So if the top left cell is in a repeating row or column then the relative address is interpreted with respect to that cell.

TIP

You can choose the font in which the header and footer is printed by selecting a default header/footer font in the preferences (see in Section 13.2 ― General Preferences).

TIP

Double clicking on the header or footer preview will quickly allow you to customize that header or footer.