Determines the printer settings for spreadsheets.
Tools - Options - Office Calc - Print defines the settings for all spreadsheets. To define settings for the current document only, choose File - Print, then click the Options button.
To access this command...
Choose Tools - Options - Office Calc - Print.
Pages
Always apply manual breaks
Setting this option gives manual row breaks precedence over automatic page breaks done using the Reduce/enlarge printout scaling mode.
Suppress output of empty pages
Specifies that empty pages that have no cell contents or draw objects are not printed. Cell attributes such as borders or background colours are not considered cell contents. Empty pages are not counted for page numbering.
Sheets
Print only selected sheets
Specifies that only contents from selected sheets are printed, even if you specify a wider range in the File - Print dialogue box or in the Format - Print Ranges dialogue box. Contents from sheets that are not selected will not be printed.
To select multiple sheets, click on the sheet names on the bottom margin of the workspace while keeping the Ctrl key pressed.