Printing Only the Sheets and Pages You Want, in OpenOffice.org Calc

this post and this post on printing spreadsheets.

You're going along, minding your own business, doing your spreadsheet. You print. Ten minutes later the irate printer guy comes along, saying "Would you mind not printing 200 pages at once????"

You're irritated since you just....well, you just MEANT to print the current sheet which has three pages.

But when you click Print or choose File > Print and don't modify this in any way, you print the WHOLE spreadsheet. Possibly including blank pages.

There are several ways to change this.

To print only the current sheet by default and prevent any blank pages from printing:

Choose Tools > Options > OpenOffice.org Calc > Print.

Select both options shown. Click OK. Now only the current sheet will print, and no blank pages will be printed.

To do this on the fly for each time you print.
Choose File > Print, click Options, then set the options in the options window that appears. This will make the change only for the current print job.

To select more than one sheet to print:
Click on the first sheet you want to print. Then hold down Ctrl and select any other sheet(s).

Or for contiguous sheets, click on the first sheet you want to print. Then hold down Shift and select the last sheet you want to print.

---

---

Comments

[stig hackvan]

I've been experimenting every which way to suppress extra sheets when I'm printing and making PDFs, but all I manage to do is waste time and get lots of extra blank pages (i've gotten as far as hiding cells when printing).

I'm using OOO 2.2.1 on linux and win2k and I have checked both boxes in the tools>options>calc>print dialog as you've suggested.

AND STILL, i get the second sheet that I don't want to print.

Naturally, I _expect_ whatever I have to do to suppress those extra pages to also keep them out of exported PDFs.

And, why-o-why is there not an options tab for PDF options? (I have discovered through trial and error that the toolbar button uses whatever PDF settings were last used from the menu option, but that's a pretty obtuse interface...)

Why are PDFs on linux larger than on win2k? (type 1 fonts are not subsetted, for starters...running the files through ps2pdf subsets those fonts and gets the files to roughly the same size as pdfs generated from windows...)

Why isn't the PDF options dialog able to estimate final file size? And why does it have to be after the filename dialog, where it's harder to find?

PDF exporting is great, but boy-oh-boy do I suffer for it...

[stig hackvan]

Upon further experimentation, it seems that fiddling with Format>Print Ranges for the two sheets achieved what I wanted...the ability to print/export one sheet but not the other.

Print ranges on both sheets: both get printed/exported regardless of tools>options>oocalc>print settings.

Print ranges on neither sheet: same as above, options setting has no effect.

print range defined on one sheet but not the other: print/export is only the defined print range.

[jack]

http://www.batterygoshop.co.uk/batterycharger/delta/delta-19v-2.64a-50w-4.8mm-1.7mm.htm delta 19V 2.64A 50w 4.8mm*1.7mm adapter laptop ,

[wow power leveling]

http://www.gamegoldme.com/
http://www.wowgold-powerleveling.com/
http://www.wowgold-wow.com/
http://www.wowpowerleveling.me
http://www.watchrolexshop.com
http://www.wowgold-wow.com/wow-power-leveling
http://rs-runescapegold.com/
http://www.watchrolexshop.com/wow-power-leveling/
http://www.cheap-lotrogold.com/
http://www.globalsale.me/Aion-gold-083.aspx
http://www.cheap-gamegold.org
http://www.gamegoldvip.org
http://www.globalsale.me/