"Paste special" is not doing what I want (or I am not using it correctly). Let me give an example. Subtotalling the following table
ProdA 5 ProdA 7 ProdA 3 ProdB 1 ProdB 4 ProdB 2 will add following rows Subtotal ProdA 15 Subtotal ProdB 7 Grand Total 22 When I select "outline level 2", data before subtotalling hides and only new rows are displayed. I need to copy only those new. Thanks a lot. > -----Original Message----- > From: Immanuel CRC Office [mailto:[EMAIL PROTECTED] > Sent: Thursday, July 27, 2006 6:13 PM > To: [email protected] > Subject: Re: [users] Calc - copying subtotals without original data? > > Kirill S. Palagin wrote: > > Hello. > > > > Subject says it all - I have subtotalled some data and need to copy > > subtotals sans original data. > > Any way of doing that in Calc? > > > > Thanks a lot. > > WBR, > > K. Palagin. > > > > Kirill: > > Do you mean you need to only copy the number, and not the formula? > > If so, try copying the cell (Ctrl-C or whatever), then going > to the cell where you want the info, and then do Edit->Paste > Special. Unselect "Paste All" and then tick the ones you do > want to paste. I would think you would for sure want to > uncheck "Formulas". You can play around until you get what you want. > > Does that do it? > > Crystle > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] For > > additional commands, e-mail: [EMAIL PROTECTED] > > > > > > -- > Crystle Numan > Administrative Secretary, Immanuel CRC > 61 Mohawk Rd. W. Hamilton ON L9C 1V9 > 905-385-0662 > [EMAIL PROTECTED] > http://immanuelministries.ca > > --------------------------------------------------------------------- > 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]
