You nailed it! Pitty that Calc can't do that. As a way of doing that OOo could have an option of copying results to separate location.
> -----Original Message----- > From: Walter A. March [mailto:[EMAIL PROTECTED] > Sent: Friday, July 28, 2006 5:39 AM > To: users@openoffice.org > Subject: Re: [users] Calc - copying subtotals without original data? > > For those who are familiar with M$ Excel, I can, I think > express what we are trying to do. > > We do our subtotal and then collapse the outline so that only > the subtotal and grand total lines are displayed. > > Now we select the data. In Excel, our next step would be > Edit > Go To. > Click Special. Click Visible Cells Only. Click OK > > Now we would copy and paste. Its that selecting only the > visible cells that we either can't do or don't know how to. > > WalterAM > > <snip> --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]