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]
