[users] Printing large Calc sheet on 1 page?

2011-02-19 Thread .
Is there an easy and simple way to print a large Calc sheet, that
normally prints on 3 letter sized pages, on one page?

Only reply if you know how to do it. 



signature.asc
Description: OpenPGP digital signature


Re: [users] Printing large Calc sheet on 1 page?

2011-02-19 Thread Mike Scott

On 19/02/11 12:20, . wrote:

Is there an easy and simple way to print a large Calc sheet, that
normally prints on 3 letter sized pages, on one page?


Not afaik within OOo. IMBW.

However, you might consider saving the output as a postscript file, then 
using pstops or psnup to reposition the pages.




Only reply if you know how to do it.


Hmmmph. That comes over as somewhat lacking in grace. Good manners do 
not go amiss, even on a mailing list.



--
Mike Scott
Harlow, Essex, England

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



Re: [users] Printing large Calc sheet on 1 page?

2011-02-19 Thread Robert Jackson

On 19/02/2011 7:20 AM, . wrote:

Is there an easy and simple way to print a large Calc sheet, that
normally prints on 3 letter sized pages, on one page?

Only reply if you know how to do it.


File - Page Preview - Format Page
Select the Sheet tab
Change Scaling Mode to: Fit print range(s) to width/height
Set the width and height to 1

You may want to go to the Page tab and select the Landscape Orientation 
radio button.


You may want to expand the margins to get the output as large as possible.


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



Re: [users] Printing large Calc sheet on 1 page?

2011-02-19 Thread WANG, Xiaoyun
On Sat, Feb 19, 2011 at 8:20 PM, . pe...@aleksandrsolzhenitsyn.net wrote:
 Is there an easy and simple way to print a large Calc sheet, that
 normally prints on 3 letter sized pages, on one page?

 Only reply if you know how to do it.



Select the area you want to print in one page, then Format - Print
Ranges - Define.

-- 
WANG, Xiaoyun
Shanghai, China

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



Re: [users] Printing large Calc sheet on 1 page?

2011-02-19 Thread .


On 02/19/2011 10:48 AM, Robert Jackson wrote:
 On 19/02/2011 7:20 AM, . wrote:
 Is there an easy and simple way to print a large Calc sheet, that
 normally prints on 3 letter sized pages, on one page?

 Only reply if you know how to do it.

 File - Page Preview - Format Page
 Select the Sheet tab
 Change Scaling Mode to: Fit print range(s) to width/height
 Set the width and height to 1

 You may want to go to the Page tab and select the Landscape
 Orientation radio button.

 You may want to expand the margins to get the output as large as
 possible.


Just tried it- your method works.




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




signature.asc
Description: OpenPGP digital signature


Re: [users] Printing large Calc sheet on 1 page?

2011-02-19 Thread Johnny Rosenberg

Den 2011-02-19 13:20:01 skrev . pe...@aleksandrsolzhenitsyn.net:


Is there an easy and simple way to print a large Calc sheet, that
normally prints on 3 letter sized pages, on one page?


Format → Page… → Sheet (or whatever it says, ”Tabell” in Swedish anyway –  
the last tab)

or
Preview → Page format → Sheet


Only reply if you know how to do it.


Ok, do you mind if I use this thread to tell a funny story…?
Ok, I get it, I won't…

--
Kind regards

Johnny Rosenberg

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