Language Selection

English French German Italian Portuguese Spanish

Printing in OpenOffice.org Calc, Part 2: Print selection and printer options

Filed under
HowTos

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.

Full Story.

More in Tux Machines

Review: Linux Mint 17.2 Release is Refreshed and Faster

Linux Mint 17.2 "Rafaela" MATE was launched last week and, as usual, I installed it on my machines to see how this distro is progressing. I found a refreshed, faster and more feature-rich distro that's well worth trying. Read more

Samsung to train India’s Telangana youth in Tizen Tech

As part of the spread of Tizen education in India, Samsung will train the youth of the Telangana Academy on innovative digital technologies based on the Tizen operating system. Read more

Jolla cuts hardware biz loose to concentrate on Sailfish licensing

Hardware and software outfit Jolla is to give up making hardware, with that part of the business set to be taken on by a new, yet-to-be-announced company, with Jolla then concentrating on its Sailfish OS. Read more

Linus Torvalds Says Valve Is Exploring a "Second Source" Against Microsoft

The father of the Linux project, Linus Torvalds, talked about Valve and its potential role in the Linux ecosystem with the upcoming gaming consoles. Read more