Brian Barker skrev: > At 14:43 15/09/2008 +0800, James Elliott wrote: >> I have a Calc 2.4 spreadsheet set of accounts which needs to print out >> in landscape mode to fit on one page. Below the set of accounts I >> have a "key" which is a 2-column list of what the codes and >> abbreviations stand for, which will also fit on one page (page2) if >> printed in portrait format. If the key list prints out in landscape, >> like the set of accounts above it, it takes two pages to accommodate >> the 2-column list. However, if the key can be printed in portrait >> mode, then it fits on one page. >> >> So, my question is: how can I print page 1 (spreadsheet) in landscape, >> and page 2 (key list) in portrait? > > That depends on whether your pages are parts of the same sheet: it is > important to distinguish here between sheets and pages (oh, and > spreadsheets). > > Strangely, I think it is not possible to print different pages from the > same sheet of a single spreadsheet with different orientations. > Orientation is a property of page style, and it appears that all pages > from a single sheet (in the same printing operation) must have the same > page style. There seem to be two solutions: one quick and messy, the > other neater: > > o You can print the pages from a single sheet separately. Set the page > orientation to landscape and print the first page. Now set the page > orientation to portrait and print your second page. Once you have made > this change, what constitutes the first page will have changed, of > course, so you will probably need to adjust the page breaks in order for > the correct range to appear on the second page. You may be able to > simplify this by inserting a row break (the equivalent of a page break) > at an appropriate point. But anyway, the sure way to complete this > adjustment is to go to View | Page Break Preview and then to drag the > page boundaries around until what you need is on a single page and can > be selectively printed. > > o A better way is simply to move the different sections of your > document to different sheets (within the same spreadsheet). Create > separate page styles - with different orientations - for the different > sections and apply these to the separate sheets. You can now print the > complete document in one go but with the orientations you require. This > way, by creating sufficient separate sheets within a single spreadsheet, > you can create whatever appearance you need, of course. > > I trust this helps. > > Brian Barker > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > >
Hi list, - sorry for opening this *old* thread again, but the info presented here is very valuable! - I applied the "better way" as lined out in the second paragraph. Works fine. - now, I'd like to have this pagestyle ready to use in other documents too, in fact, I'd like it to be globally accessible for all users in the setup (being openSuSE11.1/LTSP with 6 users, all using the same base installation of OO). How can I do that? As always...Thank You! - -- ------------------------------ Med venlig hilsen/Best regards Verner Kjærsgaard --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
