On Fri, 28 Nov 2014 12:16:37 -0800 FC <fc...@cox.net> 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 version in the past, but encountered > many problems. It was confirmed to be unstable on the Forum. So > I went back to 3.4.1. and have stuck with it so far. > Fred
OO 4.1.1 seems to be sensitive to the exact combination of software and hardware om a Windows 8.x computer. It varies from computer to computer; without access to the many individual computers it is impossible to diagnose. On linux it is much more stable. > > On 11/27/14 9:12 PM, Brian Barker wrote: > > 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 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 that you have three separate document files? > > In that case, I don't think the first two are relevant. Or do you mean > > that your single spreadsheet document has three sheets? > > > > Print ranges are not strictly defined as pages, I think, but as cell > > ranges - as their name suggests. Any cell range will translate into a > > number of pages, of course, when it is printed, but the actual pages > > created will depend on other formatting details. > > > > Oh, and it is not helpful to say you "haven't been able" to do > > something, without doing the courtesy of saying what you have tried > > and in what way it didn't work. > > > > o You can delete a print range using Format | Print Ranges > | Remove. > > Then you could reinstate the print range you really wanted using > > Format | Print Ranges > | Define. > > > > o Alternatively, you can examine the current print range using Format > > | Print Ranges > | Edit... . You can edit the details in the Edit > > Print Ranges dialogue. Alternatively, you can click the relevant > > Shrink button in the Edit Print Ranges dialogue to display the cell > > ranges included, which you can then modify as necessary. > > > > Note that print ranges are define within individual sheets of a > > spreadsheet, but take effect collectively on what is printed. So you > > may have to examine all sheets of any spreadsheet separately to > > discover what is happening. 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. > > > > Depending on the exact details, a quick way around your problem may be > > to tick the option at Tools | Options... | OpenOffice Calc | Print | > > Pages | Suppress output of empty pages. You can also reach this option > > on the fly in the Print dialogue. > > > > 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 > > > > > -- Rory O'Farrell <ofarr...@iol.ie> --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
