At 13:14 08/01/2011 -0800, Brewster Gillett wrote:
I have scoured the OOHelp files for an answer and cannot come up
with one. Is it even possible to print out a Calc spreadsheet in double-space?
First, it's not generally helpful to think of doing anything
"double-space". This is typewriter thinking, where the hardware
allows you to print lines only at well-regulated intervals. Computer
printers are more flexible than that, and it is better to think of
output from a word processor or spreadsheet as having additional
spacing between lines or paragraphs or whatever. But no: I think you
are right that there is no immediately obvious way to increase the
spacing between rows of values. That probably makes sense, since if
you are printing a grid you are unlikely to want space between
neighbouring rows of the grid.
There are many ways, though, of achieving what you probably want:
1. Put your spreadsheet values in alternate rows.
2. Increase the row height without changing the text size:
o Go to Format | Row > | Height... (or right-click in the row
headers | Row Height...) and increase the value there.
o You may then wish to move the values to somewhere other than the
(default) bottom of the cells (e.g. Middle), at Format | Cells... |
Alignment | Text alignment | Vertical (or right-click | Format
Cells... | Alignment | Text alignment | Vertical).
3. Increase the spacing above or below (or both) the text in your cells:
o Go to Format | Cells... | Borders | Spacing to contents (or
right-click | Format Cells... | Borders | Spacing to contents).
o Untick Synchronize.
o Increase the values for Top or Bottom (or both).
I suggest technique no. 3 is probably the most flexible.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
