Printing Spreadsheets

From NeoWiki

(Difference between revisions)
Jump to: navigation, search
Revision as of 12:55, 7 January 2008 (edit)
Jgd (Talk | contribs)
(some tips about printing a Calc document)
← Previous diff		 Current revision (09:54, 10 January 2008) (edit) (undo)
Jgd (Talk | contribs)
(add printing Grid, Column and Row Headers)
 
(2 intermediate revisions not shown.)
Line 1: Line 1:
-In a Writer document, each page on screen is printed on one page of paper, but a Calc document can contain several sheets, and each sheet can be bigger than a sheet of paper. You may want also print only a part of the document or of a sheet. Thus, you have to set up the printing options.<br>+In a Writer document, each page on the screen is printed on one page of paper, but a Calc document can contain several sheets, and each sheet can be bigger than a sheet of paper. You may want also print only a part of the document or of a sheet. To do so, you have to set up the printing options.<br>
To adjust some of these options and to see the output, you need to use the '''Page Preview'''. To adjust some of these options and to see the output, you need to use the '''Page Preview'''.
Line 5: Line 5:
*Go to the {{menu|File}} menu and choose {{menu|Page Preview}}. *Go to the {{menu|File}} menu and choose {{menu|Page Preview}}.
*In the window that opens, you can see the whole document by using the browsing buttons in the '''Page Preview''' toolbar. *In the window that opens, you can see the whole document by using the browsing buttons in the '''Page Preview''' toolbar.
-*Click on the {{button|Format Page}} button, the {{window|Page Style: Default}} window opens.+*Click on the {{button|Format Page}} button; the {{window|Page Style: Default}} window opens.
*Click on the various tabs to access to some formatting options: orientation, borders, background, header, footer, scale, etc. *Click on the various tabs to access to some formatting options: orientation, borders, background, header, footer, scale, etc.
*Close the '''Page Preview''' by clicking on the {{button|Close Preview}} button. *Close the '''Page Preview''' by clicking on the {{button|Close Preview}} button.
Line 13: Line 13:
*Blue lines show the page breaks. You can move a blue line with the mouse to set the page break to a new position. *Blue lines show the page breaks. You can move a blue line with the mouse to set the page break to a new position.
*To return to the usual display of the sheet, go to the {{menu|View}} menu and click on {{menu|Normal}}. *To return to the usual display of the sheet, go to the {{menu|View}} menu and click on {{menu|Normal}}.
 +
 +You can also insert manual column or row breaks, either in '''Normal View''' or in '''Page Break Preview'''. To do that:
 +*Select a column, a row or a cell.
 +*Go to the {{menu|Insert}} menu and {{menu|Manual Break}} sub-menu, then choose {{menu|Column Break}} or {{menu|Row Break}}.
 +*A thin light blue line appears to the left of the selected column, or above the selected row. These lines show new page breaks. In the '''Page Break Preview''', they are light blue while the page breaks created by NeoOffice are dark blue.
===Printing selected sheets=== ===Printing selected sheets===
Line 20: Line 25:
*In the {{window|Printer Options}} window, check the {{prefName|Print only selected sheets}} box and click {{button|OK}}. *In the {{window|Printer Options}} window, check the {{prefName|Print only selected sheets}} box and click {{button|OK}}.
*You can set that option as the default option for all print jobs, by choosing {{menu|NeoOffice}}, then {{menu|Preferences…}}, {{section|NeoOffice Calc}} and {{prefName|Print}}. *You can set that option as the default option for all print jobs, by choosing {{menu|NeoOffice}}, then {{menu|Preferences…}}, {{section|NeoOffice Calc}} and {{prefName|Print}}.
 +
 +===Printing Grid, Column and Row Headers===
 +*Go to the {{menu|Format}} menu, choose {{menu|Page…}}.
 +*In the {{window|Page Style: Default}} window which opens, click on the {{prefName|Sheet}} tab.
 +*In the {{section|Print}} section, check the desired options: Column and row headers, Grid.
 +*:You can also print notes, formulas, etc. by checking the appropriate boxes.
===Printing only a Range of Cells=== ===Printing only a Range of Cells===
Line 32: Line 43:
#*Go to the {{menu|File}} menu and click on {{menu|Print…}}, or press {{key|Command-P}}. #*Go to the {{menu|File}} menu and click on {{menu|Print…}}, or press {{key|Command-P}}.
#*In the {{window|Printing Selection}} dialog which appears (after the {{window|Printer Options}} window), click on {{button|Selection}}. #*In the {{window|Printing Selection}} dialog which appears (after the {{window|Printer Options}} window), click on {{button|Selection}}.
-#'''Hiding the non printable cells'''+#'''Hiding the cells that are not to be printed'''
#*Select the rows and the columns to be hidden. #*Select the rows and the columns to be hidden.
#*Right-click or Control-click on the headers of these rows or columns. #*Right-click or Control-click on the headers of these rows or columns.
#*In the contextual menu, click on {{prefName|Hide}}. #*In the contextual menu, click on {{prefName|Hide}}.
-#*To show again these rows and columns, select the whole sheet by pressing {{key|Command-A}}, and choose {{menu|Format}} then {{menu|Row}} or {{menu|Column}} and {{menu|Show}}.+#*To show these rows and columns again, select the whole sheet by pressing {{key|Command-A}}, and choose {{menu|Format}} then {{menu|Row}} or {{menu|Column}} and {{menu|Show}}.
In each case, the '''Page Preview''' allows you to verify that only the selected ranges will be printed. In each case, the '''Page Preview''' allows you to verify that only the selected ranges will be printed.
Line 48: Line 59:
===Setting the Page Scale=== ===Setting the Page Scale===
-If your sheet is small and you want it occupies a larger part of the page, use the following method : +If your sheet is small and you want it to occupy a larger part of the page, use the following method :
*Go to the {{menu|File}} menu and click on {{menu|Preview}}. *Go to the {{menu|File}} menu and click on {{menu|Preview}}.
*Click on the {{button|Format page}} button. *Click on the {{button|Format page}} button.
Line 59: Line 70:
*Go to the {{menu|Format}} menu, choose {{menu|Page…}}. *Go to the {{menu|Format}} menu, choose {{menu|Page…}}.
*In the {{prefName|Sheet}} tab, in the {{section|Scaling mode}}, choose {{prefName|Fit print range(s) to width/height}}, and set the width and height in pages in the appropriate fields, as you wish. *In the {{prefName|Sheet}} tab, in the {{section|Scaling mode}}, choose {{prefName|Fit print range(s) to width/height}}, and set the width and height in pages in the appropriate fields, as you wish.
-**If your document contains many rows, set the '''Height in pages''' to a great value.+**If your document contains many rows, set the '''Height in pages''' to a large value.
*Click {{button|OK}}. *Click {{button|OK}}.
{{botlangbarEN|[[Fr:Imprimer un Document Calc|Français]]}} {{botlangbarEN|[[Fr:Imprimer un Document Calc|Français]]}}
[[Category:Tips and Hints]][[Category:NeoOffice]] [[Category:Tips and Hints]][[Category:NeoOffice]]

