On 16/09/10 18:16, Brian Barker wrote:
At 17:54 16/09/2010 +0100, Aonly Gonly wrote:
In OOo3.1 Calc (Debian Lenny), I have copied a spreadsheet created in
Calc over to a new sheet within the same workbook. These are the
same in every respect. When I go to page-break preview the copied
sheet is all greyed out - the text and numbers are visible, but the
background is greyed. When I then print preview it, there is no
display. If I print preview the copied sheet without first
page-break previewing it, again there is no display. The original
first sheet however can both page-break preview and print preview
just fine.
To experiment, I copied over the same sheet into a new workbook and
now it all works as expected. However, I want to keep this contained
within one workbook and work on one while keeping the original
unchanged as a control. But, given the above description I don't
trust this to work reliably unless I know how to correct it.
Interestingly enough, when I repeated the above procedure in the new
workbook, the sheets all page-break and print preview as expected.
What would be helpful, if possible, is:
(a) understanding why this happened in the first workbook but not in
the second, and
(b) how can I fix this without taking the chance that it won't happen
if I copy the sheets into a new workbook?
Can anyone help me to figure this out, because in Excel I can do this
with impunity, but apparently not in Calc.
I suspect this is easy to explain: you have a print range defined on
the first sheet. When you copy the sheet, the print range definition
is not carried over.
In the first case, you end up with a print range defined on the first
sheet but not on the second. When you have any print range defined
anywhere in a Calc spreadsheet, only material within a print range is
printed. So your second sheet, without any print range defined, fails
to print at all. Perhaps you expect that a print range affects only
material on the sheet on which it is defined, and that other sheets in
the same spreadsheet will print fully, but this is not so.
In the second case, when you copy the material into a new spreadsheet,
it does not matter that the pasted material is not in a print range
because - so far, at least - you have not defined a print range
anywhere in that new spreadsheet.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
Brian
As per your suggestion I adjusted the print range for the copied sheet
and all turned out fine. The print and page-break previews display as
expected.
As ever, thanks.
Best
AG
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
