Why does Calc print out all the sheets in the file?

From Apache OpenOffice Wiki
< Documentation‎ | FAQ‎ | Calc‎ | Printing
Jump to: navigation, search


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:

  1. Select File - Print from the main menu
  2. Click Options
  3. Check the box Print only selected sheets for Document

To make the change permanent for all occurrences of OpenOffice.org Calc:

  1. Select Tools - Options from the main menu
  2. 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.


Personal tools