> 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?
Brian Barker wrote: > 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. brewster: I sort of knew all that, but considered it of somewhat more academic than practical interest :-) barker: > 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. brewster: But as it happens, that is *exactly* what I want. A blank line, every other row, demarcated by the half-tone grid I prefer. IOW a space in which to manually add new data as it arises, for later transcription. barker: > There are many ways, though, of achieving what you probably want: > > 1. Put your spreadsheet values in alternate rows. brewster: That would have the exact effect I seek, but doing it reminds me so much of using a goose nib and an inkwell that I have a difficult time accepting it as a solution :-) barker: > 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). brewster: I considered that, but realized that I would not have the grid separation I prefer. barker: > 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. brewster: Perhaps but in my 3.2 under Ubuntu 10.4 it refuses to even lift its wheels off the runway. The increased values are not retained - system goes back to the default values as if the changes were never made. And of course it labors under the same deficiency as No. 2 - I didn't especially want a double-sized row - I wanted two separated rows - i.e. a blank row every other one. I imagine I'll probably settle on No. 2 in the event - even though I will find the result a trifle sloppier than I would like :-) Going back and manually inserting a row after every existing row, as in No. 1, doesn't even bear thinking about..... Thanks for your help. Brewster -- *********************************************************************** Embrace a sharing community of sustainable justice low-carbon diversity *********************************************************************** W. Brewster Gillett [email protected] Portland, OR USA *********************************************************************** Simply because you don't like to hear it, that doesn't make it untrue. *********************************************************************** --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
