Short bio: Computer Scientist, FOSS supporter (read more)
Tux Machines (TM)-specific
In part 1 of this entry, I discussed how to use Calc's page styles to control how spreadsheets print. However, although page styles are one of the most useful tools for the task, they are far from the only ones. How you setup pages for printing and the printer or export options are also part of the arsenal. 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.
Selecting what to print
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. 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. 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. Assuming that you have no outsized cells, with the same paper, you'll have 50-55 rows.
Many people choose the least complicated, and do nothing.