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
I just tried this and have to agree with Brian.
Andy
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org
