If I change the Page format (Format >> Page >> Page(tab) to landscape my sheets all print in landscape layout. I tried this both on Windows XP and Linux (Gentoo) using OOo 2.0.1. What OS are you using?Rick: I have just spent 1/2 hour attempting to get my spreadsheet to print a landscape depict. Have changed and tried most everything I could get my hands on. Frequently, things greyed out when I did make the changes, of course.
I am quite experienced with Excel...and although it is a slightly different way of doing things I have mastered it. OOo must cater to the ways of differing OSes (Solaris, Windows, MacOS and Linux) so many times there is a compromise. OOo's Page styles, however, are just a different way to do things...which needs to be accepted and learned if you are an Excel user.Guess what I am thinking, and attempting to say, is that a computer newbie or even an experienced Windows Excell user will have problems making it work.
The OOo help explains this well look under the topic "Spreadsheets >> Printing >> Printing Sheets in Landscape Format"
Here is a copy:
"In order to print a sheet you have a number of interactive options available under View - Page Break Preview. Drag the delimiter lines to define the range of printed cells on each page.
To print in landscape format, proceed as follows:
- Go to the sheet to be printed.
- Choose Format - Page.
The command is not visible if the sheet has been opened with write protection on. In that case, click the Edit File icon on the Standard bar. - Select the Page tab. Select the Landscape paper format and click OK.
- Choose File - Print. You will see the Print dialog.
Depending on the printer driver and the operating system, it may be necessary to click the Properties button and to change your printer to landscape format there. - In the Print dialog under Print range, select the pages to be printed:
All - All sheets will be printed.
Pages - Enter the pages to be printed. The pages will also be numbered from the first sheet onwards. If you see in the Page Break Preview that Sheet1 will be printed on 4 pages and you want to print the first two pages of Sheet2, enter 5-6 here.
Selection - Only the selection will be printed. If cells are selected, these are printed. If no cells are selected, all those sheets whose names (at the bottom on the sheet tabs) are selected will be printed. By pressing Ctrl while clicking a sheet name you can change this selection.
Maybe it's your printer setup or driver? You may want to see if there is any better help for your situation on the OOoForums, http://www.oooforum.org/I can get it to change to an 11.0 x 8.5 presentation but then cannot get anything on the page, let alone print. Not impressed to say the least.
-- Regards, Rick Barnes www.nostabo.net Read my blog: http://www.nostabo.net/blog/index.php ******************************************************************* PRIVILEGED - PRIVATE AND CONFIDENTIAL This electronic mail is solely for the use of the addressee and may contain information which is confidential or privileged. If you receive this electronic mail in error, please delete it from your system immediately and notify the sender by electronic mail or using any of the contact details noted herein. This e-mail sent via Evolution 2.4.1 running on a Linux 2.6.15 64 bit kernel. |
signature.asc
Description: This is a digitally signed message part
