Why does Calc print out all the sheets in the file?
From Apache OpenOffice Wiki
< Documentation | FAQ | Calc | Printing
Why does Calc print out all the sheets in the file?
By default, Calc is configured to do just that [not in 2.4 nor 3.0rc2 (though I wish it was)]. This setting can be changed so that only the current sheet is printed:
- Select File - Print from the main menu
- Click Options
- Check the box Print only selected sheets for Document
To make the change permanent for all occurrences of OpenOffice.org Calc:
- Select Tools - Options from the main menu
- Select OpenOffice.org Calc - Print and check the box Print only selected sheets for Document
In OpenOffice.org 1.1.x, the entry is called Spreadsheets instead of OpenOffice.org Calc.