| <html> |
| <head> |
| <meta HTTP-EQUIV="content-type" CONTENT="text/html; charset=UTF-8"> |
| </head> |
| <body> |
| <h2 align="center"> </h2> |
| <h2 align="center"> </h2> |
| <h2 align="center"><B>How to set the Printing Settings</B></h2> |
| <h2 align="center"> </h2> |
| <p align="center"><i>provided by</i></p> |
| <p align="center"><i>the OpenOffice.org Documentation Project</i></p> |
| <P><BR> |
| </P> |
| <h3><B>Table of Contents</B></h3> |
| <ol> |
| <li><A HREF="#1">Printing a range</A></li> |
| <li><A HREF="#2">The Sheet Options</A></li> |
| <li><A HREF="#3">Printing a Sheet</A></li> |
| <li><A HREF="#4">Credits</A></li> |
| </ol> |
| <h3><A NAME="1"></A><B>1. Printing a range</B></h3> |
| <P>OpenOffice.org gives you the ability to print a selected zone of your |
| spreadsheet. To see how to perform this action:</P> |
| <UL> |
| <LI>Highlight the zone that you wish to print (it may be, for example, only |
| the result column, while you don't want to print the intermediate figures). |
| <LI>In the <B>Format </B>menu, select<b> 'Print Range'</b> and then '<B>Define</B>'. |
| <LI>Your range is now defined and you can see it highlighted in your sheet with |
| a thicker line. <!-- rh: GT, did this get translated? "voir matérialisée par des lignes d'un gris un peu plus foncé sur votre feuille." --> |
| <P><img src="zon1.gif" width="515" height="237" alt="zone 1"><BR CLEAR=LEFT> |
| In the page preview (<b>File-Page Preview</b>), you can verify that only |
| the selected columns and rows will be printed.</P> |
| <LI>You can add as many printing ranges as you wish, you need only to select |
| the new zone and under <B>Format-Print Range</B>, choose '<B>Add</B>'.<br> |
| Pay attention! Each zone will be printed on a separated page. |
| <LI>To verify (or modify) the zone you chose, select <B>Format-Print Range-Edit...</B> |
| <P><img src="zon2.gif" width="600" height="180" alt="zone 2"><BR CLEAR=LEFT> |
| The printing range selected is displayed in the first line called '<B>user |
| defined</B>'.</P> |
| <LI>The following two lines are related to rows or columns that you wish to |
| repeat while your zone is printed. You can: |
| <ul> |
| <li>either directly insert the cell references by hand,</li> |
| <li>or click the small icon you see to the right of the window, then |
| click and drag the mouse inside your sheet to select the zone you wish |
| to repeat.</li> |
| </ul> |
| </UL> |
| <h3><A NAME="2"></A><B>2. The Sheet Options</B></h3> |
| <P>The greater part of the printing options, for a sheet, are accessible with the menu |
| command, <B>Format -> Page</B> in the <B>Sheet </B>tab.</P> |
| <P><img src="sty5.gif" width="550" height="465" alt="Page Style Window"><BR CLEAR=LEFT> |
| </P> |
| <p>It's self-explanatory, except for the section, <b>Scale</b>, which is a bit |
| obscure: </p> |
| <ul> |
| <LI>'<b>Reduce/enlarge printout</b>' allows you to decrease or increase the |
| size of the print image of your sheet. |
| <LI>'<b>Fit printout on number of pages</b>' allows you to determine the exact |
| number of pages on which the spreadsheet will be printed. The size of the |
| sheets will be adjusted to fit that number. |
| </ul> |
| <P>You can access this window also from the Page Preview by clicking on |
| the last icon of the Toolbar. <img src="sty6.gif" width="24" height="20" alt="Page Style icon"></P> |
| <h3><A NAME="3"></A><B>3. Printing a Sheet</B></h3> |
| <P>A trick to print faster some particular sheets from a group or workbook (let's say the 2nd |
| and the 4th one):</P> |
| <UL> |
| <LI>click on the tab of the second sheet to select it, |
| <LI>while holding the <B>CTRL</B> key down, click on the 4th sheet. Both sheets |
| will be selected, |
| <LI>click on the<b> Print File directly </b>icon and, "hocus pocus", |
| the magic is done! |
| </UL> |
| <P><I><B>Note</B>: if you wish to insert the same |
| thing into different sheets, select them as you have just done for printing them, |
| then insert your data in the cell that you can see, and that insertion will be |
| repeated in all the sheets you have selected. (It's the power of a carbon copy on |
| your display!)</I></P> |
| <P>You can find other printing options by selecting <B>File-Print... </B>from |
| the Menu bar. If you click on the '<B>Options</B>' button, you'll have the possibility |
| to suppress the output of empty pages or to print only the selected sheets.</P> |
| <P>To display a break page preview before printing your sheet:</P> |
| <UL> |
| <LI>select <B>View -Break Page preview </B>from the menu bar. |
| <P><img src="pag1.gif" width="296" height="142"></P> |
| </UL> |
| <p>The sections that will be printed are highlighted with a blue border.</p> |
| |
| <h3><A NAME="4"></A><B>4. Credits</B></h3> |
| <p><b>Author</b>: Sophie Gautier</p> |
| <p><b>Translation</b>: Gianluca Turconi</p> |
| <p><b>Thanks</b>: Richard Holt, proofreader and OOo contributor</p><!-- Great is too much. :-)) --> |
| <p><b>Integration by</b>: Gianluca Turconi</p> |
| <p><b>Last modified</b>: February 24, 2002</p> |
| <p><b>Contacts</b>: <span>OpenOffice.org Documentation Project </span><a href="http://documentation.openoffice.org/index.html"><span>http://documentation.openoffice.org/index.html</span></a></p> |
| </BODY> |
| </html> |
