Thanks for the answer! I was hoping for some single-step operation for scenario 2 (copying subtotals sans original data).
I have filed enhancement request. Please vote for it if you see fit. http://www.openoffice.org/issues/show_bug.cgi?id=67912 > -----Original Message----- > From: kevin johnston [mailto:[EMAIL PROTECTED] > Sent: Sunday, July 30, 2006 12:30 AM > To: [email protected] > Subject: Re: [users] Calc - copying noncontinuous selection? > > The general answer is "not directly". But there is a workaround. > > There are four scenarios, based on two conditions: > > 1. The source data is scattered, but it is in a region that > is *otherwise empty* except for the data that you want to copy > > *AND* > > The destination is a currently-empty area. > > - This one is easy, just copy a single contiguous range that > includes all the source data you actually want, and paste it > in the destination area. > > 2. The source data is scattered among other data; you only > want to copy some of it > > *AND* > > The destination is a currently-empty area. > > - This one is also easy, but not a single step: Copy a single > contiguous range that includes all the source data you really > want (and possibly other data that you don't want), paste it > into the destination area, then delete the data you didn't > want to copy. > > 3. The source data is scattered, but it is in a region that > is *otherwise empty* except for the data that you want to copy > > *AND* > > The destination is *not* empty; you only want to overwrite > certain cells > with new data from the source area, and you want other data > in the destination area to remain undisturbed. > > - Select and copy a single contiguous range that includes all > the source data you actually want. > > - Select the destination area you want to copy into. > > - Now do Edit->PasteSpecial->SkipEmptyCells. > > 4. The source data is scattered among other data; you only > want to copy some of it > > *AND* > > The destination is *not* empty; you only want to overwrite > certain cells > with new data from the source area, and you want other data > in the destination area to remain undisturbed. > > - The procedure here is a combination of 2 and 3. > > - First copy a single contiguous range containing all the > source data you really want, and paste it into some temporary > blank region. Go through the temporary region deleting out > the data you didn't really want to copy. > > - Now copy (or cut, since you probably won't be needing the > temp region > afterwards) the temporary region, which is empty except for > data that you really want to copy, and Paste Special into the > real destination region. > > > > PasteSpecial->SkipEmptyCells works just like a normal Paste if you > select a destination range bigger than the source range: It > repeats the source data in the destination range. This can > achieve some very useful results. > > > Kirill S. Palagin wrote: > > > Hello. > > > > Is there a way to copy noncontinuous selection? I can select > > noncontinuous cells just fine, but Copy command is not available. > > > > Thanks a lot. > > WBR, > > K. Palagin. > > > > > --------------------------------------------------------------------- > > 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] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
