ast sheet then I would try
explicitly defining the print ranges for each sheet. I think that would be
done by defining the range on the first sheet, selecting the range on the
second sheet and use the "Format > Print Ranges > Add" menu command to add
that print range, then repeat f
Hi Fred,
On 07/28/15 21:53, FC wrote:
> Attention: Alan.
>
> Since you were so helpful to me in helping to solve the
> extra blank page printed on my one-page spreadsheet perhaps
> you have a suggestion on another one.
> I have three linked spreadsheets, A, B, and C, of ten pages
> each
Attention: Alan.
Since you were so helpful to me in helping to solve the
extra blank page printed on my one-page spreadsheet perhaps
you have a suggestion on another one.
I have three linked spreadsheets, A, B, and C, of ten pages
each where C is a sum of the cells in A and B. Obviously
On Tue, Jul 28, 2015 at 8:02 PM, FC 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.
e 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).
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 so
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 be
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
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
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
area selection" in the Calc Help. On each of your
sheets,
Select Format | Print Ranges | Edit to see if there are any settings there.
-Original Message-
From: FC [mailto:fc...@cox.net]
Sent: Saturday, November 29, 2014 17:33
To: users@openoffice.apache.org
Subject: Re: Print Range o
At 17:32 29/11/2014 -0800, Fred Conly wrote:
It's a small thing and I thought surely it must have an easy solution.
It does: it's just that you haven't found it.
o Make a copy of the spreadsheet to work with.
o Remove material or replace it with insignificant text piecemeal.
One obvious firs
int Ranges | Edit to see if there are any settings there.
-Original Message-
From: FC [mailto:fc...@cox.net]
Sent: Saturday, November 29, 2014 17:33
To: users@openoffice.apache.org
Subject: Re: Print Range on Combined Spreadsheet
Dennis:
Thanks. I have three 10-page spreadsheets of 6
nnis E. Hamilton wrote:
Um, I think cell A1 must be selected. Is that what you mean?
-Original Message-
From: FC [mailto:fc...@cox.net]
Sent: Saturday, November 29, 2014 15:41
To: users@openoffice.apache.org
Subject: Re: Print Range on Combined Spreadsheet
Dennis:
Thanks, but is there
Um, I think cell A1 must be selected. Is that what you mean?
-Original Message-
From: FC [mailto:fc...@cox.net]
Sent: Saturday, November 29, 2014 15:41
To: users@openoffice.apache.org
Subject: Re: Print Range on Combined Spreadsheet
Dennis:
Thanks, but is there a step missing
:17
To: users@openoffice.apache.org
Subject: Re: Print Range on Combined Spreadsheet
At 12:16 28/11/2014 -0800, Fred Conly wrote:
[ ... ]
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 cont
Dennis -
Thank you.
That is an "elegant" solution to the problem posted.
On Sat, Nov 29, 2014 at 7:33 AM, Dennis E. Hamilton wrote:
> Open the problematic sheet in Calc.
>
> With the cursor initially in cell A1, Click Ctrl-End on your keyboard.
> This will move to the lower-right corner cell o
e may
be inconsistency in handling multiple sheets in the Calc document.
- Dennis
-Original Message-
From: Brian Barker [mailto:b.m.bar...@btinternet.com]
Sent: Friday, November 28, 2014 21:17
To: users@openoffice.apache.org
Subject: Re: Print Range on Combined Spreadsheet
At 12:16 2
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 r
Open Office Calc 3.4.1 with Win 7 Home Premium 64-bit.
> >
> > It's probably well past time to upgrade.
> >
> >> I have three related ten-page spreadsheets where the third combines
> >> data from the first and second. For an unknown reason the third has a
> &g
pgrade.
I have three related ten-page spreadsheets where the third combines
data from the first and second. For an unknown reason the third has a
print range of 1 - 14 and of course those last 4 pages print blank. I
haven't been able to correct the print range to pages 1 - 10.
although
print range of 1 - 14 and of course those last 4 pages print
blank. I haven't been able to correct the print range to pages 1 -
10. although it must be very simple. Can anyone suggest a solution?
This is a little confused - at least, to me. A spreadsheet is a
document, so do you mean tha
I use Open Office Calc 3.4.1 with Win 7 Home
Premium 64-bit.
I have three related ten-page spreadsheets where
the third combines data from the first and second.
For an unknown reason the third has a print range
of 1 - 14 and of course those last 4 pages print blank.
I haven&#
23 matches
Mail list logo