Current revision

In a Writer document, each page on the screen is printed on one page of paper, but a Calc document can contain several sheets, and each sheet can be bigger than a sheet of paper. You may want also print only a part of the document or of a sheet. To do so, you have to set up the printing options.
To adjust some of these options and to see the output, you need to use the Page Preview.

Contents

Using the Page Preview

  • Go to the File menu and choose Page Preview.
  • In the window that opens, you can see the whole document by using the browsing buttons in the Page Preview toolbar.
  • Click on the Format Page button; the Page Style: Default window opens.
  • Click on the various tabs to access to some formatting options: orientation, borders, background, header, footer, scale, etc.
  • Close the Page Preview by clicking on the Close Preview button.

Setting the Page Breaks

  • Choose the View menu, then select Page Break Preview.
  • Blue lines show the page breaks. You can move a blue line with the mouse to set the page break to a new position.
  • To return to the usual display of the sheet, go to the View menu and click on Normal.

You can also insert manual column or row breaks, either in Normal View or in Page Break Preview. To do that:

  • Select a column, a row or a cell.
  • Go to the Insert menu and Manual Break sub-menu, then choose Column Break or Row Break.
  • A thin light blue line appears to the left of the selected column, or above the selected row. These lines show new page breaks. In the Page Break Preview, they are light blue while the page breaks created by NeoOffice are dark blue.

Printing selected sheets

  • Select the sheets you want to print by clicking on their tabs while holding the Command key.
  • Go to the File menu and click on Print…, or press Command-P.
  • In the window that appears you can choose your printer and set up some options. Click Print.
  • In the Printer Options window, check the Print only selected sheets box and click OK.
  • You can set that option as the default option for all print jobs, by choosing NeoOffice, then Preferences…, NeoOffice Calc and Print.

Printing Grid, Column and Row Headers

  • Go to the Format menu, choose Page….
  • In the Page Style: Default window which opens, click on the Sheet tab.
  • In the Print section, check the desired options: Column and row headers, Grid.
    You can also print notes, formulas, etc. by checking the appropriate boxes.

Printing only a Range of Cells

Several methods are available:

  1. Defining a print range
    • Select the range you want to print, e.g. a part of a table or a chart.
    • Go to the Format menu and choose Print Ranges, then Define.
    • To add other print ranges, select them, go to the Format menu and choose Print Ranges, then Add.
    You can also select the print range(s) in the Page Break Preview, then right-click or Ctrl-click on the selection and choose Define Print Range or Add Print Range in the contextual menu.
  2. Select a part of the sheet
    • Select the range you want to print.
    • Go to the File menu and click on Print…, or press Command-P.
    • In the Printing Selection dialog which appears (after the Printer Options window), click on Selection.
  3. Hiding the cells that are not to be printed
    • Select the rows and the columns to be hidden.
    • Right-click or Control-click on the headers of these rows or columns.
    • In the contextual menu, click on Hide.
    • To show these rows and columns again, select the whole sheet by pressing Command-A, and choose Format then Row or Column and Show.

In each case, the Page Preview allows you to verify that only the selected ranges will be printed.

Centering a Table or a Chart on a Page

  • Select the table or the chart.
  • Go to the Format menu, choose Page….
  • Click on the Page tab.
  • In the Layout settings, check Horizontal or Vertical (you can check both of them). A little preview area allows you to see the print output.
  • Click OK.

Setting the Page Scale

If your sheet is small and you want it to occupy a larger part of the page, use the following method :

  • Go to the File menu and click on Preview.
  • Click on the Format page button.
  • In the window that opens, click on the Sheet tab.
  • Increase the scaling percentage.
  • Click OK.
  • Repeat this step until you get the size you want.

Limiting the Number of Pages to Print

  • Go to the Format menu, choose Page….
  • In the Sheet tab, in the Scaling mode, choose Fit print range(s) to width/height, and set the width and height in pages in the appropriate fields, as you wish.
    • If your document contains many rows, set the Height in pages to a large value.
  • Click OK.


This article in other languages: Français
Retrieved from "https://neowiki.neooffice.org/index.php/Printing_Spreadsheets"
Personal tools