Hi Brian
I picked up your name from a mail to other OO users and will be grateful if
you are able to assist with my problem.
In Excel you are able to have a number of different spreadsheets open and
display them side by side using the Arrange commend which is found on the
Windows tab. This enables you to copy and paste data between the sheets with
ease. Does OO have a similar feature.
Many thanks
Dave Bridges
-----Original Message-----
From: Brian Barker
Sent: Monday, July 27, 2015 11:26 PM
To: users@openoffice.apache.org
Subject: Re: Print Range
At 11:35 27/07/2015 -0700, Fred Char wrote:
I use Open Office Calc 3.4.1 with Win 7 Home Premium 64-bit. I have a very
simple one-page spreadsheet, but the software wants to print out this sheet
plus a second sheet which is blank. I know I can set the print range
manually each time I print it, but I would like to avoid this step
permanently.
Can some kind person suggest how I can correct this apparently simple but
very pesky problem?
Possibly not: you have the evidence in front of you but anyone
reading your message doesn't. It becomes something of a guessing game.
Surely the fact has to be that you have something - but we cannot
tell what - beyond the range of cells that you intend to use and
print. Possibilities are:
o cells containing blank strings - as distinct from genuinely empty cells
o cells formatted to show contents in the same colour as the
background - and therefore not show them
o cells containing formulae - even if these evaluate to a null string
o non-empty cells in hidden rows or columns
You will be able to identify the rows or columns that are being
included inappropriately in the default print range. If you delete
those rows or columns (so that they are replaced by genuinely empty
ones), won't the problem go away?
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
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
