[opensuse] Open Office speadsheet question
Hi all, I have a speadsheet that is too wide to print. When I print it Oo uses three sheets of paper. Is there a way to turn the speadsheet just for printing? Thanks, JIM -- Jim Hatridge Linux User #88484 Ebay ID: WartHogBulletin ------------------------------------------------------ WartHog Bulletin Info about new German Stamps http://www.WartHogBulletin.de Many Enemies -- Much Honor! Anti-US Propaganda stamp collection http://www.manyenemies-muchhonor.info An American in Bavaria http://www.gaubodengalerie.de -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
On January 3, 2009 09:25:34 am James Hatridge wrote:
Hi all,
I have a speadsheet that is too wide to print. When I print it Oo uses three sheets of paper. Is there a way to turn the speadsheet just for printing?
Format->Page? -- Don -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
On Saturday 03 January 2009 17:43:36 Don Raboud wrote:
On January 3, 2009 09:25:34 am James Hatridge wrote:
Hi all,
I have a speadsheet that is too wide to print. When I print it Oo uses three sheets of paper. Is there a way to turn the speadsheet just for printing?
Format->Page?
Copy and paste it into a new landscape formatted text document and format it from there. No one I've ever asked can give me a way of doing it. Everyone thinks that they can until you ask them to show you and they loose 20 sheets of paper each time they try! Happy new year L x -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Saturday, 2009-01-03 at 18:13 +0100, lynn wrote:
Copy and paste it into a new landscape formatted text document and format it from there. No one I've ever asked can give me a way of doing it. Everyone thinks that they can until you ask them to show you and they loose 20 sheets of paper each time they try!
In the view menu there is an option to view what it will be printed. I surrounds the cells to be printed with a blue border, and leaves the outside grayed. When it's going to be printed into several pages, each one is marked with a dashed blue border, and the page number is overlaid in big numbers in the center of each. You can resize or move the print area, and what will each page print (in all sheets), till you have the result you want. For example, you can change the font used for cells to make them smaller and fit the page. No need to waste paper!
Happy new year L x
same to you :-) - -- Cheers, Carlos E. R. -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.9 (GNU/Linux) iEYEARECAAYFAklfuvoACgkQtTMYHG2NR9WL/QCfQsEzO7j8ceLwugFArT9wzHMs LIwAnRnMWEE+ABQ75l6fs9xzoZ8IabEg =5+rF -----END PGP SIGNATURE----- -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
On Saturday 03 January 2009 20:22:30 Carlos E. R. wrote:
On Saturday, 2009-01-03 at 18:13 +0100, lynn wrote:
Copy and paste it into a new landscape formatted text document and format it from there. No one I've ever asked can give me a way of doing it. Everyone thinks that they can until you ask them to show you and they loose 20 sheets of paper each time they try!
In the view menu there is an option to view what it will be printed. I surrounds the cells to be printed with a blue border, and leaves the outside grayed. When it's going to be printed into several pages, each one is marked with a dashed blue border, and the page number is overlaid in big numbers in the center of each. You can resize or move the print area, and what will each page print (in all sheets), till you have the result you want. For example, you can change the font used for cells to make them smaller and fit the page.
No need to waste paper!
Happy new year L x
same to you :-)
-- Cheers, Carlos E. R.
I don't believe you. It's too easy. Que maravilla. L x -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Sunday, 2009-01-04 at 08:22 +0100, lynn wrote:
No need to waste paper!
Happy new year L x
same to you :-)
I don't believe you. It's too easy. Que maravilla.
X'-) Old dog knows many tricks ;-) One thing you'll notice, if you start adjusting the pages till they fit in one sheet of paper, is that you will need lenses to read the now fine print ;-P - -- Cheers, Carlos E. R. -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.9 (GNU/Linux) iEYEARECAAYFAklgmkEACgkQtTMYHG2NR9UEbgCeOnFmnD1GTMtvn65QvGgLiTp2 iaYAn1r4SMj7gDioB9/nGOrpbVNeosah =yYpm -----END PGP SIGNATURE----- -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
On Sunday 04 January 2009 12:15:11 Carlos E. R. wrote:
On Sunday, 2009-01-04 at 08:22 +0100, lynn wrote:
No need to waste paper!
Happy new year L x
same to you :-)
I don't believe you. It's too easy. Que maravilla.
X'-)
Old dog knows many tricks ;-)
One thing you'll notice, if you start adjusting the pages till they fit in one sheet of paper, is that you will need lenses to read the now fine print ;-P
-- Cheers, Carlos E. R.
Carlos hombre, can you have a look at my nfs wifi thread. It's the cheapo dragonet connection from carrefour which no one will answer qns. on. The one you buy on the shelf and take to the checkout. Besos, L xx -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
On Saturday 03 January 2009, James Hatridge wrote:
Hi all,
I have a speadsheet that is too wide to print. When I print it Oo uses three sheets of paper. Is there a way to turn the speadsheet just for printing?
To print in landscape mode from OpenOffice Calc: 1) Go to the "Format" menu in Calc and select "Page..." 2) In the dialog box that opens, select the "Page" tab. 3) Under "Orientation, select "Landscape." 4) Click the "OK" button. 5) Print HTH -- JAY VOLLMER -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
HI all! Thanks, this was it! JIM On Saturday 03 January 2009 19:20:47 Jay C Vollmer wrote:
On Saturday 03 January 2009, James Hatridge wrote:
Hi all,
I have a speadsheet that is too wide to print. When I print it Oo uses three sheets of paper. Is there a way to turn the speadsheet just for printing?
To print in landscape mode from OpenOffice Calc:
1) Go to the "Format" menu in Calc and select "Page..." 2) In the dialog box that opens, select the "Page" tab. 3) Under "Orientation, select "Landscape." 4) Click the "OK" button. 5) Print
HTH
-- JAY VOLLMER
-- Jim Hatridge Linux User #88484 Ebay ID: WartHogBulletin ------------------------------------------------------ WartHog Bulletin Info about new German Stamps http://www.WartHogBulletin.de Many Enemies -- Much Honor! Anti-US Propaganda stamp collection http://www.manyenemies-muchhonor.info An American in Bavaria http://www.gaubodengalerie.de -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
If you are not trying to reformat the spreadsheet, pull up Print (ctrl-p). Open up properties to the right of the printer. Under the Paper tab, you will find Orientation. Select either Portrait or Landscape. Barry -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
On Saturday 03 January 2009 16:25:34 James Hatridge wrote:
Hi all,
I have a speadsheet that is too wide to print. When I print it Oo uses three sheets of paper. Is there a way to turn the speadsheet just for printing?
Thanks,
JIM
Hi Jim, Try Format -> Page Choose the "Sheet" tab Select the "Fit print range(s) to fit width/height" option. -- Kind Regards, Ritchie ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Ritchie Fraser Web: http://www.rpfraser.uklinux.net Registered Linux User #255860 -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
Ritchie Fraser pecked at the keyboard and wrote:
On Saturday 03 January 2009 16:25:34 James Hatridge wrote:
Hi all,
I have a speadsheet that is too wide to print. When I print it Oo uses three sheets of paper. Is there a way to turn the speadsheet just for printing?
Thanks,
JIM
Hi Jim,
Try Format -> Page Choose the "Sheet" tab Select the "Fit print range(s) to fit width/height" option.
Or simply select the correct orientation and have it fit on one sheet. -- Ken Schneider SuSe since Version 5.2, June 1998 -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
On Monday 05 January 2009 04:21:59 Ken Schneider wrote:
Ritchie Fraser pecked at the keyboard and wrote:
On Saturday 03 January 2009 16:25:34 James Hatridge wrote:
Hi all,
I have a speadsheet that is too wide to print. When I print it Oo uses three sheets of paper. Is there a way to turn the speadsheet just for printing?
Thanks,
JIM
Hi Jim,
Try Format -> Page Choose the "Sheet" tab Select the "Fit print range(s) to fit width/height" option.
Or simply select the correct orientation and have it fit on one sheet.
Or both the above if it's too wide to fit naturally on landscape ;-) -- Kind Regards, Ritchie ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Ritchie Fraser Web: http://www.rpfraser.uklinux.net Registered Linux User #255860 -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
participants (8)
-
Barry Premeaux -
Carlos E. R. -
Don Raboud -
James Hatridge -
Jay C Vollmer -
Ken Schneider -
lynn -
Ritchie Fraser