Calc: Printing Options
By default, Calc prints all sheets and all pages, including empty pages. After selecting File | Print, the user can choose to suppress the output of empty pages and/or print only the selected sheets by clicking "Options..."
The default values for these options can be set under the menu item "Tools | Options | OpenOffice Calc | Print". The corresponding configuration settings are located in org.openoffice.Office.Calc/Print.
To change the default to suppress the output of empty pages:
In org.openoffice.Office.Calc/Print/Page
set EmptyPages to False
To change the default to print only selected sheets:
In org.openoffice.Office.Calc/Print/Other
set AllSheets to False