A print range is exactly what it sounds like: a selection of cells that you want to print. Then, when you want to print, you can either select Data > Select Range or else select the named range from the Navigator floating window when you press F5.īy contrast, a print range is saved with the file. This method works well for one-time printing, but if you want the option of printing the same selection in different sessions, use Data > Define Range to create a named range. If necessary, you can use the Format menu to hide cells, columns, and rows as you need, or else press the Ctrl key when selecting cells to print non-adjacent cells. In most other cases, rows and columns are cut off, separating information that you want to keep together, and making pagination haphazard at best.Ī more satisfactory choice is to select what you want by highlighting it with a mouse. The problem with this choice, as you can quickly learn if you haven't already, is that it is almost never satisfactory without careful calculations of width, and, even then, only when the number of rows per page is irrelevant. Many people choose the least complicated, and do nothing. Assuming that you have no outsized cells, with the same paper, you'll have 50-55 rows. For instance, if you are printing to US Letter size page with a portrait orientation and a one inch margin on every side, you'll have 6.5 inches for column widths. In each of these cases, you may want to keep track of the total column width and the number of rows likely to be printed on each page.
OPENOFFICE COLUMNS ON PART OF PAGE MANUAL
When you print from Calc, you have several options for selecting the contents: doing nothing, printing a selection, setting up a print range, or adding manual row and column breaks.
None of these tools is useful on every occasion, and you may have to mix and match them to get the results you want, but, the more you know about them, the less of a nightmare printing a spreadsheet becomes. How you setup pages for printing and the printer or export options are also part of the arsenal. However, although page styles are one of the most useful tools for the task, they are far from the only ones.
OPENOFFICE COLUMNS ON PART OF PAGE HOW TO
In part 1 of this entry, I discussed how to use Calc's page styles to control how spreadsheets print.
0 kommentar(er)
