At 11:28 23/11/2007 -0500, Richard Detwiler wrote:
This is probably more venting that asking for help (but if anyone
has a solution, I'd be happy to hear it).
Two frustrations with Calc printing, one of which I thought had been
addressed in 2.3 but apparently not. (I'm running Windows XP btw.)
1. Take a Calc file with multiple sheets, with content in all of
them. With no print ranges defined, the default print range for each
sheet is that all of the content will be printed. That is how is
seems like it should be. The problem comes in if a print range is
defined in any ONE of the sheets. Now, there is no default range in
any of the sheets. That is, say I have a file with 12 sheets, and
I'm happy with the default range in 11 of them. I want a non-default
range in the 12th sheet. I define it in sheet 12. Now the only way
to print anything from sheets 1-11 is to manually define a print
range in each of them.
Anyone else is welcome to confirm (or refute) this. As I said, I
thought this had been changed in 2.3, but when I was working on a
Calc file this morning, I found out that it still seems to be an issue.
2. Take a Calc file with a sheet where I've defined the print range,
including specifying which rows to repeat at the top of each page. I
want to create copies of that sheet, to make modifications on. When
I copy that sheet, the copy has no print range defined, so it needs
to be manually defined again. Why wouldn't the print range in a
sheet carry over to a copy of that sheet?
Any words of wisdom on either of these points would be appreciated.
(Or just a confirmation that, yes this is so, and it's not just me.) Thanks.
I agree that this is how Calc behaves. (Like you, I have 2.3 on
Windows XP.) Copying a sheet shows the original print range outlined
on the copy at first, but it evidently doesn't take effect. And once
I've saved and reopened a file, this disappears - so at least
everything is consistent.
I can see the logic of whoever designed this behaviour, in fact: that
the print range is a property of the entire spreadsheet document and
not of individual sheets. Once you define a print range, anything
not included in the print range - including anything on other sheets
- is required not to be printed. This is despite the fact that print
ranges are *defined* on individual sheets. That understanding
doesn't make this behaviour necessarily convenient or welcome, of course.
There is a quick way of adding the entire contents of the other
sheets to the print range. In your example, click on the tab of
sheet 1 to select and display it. Then Ctrl+click on the tabs of the
other sheets 2 to 11 to select them as well. Or even more easily,
click on the tab of sheet 1 and then Ctrl+Shift+Page Down ten times
to add the other sheets to the selection. In either case, the
multiple-sheet selection is shown by the tabs of the selected sheets
being white instead of grey. Now that you have sheets 1 to 11
selected, click in the top left rectangle of the displayed sheet to
select the entire sheet (of all the selected sheets) and then go
(just once) to Format | Print Ranges > | Define. It might be even
simpler to do this for all sheets first, and then modify the range
for your exceptional sheet.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
