OT: OpenOffice 1.1.3 Calc - Print to fit

[James Pifer]

I'm now using Fedora Core 3 full time on my workstation. I'm trying to
use openoffice calc for things I used to do in Excel. I have some
spreadsheets that work fine in calc for the most part, but I'm having
trouble with printing. I have a specific spreadsheet that used to print
with Excel using fit to page. When I try this on calc, it doesn't fit it
to the page. 

I go to:
File/Page Preview
Click Page Format
Select Fit printout on number of pages = 1
Click ok

I can see right in the preview that it isn't fitting it to the page. 

I tried to scale it and select a percentage that fits, but it doesn't
look or print very well. Plus I don't want to have to do that with every
spreadsheet. 

Any suggestions?

Thanks,
James