Print Range on Combined Spreadsheet.

2014-11-27 Thread FC
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't be

Re: Print Range on Combined Spreadsheet

2014-11-27 Thread Brian Barker
At 17:32 27/11/2014 -0800, Fred Conly wrote: I use 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 print r

Re: Print Range on Combined Spreadsheet

2014-11-28 Thread FC
Brian: Thanks again. 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. I have upgraded to a 4.n.n version in the past, but encountered many problems. It was c

Re: Print Range on Combined Spreadsheet

2014-11-28 Thread Rory O'Farrell
On Fri, 28 Nov 2014 12:16:37 -0800 FC wrote: > Brian: > Thanks again. 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. > I have upgraded to a 4.n.n v

Re: Print Range on Combined Spreadsheet

2014-11-28 Thread Brian Barker
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 w

RE: Print Range on Combined Spreadsheet

2014-11-29 Thread Dennis E. Hamilton
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

Re: Print Range on Combined Spreadsheet

2014-11-29 Thread Jim McLaughlin
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

Re: Print Range on Combined Spreadsheet

2014-11-29 Thread FC
: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

RE: Print Range on Combined Spreadsheet

2014-11-29 Thread Dennis E. Hamilton
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

Re: Print Range on Combined Spreadsheet

2014-11-29 Thread FC
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

RE: Print Range on Combined Spreadsheet

2014-11-29 Thread Dennis E. Hamilton
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

Re: Print Range on Combined Spreadsheet

2014-11-29 Thread Brian Barker
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

Re: Print Range on Combined Spreadsheet

2014-11-30 Thread FC
Fred On 11/29/14 4:49 PM, Dennis 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 De