The Print Setup Dialog can be used to configure various options related to printing out a workbook. Click on File Menu->Print Setup to activate the Print Setup.
![]() | TIP |
---|---|
Remember that at any time you can click on the Print preview button to see what your document looks like with your selected options. See the Section 11.3 |
Select portrait or landscape to suit the best layout for your document.
Change the scale your image to fit it to your page size suitably. The scaling can both enlarge and diminish the size of your printed document.
The Fit to option is not available yet.
Adjust the margins by clicking on the arrow buttons for each margin. You will see the preview pane follow your changes.
You may set the margin to be measured in centimetres, millimetres, points or inches.
Click on the option menu to choose from a range of different header and footer styles. Customize the header or footer by choosing the last option on the menu.
![]() | TIP |
---|---|
Double clicking on the header or footer preview will quickly allow you to customize that header or footer. |
Enter what text you would like to appear in the header or footer. There are a number of special opcodes for common options. These are:
Name of the workbook.
Page number in the printing.
Total number of pages in the printout.
Current date.
Current time.
You can select row or column titles to print by clicking in the expr-entry widget and selecting the rows or columns with the mouse.
Select Grid lines to print the cell grid lines with your document. Unselect the button to hide the grid lines from your print output.
Select Black and white to convert the colours in your document to a greyscale range.
Select Styles with no content to ensure cells with style changes will be printed, even if they are empty. For example, if you have a number of cells with the background color changed but no data in them, you can select this option to ensure they are in the printed output.