Issue 25855 - Copy multiple seperated rows
Summary: Copy multiple seperated rows
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 1.1
Hardware: All All
: P3 Trivial with 67 votes (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@sc
Keywords: oooqa
: 53901 67912 79723 99445 100385 101871 (view as issue list)
Depends on: 104550 104551 104553
  Show dependency tree
Reported: 2004-02-25 13:11 UTC by da104983
Modified: 2017-05-20 10:20 UTC (History)
17 users (show)

See Also:
Issue Type: PATCH
Latest Confirmation in: ---
Developer Difficulty: ---

latest patch from go-oo (70.31 KB, patch)
2009-06-02 19:19 UTC, kyoshida
no flags Details | Diff
additional patch to fix one issue (495 bytes, patch)
2009-06-02 19:20 UTC, kyoshida
no flags Details | Diff

Note You need to log in before you can comment on or make changes to this issue.
Description da104983 2004-02-25 13:11:08 UTC
In "that other" Spreadsheet program, I have the ability to copy multiple
seperated rows, and paste them in a new sheet (or where ever).  For instace, I
can click on row 2 and row 4, hit Ctrl+C and it will grab the data.  However, in
OO's Spreadsheet, I get the following error message:
"This function cannot be used with multiple selections."
I've started a thread on this:
...and it was suggested to file an enhancement request.  This happens on both
Win32 and Linux/Gnome installs.

Comment 1 frank 2004-02-25 14:11:13 UTC
Hi Bettina,

one for you.

Comment 2 rblackeagle 2004-02-25 16:12:56 UTC
Just another issue I ignored as "Something other spreadsheet programs can do but
OOo cannot."  I should have filed an issue about it a year ago.  It IS a problem
and does cause a lot of extra "workaround" work, esepcially if there are
formulas referencing the values.
Comment 3 nodata 2004-05-09 15:29:24 UTC
This feature would be great, a lot of my spreadsheets involve cut and pasting
between sheets.
Comment 4 gorden.lin 2005-01-17 08:48:03 UTC
Yes, one financial team colleague complain that SO/OOo should add this feature
since multi-row copy is very convenient to daily work. 
Comment 5 eclipse99 2005-07-12 09:46:07 UTC
The issue is more general than copying multiple rows. Selecting multiple cells
won't copy either. 
My guess is that selecting non-connected cells disable copying/cutting/pasting.
I think it's an important issue.
Comment 6 drodiger 2005-11-21 08:03:27 UTC
Dear all,

I am converting some of my clients from MS to OOo and this enhancement is one of
they are complaining at. Can someone tell me in which version this will be added?

Thank you
Comment 7 ooo 2006-05-15 13:03:10 UTC
*** Issue 53901 has been marked as a duplicate of this issue. ***
Comment 8 kpalagin 2006-09-11 12:28:17 UTC
Dear developers,
any chance of implementing this RFE? Judging by votes it seems to be in demand.
Comment 9 kpalagin 2006-11-23 12:39:42 UTC
*** Issue 67912 has been marked as a duplicate of this issue. ***
Comment 10 frank 2007-07-18 09:07:49 UTC
*** Issue 79723 has been marked as a duplicate of this issue. ***
Comment 11 frank 2007-07-18 13:43:25 UTC
*** Issue 79723 has been marked as a duplicate of this issue. ***
Comment 12 bettina.haberer 2007-09-26 15:56:59 UTC
Hi Niklas, these RFEs are in your ownership.
Comment 13 nick_lee 2008-01-19 13:11:17 UTC
Such an old problem and it's of enhancement type yet :(   
But this ability is really important. Several colleagues of mine complain about
this problem. Usually they need to copy separated cells from one row to paste
them to another as one block, not separated.
BTW, there is a grammatical error in Summary of this issue.
Comment 14 da104983 2008-01-21 12:48:00 UTC
Wow, I love how every now and then I get an email on this to remind me it's
still open....I can't believe it's been almost 4 years, and still new to report.
 O'well, I'm sure they'll get to it some year.  P.S.  It's a spelling error, not
a grammatical error ;-)
Comment 15 aladdin2k7 2008-02-07 10:07:22 UTC
More precisely, non contiguous cell selection didn't work  for copy & paste.
Comment 16 sbechtold 2008-04-10 10:40:41 UTC
Cette fonctionnalité est trés importante pour mes utilisateurs. Notre projet de
migration s'en trouve grandement affecté ! C'est dommage.
Comment 17 frank.loehmann 2008-05-22 09:34:00 UTC
This issue is important and listed on the quarterly review for Calc:
Therefore adjusting target to 3.x.
Comment 18 az77 2009-01-12 02:53:20 UTC
This enhancement would be génial (very very NICE)
Comment 19 Rainer Bielefeld 2009-02-21 12:01:59 UTC
*** Issue 99445 has been marked as a duplicate of this issue. ***
Comment 20 kyoshida 2009-03-17 06:12:42 UTC
A draft patch is now in go-oo.

