On 03/01/2008 01:49 AM, Lindsay Graham wrote: > Thanks again, Brian. What you say is all true, but that is a very > non-intuitive (in fact, downright confusing) approach AND it is > necessary to know how many pages there are in either the first or > second sheet, and how is one expected to establish that? If there > are several sheets, it becomes quite a non-trivial task to work out > which particular numbers to put into the Print dialog box. > > I've just tested it with another Calc file which has 7 sheets. Calc > says it has 289 pages in total. If I wanted to print just Sheet 3, > how would I go about working which page numbers to specify, without > laboriously going through the Page Preview screens to work out how > many pages precede Sheet 3, and how many pages there are in Sheet 3? > > The more I look into this problem, the more ridiculous I think the > Calc approach is. Unless I'm missing some simple solution -- I hope? > > > Lindsay Graham
It is no different than Excel. You define the print ranges, print preview shows you the print ranges on all sheets. Calc is showing you 289 pages because that is what you defined in your print range. Unless you actually have 289 pages, select only those sections on the sheets that you want printed. Example (pages being defined print ranges) & this is pretty much what Brian has told you: Sheet 1 has 2 pages (1-2) Sheet 2 has 12 pages (3-14) Sheet 3 has 3 pages (15-17) Total = 17 pages Now I want to print at one time: Page 2 of sheet 1 Page 4 of sheet 2 Page 2 & 3 of sheet 3 Click on Page Preview icon & note the page numbers for the 'print ranges'. File|Print|Print/All sheets|Print range/Pages - 2,6,16-17 If I only want to print page 4 of Sheet 2, then I select the Sheet 2 tab, then I can easily view which is page 4 of that Sheet by: View|Page Break Preview - just to be sure it's the right one. Then File|Print|Print/Selected sheets|Print range/Pages - 4 Page Preview and Page Break Preview are different tools. The first shows you all print _ranges_ and allows you to easily modify the pages settings for any of those _ranges_. The second shows you page breaks for the sheet that you are working with. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
