Try setting both checkboxes in Tools - Options - Calc - Print. You also may want to vote for issues http://www.openoffice.org/issues/show_bug.cgi?id=10530 http://www.openoffice.org/issues/show_bug.cgi?id=29807 http://www.openoffice.org/issues/show_bug.cgi?id=22762
> -----Original Message----- > From: Richard Travers [mailto:[EMAIL PROTECTED] > Sent: Thursday, April 19, 2007 8:07 PM > To: Open Office List > Subject: [users] Printing from Calc > > I am using Open Office v2.2 on a Windows XP machine. > I have a relatively straightforward spreadsheet in Calc > comprising two sheets, sheet 2 merely fetching a sub-set of > the data from sheet 1. > > When I try to print from sheet 2, having set a print range in > Format>Print Range, Calc insists on printing the same print > range from both sheets 1 and 2. I have tried specifying the > Sheet number in the print range (perhaps I am not doing this > correctly) but if I click OK, then look again, the Sheet > number has disappeared. > > I can, of course, tell the printer not to print page 1 (the > Sheet 1 copy of the range), but there must be a way of > telling Calc that I only want to print from sheet 2. > > Can anyone help? > > -- > > Richard Travers > [EMAIL PROTECTED] > Truro, Cornwall > 01872 271125 > > --------------------------------------------------------------------- > 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]
