Re: [users] Landscape & portrait format in one file

2009-03-10 Thread JOE Conner

Steven Palubinski wrote:


At one time it was possible to print multiple worksheets from a calc 
file (perhaps in Excel) with some in landscape and some in portrait 
format. Now, it appears, the format selection effects all worksheets - 
it's an either/or proposition. There are time-consuming work arounds, 
but what I need is a way to print 10 worksheets, some in landscape and 
some in portrait, and format the worksheets once only.


Thank You.
Steve
Attached is a Calc file with both portrait and landscape style formatted 
sheets.

You can save a template from it.

Joe Conner, Poulsbo, WA USA


CALC_Landscape_Template.ots
Description: application/vnd.oasis.opendocument.spreadsheet-template
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] Landscape & portrait format in one file

2009-03-09 Thread Jean Hollis Weber

Steven Palubinski wrote:
At one time it was possible to print multiple worksheets from a calc 
file (perhaps in Excel) with some in landscape and some in portrait 
format. Now, it appears, the format selection effects all worksheets - 
it's an either/or proposition. There are time-consuming work arounds, 
but what I need is a way to print 10 worksheets, some in landscape and 
some in portrait, and format the worksheets once only.


Calc's page styles should do what you want. Format one page style (for 
example, Default) as landscape and another page style (for example, 
Report) and assign the appropriate style to each worksheet.


I don't have a printer handy to test this, but it works that way when 
exporting to PDF.


--Jean
Jean Hollis Weber
Co-Lead, Documentation Project

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org



Re: [users] Landscape & portrait format in one file

2009-03-09 Thread John Jason Jordan
On Sun, 08 Mar 2009 14:42:42 +0430
Steven Palubinski  dijo:

> 
> At one time it was possible to print multiple worksheets from a calc 
> file (perhaps in Excel) with some in landscape and some in portrait 
> format. Now, it appears, the format selection effects all worksheets - 
> it's an either/or proposition. There are time-consuming work arounds, 
> but what I need is a way to print 10 worksheets, some in landscape and 
> some in portrait, and format the worksheets once only.

I never use Calc, so I'm not sure if this is a limitation of Calc. But
I can mix portrait and landscape pages in Writer. The trick is to
create a page style for the landscape page where you set the page
dimensions the way they need to be for a landscape page. Then apply
this page style to any page that you want landscape.

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org



[users] Landscape & portrait format in one file

2009-03-09 Thread Steven Palubinski


At one time it was possible to print multiple worksheets from a calc 
file (perhaps in Excel) with some in landscape and some in portrait 
format. Now, it appears, the format selection effects all worksheets - 
it's an either/or proposition. There are time-consuming work arounds, 
but what I need is a way to print 10 worksheets, some in landscape and 
some in portrait, and format the worksheets once only.


Thank You.
Steve

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org