Printing in OpenOffice.org Calc, Part 2: Print selection and printer options
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. 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. In most other cases, rows and columns are cut off, separating information that you want to keep together, and making pagination haphazard at best.
A more satisfactory choice is to select what you want by highlighting it with a mouse. 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. 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. 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.
By contrast, a print range is saved with the file. A print range is exactly what it sounds like: a selection of cells that you want to print. Print ranges are defined from the Format > Print Ranges sub-menu. Use the Define item to create a print range of adjacent cells, and Add to select other cells for the print range, including non-adjacent ones, and Edit to define the repeating headers on each page -- a touch that makes the printout much more usable.
The fourth method, manual page breaks, shares the precision of defining a print range. By selecting Insert > Manual Break, and selecting either a row or a column break, you have the power to determine exactly where you want pages to end and start. The first time, some people may be confused by when to choose a row or a column break, but, after the first few efforts, they can usually catch on. The major drawback to manual page breaks is that, in a long document, they can be laborious and time-consuming to insert, and require frequent use of Page Preview to keep you on track. The effort is really only worth your while if you plan on printing the spreadsheet regularly.
Column and row breaks are marked by blue lines on the right (for a column) or the top (for a row) of a line of cells. However, this indicator can be easy to miss in a complex spreadsheet -- it might as well be as invisible as a print range. Should you be feeling lost, you can view both breaks and print ranges by selecting the incompletely named View > Page Break Preview. When you are finished, select View > Normal to return to the usual display of the sheet.
Selecting printer options
When you select File > Print to print, or File > Export to PDF, you can set options for printing. These options are mostly routine, but some special considerations apply when you are printing spreadsheets:
- If you are printing a manual selection or a print range, be sure that you choose Print range >Selection or Pages > Selection in the Export to PDF window. Otherwise, the print range is overridden, and the point of defining one is lost.
- If you only want to print only some sheets, select them before opening the printing or export windows. Press the Ctrl key to make multiple selections. When you open the Print window, select Options > Sheets > Print Only Selected Sheets to limit what is printed. Note that, by default, all sheets in the spreadsheet are printed.
- Options > Pages > Suppress output of empty pages prevents the printing of any page that does not include cell contents or objects. Formatting options such as a background graphic or a colored border do not count as contents.
- You may want to change the paper orientation for the printer so that no rows or columns are cut off. Use File > Page Preview to decide if a change is needed.
Putting it all together
Readying a Calc page for printing or exporting requires 3 steps:
- Create and apply page styles to control how printing is done.
- Select what to print using the methods described in part 2 of this entry.
- Set the printer options or the export options.
In many cases, you might want to skip one of these steps. After all, spreadsheet printing is hardly an exact science. However, if you include all of them, you increase the chance of printing the spreadsheet correctly -- if not the first time, then maybe the second and third.
Bruce Byfield is a computer journalist who writes primarily for the Linux Journal and NewsForge sites.
Bruce Byfield (nanday)
Practical Task Scheduling Deployment
July 20, 2016 12:00 pm CDT
One of the best things about the UNIX environment (aside from being stable and efficient) is the vast array of software tools available to help you do your job. Traditionally, a UNIX tool does only one thing, but does that one thing very well. For example, grep is very easy to use and can search vast amounts of data quickly. The find tool can find a particular file or files based on all kinds of criteria. It's pretty easy to string these tools together to build even more powerful tools, such as a tool that finds all of the .log files in the /home directory and searches each one for a particular entry. This erector-set mentality allows UNIX system administrators to seem to always have the right tool for the job.
Cron traditionally has been considered another such a tool for job scheduling, but is it enough? This webinar considers that very question. The first part builds on a previous Geek Guide, Beyond Cron, and briefly describes how to know when it might be time to consider upgrading your job scheduling infrastructure. The second part presents an actual planning and implementation framework.
Join Linux Journal's Mike Diehl and Pat Cameron of Help Systems.
Free to Linux Journal readers.Register Now!
- SUSE LLC's SUSE Manager
- My +1 Sword of Productivity
- Murat Yener and Onur Dundar's Expert Android Studio (Wrox)
- Managing Linux Using Puppet
- Non-Linux FOSS: Caffeine!
- SuperTuxKart 0.9.2 Released
- Doing for User Space What We Did for Kernel Space
- Google's SwiftShader Released
- Parsing an RSS News Feed with a Bash Script
- SourceClear Open
With all the industry talk about the benefits of Linux on Power and all the performance advantages offered by its open architecture, you may be considering a move in that direction. If you are thinking about analytics, big data and cloud computing, you would be right to evaluate Power. The idea of using commodity x86 hardware and replacing it every three years is an outdated cost model. It doesn’t consider the total cost of ownership, and it doesn’t consider the advantage of real processing power, high-availability and multithreading like a demon.
This ebook takes a look at some of the practical applications of the Linux on Power platform and ways you might bring all the performance power of this open architecture to bear for your organization. There are no smoke and mirrors here—just hard, cold, empirical evidence provided by independent sources. I also consider some innovative ways Linux on Power will be used in the future.Get the Guide