On sheet 3 how is the merging of matching cells from sheets 1 and 2 expressed?
Is it a consolidation? What does the Consolidation dialog specify as the range On sheet 3? - Dennis PS: Also look up "print 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 on Combined Spreadsheet Dennis: Thanks. I have three 10-page spreadsheets of 67 Rows and A - O Columns each, with the contents of each cell of Sheet 3 a merging of the contents of the corresponding cells in Sheets 1 and 2. I forget what OO calls that. When I do Ctrl-P on Sheets 1 or 2, under "Thereof print" for Pages the entry is 1 - 10, but for Sheet 3 the entry is 1 - 14. The last cell to contain data in all three Sheets is Cell O632 of Page 10 in each Sheet. But I've searched Sheet 3 and all the cells in pages 11 and below are empty. Furthermore, I've done a Delete Row for all the rows in these pages. So the only way I've found to avoid printing 4 blank pages with Sheet 3 is to manually change the Pages field from 14 to 10 each time I Print. It's a small thing and I thought surely it must have an easy solution. 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 > > Dennis: > Thanks, but is there a step missing? > Fred > > On 11/29/14 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 of the sheet such that all used >> cells are included in the rectangular grid having that A1 and that as >> corners. >> >> >From there, you can start deleting rows or columns as necessary to shrink >> >that grid back to one that just includes the necessary cells and excludes >> >blank strays. >> >> This is better than setting print area because that often ends up excluding >> information when changes are made or, as seems to be the case here, there >> 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 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 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 >> >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org >> For additional commands, e-mail: users-h...@openoffice.apache.org >> >> > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org > For additional commands, e-mail: users-h...@openoffice.apache.org > > --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
