----- Original Message -----
From: "NoOp" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Sunday, March 02, 2008 8:15 AM
Subject: [users] Re: PRINTING FROM MULTI-SHEET CALC FILE
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.
Sorry, "NoOp", but it is very different from Excel.
In the document referred to above, I have no print ranges defined (I do use
print ranges, but only when I need them -- in most documents, I have no use
for them). Calc shows 289 pages because that is the total number of pages
that would be produced if all 7 sheets were printed (which, in my
experience, is a very unlikely requirement). To print just Sheet 3, it is,
as I said above, a non-trivial task to work out what page numbers to
print -- in Excel, all one has to do is hit the Print button when in the
sheet that one wants to print.
To make things worse, I now find that putting "Page #/##" into a Calc header
means that # and ## are worked out according to the page numbers and total
page numbers in the *document*, whereas Excel works them out according to
the *sheet* in which one is working. I cannot see the advantage of the Calc
approach, but maybe it will come to me <g>. But it is essential for my
purposes to be able to define # and ## by reference to the current sheet --
can that be done in Calc?
Trying to use Page Break Preview in Calc has just added to my confusion. If
I'm in Sheet 3 of 7, *Page Preview* says that the first page of that sheet
is Page 204 and the Header shows "Page 204/289", which is what I would have
expected in Calc. But *Page Break Preview* says that the first page is Page
1!! Why the inconsistency?
I would not expect to ever want to print pages from several different sheets
in the manner you've suggested, but I can see that it might be useful for
some people. But when I go to File > Print, I don't see any options
"Print/Selected sheets" or "Print/All sheets" -- I think my equivalent is is
to go to File > Print > Options... and check or uncheck "Print only selected
sheets". Is that what you are referring to?
Thanks again, in anticipation, for your help.
Lindsay Graham
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
