Print Range.

[FC <fc...@cox.net>]

     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?

     Fred

Re: Print Range.

[Alan B <ab...@gmail.com>]

On Mon, Jul 27, 2015 at 2:35 PM, FC <fc...@cox.net> wrote:

>     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 some kind person suggest how I can correct this apparently
> simple but very pesky problem?
>

Fred I've had similar problems and have frustrations with Calc's printing
as a result. My solution to unwanted blank pages has been to do the
following...
- delete any empty sheets in the workbook
- go to the last data column then select the column to the right to the
last column in the sheet and delete the columns
- go to the last data row then select the row below to the last row in the
sheet and delete the rows
- clear the print range if any is set
- save the spreadsheet

Phantom pages are no long printed.

Don't know what is going on but suspect there is some value or attribute,
visible or not, in the deleted sheets/columns/rows that's causing Calc to
print the extra page(s).

Re: Print Range

[Dave Bridges <it...@polka.co.za>]

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-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org 


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org

Re: Print Range

[Martin Groenescheij <Ma...@Groenescheij.COM>]

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: users-unsubscribe@openoffice.apache.org
> For additional commands, e-mail: users-help@openoffice.apache.org
>
>


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org

Re: Print Range

[Brian Barker <b....@btinternet.com>]

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-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org

Re: Print Range.

[Alan B <ab...@gmail.com>]

On Tue, Jul 28, 2015 at 8:02 PM, FC <fc...@cox.net> wrote:

> Alan:
>     Thank you so much for the prompt, polite, and helpful
> solution to my simple pesky problem.
>     Thanks again for your relevant and spot-on help.
>     Fred


Thanks for your kind words Fred. You're welcome. Glad I could help.

Re: Print Range.

[FC <fc...@cox.net>]

Alan:
     Thank you so much for the prompt, polite, and helpful
solution to my simple pesky problem.
      I had forgotten that OO prints sheet one and then sheet
two /just to the right of sheet one /and sure enough, guess
what, there was a number 1, yes just the single digit 1, in
one of the cells of the sheet just to the right of my so-
called on-sheet spreadsheet.
     Problem solved.
     Thanks again for your relevant and spot-on help.
     Fred


On 07/28/15 5:14 AM, Alan B wrote:
> On Mon, Jul 27, 2015 at 2:35 PM, FC <fc...@cox.net> wrote:
>
>>      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 some kind person suggest how I can correct this apparently
>> simple but very pesky problem?
>>
> Fred I've had similar problems and have frustrations with Calc's printing
> as a result. My solution to unwanted blank pages has been to do the
> following...
> - delete any empty sheets in the workbook
> - go to the last data column then select the column to the right to the
> last column in the sheet and delete the columns
> - go to the last data row then select the row below to the last row in the
> sheet and delete the rows
> - clear the print range if any is set
> - save the spreadsheet
>
> Phantom pages are no long printed.
>
> Don't know what is going on but suspect there is some value or attribute,
> visible or not, in the deleted sheets/columns/rows that's causing Calc to
> print the extra page(s).
>