OpenOfficeSpreadSheetPrinting

To scale the printed cells to the paper go to:

File -> Page Preview

Click on "Page" on the toolbar, select the "Sheet" tab and select the following scaling mode: "Fit print rages to width/height"