I have filed issue on this topic. Please see http://qa.openoffice.org/issues/show_bug.cgi?id=67851 Circled in blue on "subtotals.GIF" is outline level 2.
Thanks. WBR, K. Palagin. > -----Original Message----- > From: Immanuel CRC Office [mailto:[EMAIL PROTECTED] > Sent: Thursday, July 27, 2006 8:21 PM > To: [email protected] > Subject: Re: [users] Calc - copying subtotals without original data? > > Kirill S. Palagin wrote: > > "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. > > > > > Kirill: > > I have no idea what you are trying to do. I don't understand > when you say "select outline level 2" > > Perhaps someone else can help... > > Crystle > > >> -----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] > > > > > > -- > 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]
