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: users@openoffice.org
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]