On Mon, 2006-03-13 at 09:21 -0800, Joe Conner wrote: > Print ranges have "DEFINE", "EDIT" and "ADD" commands. For the second > page, when you define > its print range use "ADD" then you have what you are asking for.
What you've described is more intuitive, but I've found in practise that DEFINE applies only to the current sheet, i.e. does not cancel the ranges set for other sheets, and ADD extends the range/s of the current sheet. This is probably a good thing to avoid accidents. I.e. The sheets are independent, just not quite as independent as RLShadow would like. ADD will work, but is just like a DEFINE for the first range in a sheet. A couple of things that RLShadow can do to perhaps make it easier:- - change all other sheets in one hit to print the entire sheet. Select those sheets by Ctrl+clicking on each sheet tab to add to the selection, or Shift+Click to select a range, and then Format - Print Ranges - Edit to set the range to - entire sheet - in the list box at the left. This affects all selected sheets at the same time. Then Ctrl+click to deselect sheets (I tried clicking on one sheet to deselect all others but this doesn't work - i.e. is not quite the same as multi-select in other contexts for some reason). - set up a template sheet within the spreadsheet and use Format - Print Ranges - Edit to set the range to - entire sheet - in the list box at the left. Then copy that sheet when adding new sheets. > > Ross Johnson wrote: > > On Mon, 2006-03-13 at 06:08 -0500, [EMAIL PROTECTED] wrote: > > > > > I've observed something that seems odd or at least unexpected in Calc. > > > > > > I create a spreadsheet, with content on two of the sheets (Sheet1 and > > > Sheet2). > > > > > > First, I don's set any print ranges. When I print, or do a print preview, > > > > > > from either sheet, a default range is established by Calc that includes > > > all of > > > my content. Good, this is what I would hope for. > > > > > > Second, I go into Sheet1 and manually set a print range. Sheet1 prints > > > with > > > that range. Also good, this is what should happen. > > > > > > Third, I go to Sheet2, and don't set any manual range. Now nothing prints > > > > > > from Sheet2. Not good! Why does setting a print range in Sheet1 seem to > > > wipe out > > > the default print range in Sheet2? > > > > > > Can anyone else verify this behaviour? Is this an intentional feature, > > > and > > > if so, what would be the rationale for it? > > > > > > > I haven't explicitly verified it, but I'm not unhappy about that > > behaviour. It does seem natural to me that if I define a print range, > > that that would be just what I want printed. I recently defined print > > ranges in a 12 sheet spreadsheet and didn't think twice about it, didn't > > even think that it feels odd to do that. In fact, I kind of expected to > > have to do it that way. > > > > Maybe if it was the other way around I'd get used to it just as easily. > > > > > > > Dick Detwiler, Webster, NY > > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
