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 where C is a sum of the cells in A and B. Obviously, > an accounting of two departments combined in a third. > The print ranges in A and B are ok, printing pages 1 -10. > But, for some unknown reason the C spreadsheet wants to > print pages 1 - 14, i.e., 4 phantom blank pages. No big > deal, but pesky. I've tried deleting rows below the data > and columns to the right of the data but to no avail. > Do you have any suggestions for eliminating the 4 > blank sheets in C?
Try this: Under the "View" menu, set "Page Break Preview" In the lower right corner, set the scale factor small enough that you can see the whole thing, or a large part of it. Blank pages will show if they are intermixed with printed ones, but you may also see something else. In particular, something "barely" on the page, or something way out of the row/column range you expected. If documents A and B are ten vertical pages (as opposed to a matrix such as 5 x 2), check them to be sure there is nothing that shows more than the 10 pages. Then check the same for C. Also, in the Tools / Options dialog, make sure OpenOffice Calc / Print has "Suppress output of empty pages" and "Print only selected sheets" set Gary --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
