At 12:16 28/11/2014 -0800, Fred Conly wrote:
I tried all your suggestions, but still couldn't solve the
problem. So when I print the third spreadsheet I manually change
the print page range from 1- 14 to the correct
1 - 10.
In my earlier message I'd assumed that by "print range" you meant
what Calc calls a print range - a cell range or set of cell ranges
that defines which cells will form part of the printed output and
which will be suppressed. But I now see that you mean that when you
go to print the document, you are offered in the Print dialogue more
pages than you expect and that those extra pages are empty. That's
different: sorry for the confusion.
But one of my comments transpires nevertheless to have been apposite, I think:
Note also that areas that appear empty on any sheet may not be empty
but contain either explicit blank characters or formulae that
evaluate to blank strings. Such areas will be included in what is printed.
Surely you must just have some significant cell or cells that Calc
assumes that you want printed some way beyond the last part that you
do? This might be visible in your spreadsheet or it may be that the
significant data is just blank spaces - so not visibly different from
an empty cell. But Calc will think that you put those blanks there
because you wanted that cell printed.
If you cannot find the rogue cell or cells, you may want to replace
any confidential information with nonsense text and send the
spreadsheet (still showing the problem) to someone to investigate.
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
