Printing an Open Office Calc (Spreadsheet) onto one page
(This blog was written for versions of OpenOffice up to Version 3.4.0)
If you have an Open Office Calc document that extends over one page and you would like to print it on one page this will make it possible.
With the Calc document open -
Format > Page > Sheet tab > Scale > Scaling Mode > Fit print range(s) to width/height > Set the width to 1 and height to 1 > Click OK
This can be done whether the page is in Portrait or Landscape Orientation. Suggest expanding the page margrins to get the output as large as possible when starting the project .