I'm still in the process of testing it.
Comment 21 kyoshida 2009-03-20 12:50:30 UTC
*** Issue 100385 has been marked as a duplicate of this issue. ***
Comment 22 kyoshida 2009-03-27 18:56:20 UTC
I'm grabbing this since I've already started working on it.
Comment 23 kyoshida 2009-03-27 18:56:43 UTC
Comment 24 lemishok 2009-05-11 21:53:29 UTC
I download a newest 3.1 ver. Bug ain't fixed :(
Comment 25 kyoshida 2009-05-13 17:38:13 UTC
*** Issue 101871 has been marked as a duplicate of this issue. ***
Comment 26 bigandy 2009-05-25 19:39:46 UTC
Comment 27 kyoshida 2009-06-02 19:19:16 UTC
Created attachment 62728 [details]
latest patch from go-oo
Comment 28 kyoshida 2009-06-02 19:20:08 UTC
Created attachment 62729 [details]
additional patch to fix one issue
Comment 29 kyoshida 2009-06-02 19:21:24 UTC
The patches are to be applied in this order.
Comment 30 niklas.nebel 2009-06-03 16:34:58 UTC
Hm. A lot of duplication there. The more obvious approach would be to build upon
the "filtered rows" handling and skip non-selected columns/rows.
Comment 31 kyoshida 2009-06-03 16:55:45 UTC
The reason for duplication is to avoid breaking the existing simple
copy-n-paste, which is a very common operation and should not be broken.

What I am trying to do is to keep the code paths for the normal copy and
multi-range copy separate, but identify duplicated code blocks and turn them
into methods to share between the two code paths.

We should probably merge the filtered row copy and multi-range copy
functionality into one, but I'd prefer to use the multi-range copy code to
implement the filtered row copy, not the other way around.
Comment 32 kyoshida 2009-06-03 17:30:21 UTC
BTW, the duplication is at least initial.  As we integrate this piece we can do
more aggressive duplication removal.
Comment 33 amy2008 2009-07-13 06:39:15 UTC
Comment 34 marines 2009-07-17 02:00:27 UTC
When I copy a combination cell and paste it on a combination cell, 
I would like to paste it in the state that chose plural cells. 
※When not only consecutive cells but also a place includes the remote cell.
Comment 35 kyoshida 2009-08-05 22:17:04 UTC
Spec for this feature is now available:

Setting target for 3.2 (assuming that I still haven't missed the feature freeze...)
Comment 36 kyoshida 2009-08-05 22:58:36 UTC
@marines: please file a separate feature request for that one.  It's not going
to be implemented as part of this feature, at least not initially.
Comment 37 kyoshida 2009-08-05 23:00:43 UTC
Ok.  I've finished all I had planned to do.  Setting this fixed in
koheimultirangecopy cws.
Comment 38 kyoshida 2009-08-05 23:03:31 UTC
re-assigning to oc for qa verification.
Comment 39 aladdin2k7 2009-08-06 08:58:12 UTC
marines : have a look to issue 88306[1], similar one.

Comment 40 kyoshida 2009-09-01 02:24:04 UTC
FYI (since someone privately asked me of the status), three more issues have
been filed that were blocking this issue.  They all have been fixed, and the cws
is now back to QA once again.
Comment 41 oc 2009-09-04 10:43:38 UTC
verified in internal build cws_koheimultirangecopy
Comment 42 gregyu 2009-10-14 20:06:07 UTC
This is one of the top 5 things I use a spreadsheet for every day with Excel - I
am praying for 3.2 to have this
Comment 43 Rainer Bielefeld 2010-04-16 07:56:24 UTC
Please check whether following issues have been fixed with this one:
Issue 26329, Issue 110908 
Comment 44 mukundanp 2013-03-20 05:48:30 UTC
The problem still exists. If we try to copy from two different cells which is not in the same row or column. For e.g.: if we try to copy from C1 and D2 Open Office will raise the error 'This function cannot be used with multiple selection'. Whereas if we copy from C1 and C6 or D1 and G1 it will work fine.