On 28-Jul-15 07:26, Brian Barker wrote:
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
Go to File --> Page Preview
Select Format Page and the Sheet tab, tick the Grid option and press OK
Now you can see what the last Column and Row is that is printed, this
cell could be a non empty cell as Brian suggested.
Couple of things you can do.
Just delete all rows and columns that you don't need.
or Close Preview (don't forget to undo the Grid option) and Define a
print range under Format --> Print Ranges
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
