G. Roderick Singleton wrote:
On Sun, 2006-03-05 at 16:22 -0800, Gil Weber wrote:
I am trying to print 1 (one) page. That is the entire spread sheet.
Can not get the printer settings to print it in landscape. Have tried
about everything it says under format and printer selection. It wants
to take 4 pages to print and the font is too large. Have change the
font size but still does not change the print font size. Hope some
one can give me the answer. Thanks in advance for your help. Gil
Weber
Try selecting only the cells that contain the data you wish to print.
You are on the right track by setting the printer to landscape and I
will guess that you have also changed the page settings to landscape as
well. using Format > Page. Selecting the cells you want printed is
called a range. For details see Help > Contents > Index > Search term >
print area selection and you might find that the section in the user
guide near or at page 240 entitled "Printing or Exporting Spreadsheets"
useful. You can get the guide from
http://documentation.openoffice.org/manuals/index.html
Some further comments:
Changing the font size is usually not the best way to make a spreadsheet
fit.
Go to File -> Page Preview. See what's wrong. Click on "Page" in the
toolbar. In the tab "Sheet" you will find a setting called "Scaling
Factor". There is an option in the "Scaling Factor" drop down box to
"Print range(s) on number of pages". If you select this then to the
right will appear options to set the number of horizontal pages and
vertical pages to 1 each.
This will *force* your printout to one page, regardless of the amount of
data you are printing. The rest is making it look good.
Click OK. If not satisfied with the appearance in the preview, you can
again click on "Page" and in the "Page" tab also set narrower margins to
somewhat increase the size of the characters.
Getting back to the spreadsheet itself, it often helps with wide
spreadsheets to set the font to something like "Arial Narrow" or
"Helvetica Condensed". A condensed/narrow typeface gets more columns
into the same area for the height of the font.
When you get it right in the Page Preview, it should print the same on
your printer.
Jallan
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
