Brian:
Thanks again. I tried all your suggestions, but still couldn't
solve the problem. So when I print the third spreadsheet I
manually change the print page range from 1- 14 to the correct
1 - 10.
I have upgraded to a 4.n.n version in the past, but encountered
many problems. It was confirmed to be unstable on the Forum. So
I went back to 3.4.1. and have stuck with it so far.
Fred
On 11/27/14 9:12 PM, Brian Barker wrote:
At 17:32 27/11/2014 -0800, Fred Conly wrote:
I use Open Office Calc 3.4.1 with Win 7 Home Premium 64-bit.
It's probably well past time to upgrade.
I have three related ten-page spreadsheets where the third combines
data from the first and second. For an unknown reason the third has a
print range of 1 - 14 and of course those last 4 pages print blank. I
haven't been able to correct the print range to pages 1 - 10.
although it must be very simple. Can anyone suggest a solution?
This is a little confused - at least, to me. A spreadsheet is a
document, so do you mean that you have three separate document files?
In that case, I don't think the first two are relevant. Or do you mean
that your single spreadsheet document has three sheets?
Print ranges are not strictly defined as pages, I think, but as cell
ranges - as their name suggests. Any cell range will translate into a
number of pages, of course, when it is printed, but the actual pages
created will depend on other formatting details.
Oh, and it is not helpful to say you "haven't been able" to do
something, without doing the courtesy of saying what you have tried
and in what way it didn't work.
o You can delete a print range using Format | Print Ranges > | Remove.
Then you could reinstate the print range you really wanted using
Format | Print Ranges > | Define.
o Alternatively, you can examine the current print range using Format
| Print Ranges > | Edit... . You can edit the details in the Edit
Print Ranges dialogue. Alternatively, you can click the relevant
Shrink button in the Edit Print Ranges dialogue to display the cell
ranges included, which you can then modify as necessary.
Note that print ranges are define within individual sheets of a
spreadsheet, but take effect collectively on what is printed. So you
may have to examine all sheets of any spreadsheet separately to
discover what is happening. Note also that areas that appear empty on
any sheet may not be empty but contain either explicit blank
characters or formulae that evaluate to blank strings. Such areas will
be included in what is printed.
Depending on the exact details, a quick way around your problem may be
to tick the option at Tools | Options... | OpenOffice Calc | Print |
Pages | Suppress output of empty pages. You can also reach this option
on the fly in the Print dialogue.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
