Issue 26329 - non-contiguous copy/paste
Summary: non-contiguous copy/paste
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 2.4.0
Hardware: All All
: P3 Trivial with 11 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
: 81910 (view as issue list)
Depends on:
Reported: 2004-03-11 05:13 UTC by everard
Modified: 2015-08-12 18:29 UTC (History)
3 users (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---

sample copy/paste data (13.50 KB, application/
2004-03-11 05:14 UTC, everard
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description everard 2004-03-11 05:13:58 UTC
Excel has a copy paste function where seperate sections within a column/row or
adjacent columns/rows can be selected then copied and pasted missing out the
non-selected cells so that when pasted the selected cells move together leaving
no gaps.  The attached file shows the end result of this.  I don't know how many
people use this facility in Excel but in my field (scientific research) it gets
used a lot and I know people who won't use OOo as a result.  Science is an area
where opensource software makes inroads and it would be good to have this
feature.  Please note that I am not asking for any cells from allover a
spreadheet to be selctable but to be able to paste groups of cells missing out
certain parts of row or columns.
Comment 1 everard 2004-03-11 05:14:21 UTC
Created attachment 13707 [details]
sample copy/paste data
Comment 2 frank 2004-03-11 09:54:36 UTC
Hi Bettina,

would be a nice feature.

Comment 3 lohmaier 2004-10-23 21:45:39 UTC
setting keywords, reassigning according to new RFE-process.
Comment 4 ace_dent 2008-05-16 00:38:46 UTC Issue Tracker - Feedback Request.

The Issue you raised is currently assigned to 'Requirements' pending review, but
has not been updated within the last 3 years. Please consider re-testing with
one of the latest versions of OOo, as the problem(s) may have already been
addressed. Either use the recent stable version:
or consider trying the new OOo 3 BETA (still in testing):
Please report back the outcome so this Issue may be Closed or Progressed as
necessary - otherwise it may be Resolved as Invalid in the future. You may also
wish to search for (and note) any duplicates of this Issue that may have
advanced further by checking the Issue Tracker:
Many thanks,
Cleaning-up and Closing old Issues as part of:
~ The Grand Bug Squash, pre v3 ~
Comment 5 everard 2008-05-16 01:21:48 UTC
This feature is not implemented in 2.4, I have updated the version above to
reflect this.  I still consider it an important feature, certainly within my
profession (biological research) and I would have thought much more widely. 
Excel has had this feature since at least Office 2000 and probably earlier.  In
fact I commented on the lack of it in the OOforums again just recently.

To the best of my knowledge it hasn't been implemented in the 3.0 betas but I
will  double check.
Comment 6 aschwarzie 2008-05-18 00:32:26 UTC
I confirm that:
 + (1) this still is a major requirement even outside the biology industry -- 
I'm in plain IT business and use it from Excel very regularly, like I did in the 
engineering/manufacturing industry previously, and that
 + (2) it's not yet implemented in 3.0 BETA either.
Sigh. Now *THAT* would have been a major enhancement (though only catching up on 
MS Excel on that feature).
Comment 7 Rainer Bielefeld 2010-04-16 07:44:34 UTC
I believe this has been fixed with Issue 25855
Comment 8 Rainer Bielefeld 2010-04-16 07:46:57 UTC
*** Issue 81910 has been marked as a duplicate of this issue. ***
Comment 9 everard 2010-05-03 15:10:48 UTC
Yes, it appears that version 3.2 now has non-contiguous copy and paste and it
appears to work as I would expect.  Certainly is
exactly what I was hoping.

It's been a long, but thanks!  As far as I am concerned you can close this issue.
Comment 10 mroe 2015-08-12 18:29:31 UTC
As of comment 9 this issue is resolved since OOo 3.2.