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. 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. In part 1 of this entry, I discussed how to use Calc's page styles to control how spreadsheets print.
0 Comments
Leave a Reply. |