Issue 7180 - Need ability to move columns/rows in spreadsheet
Summary: Need ability to move columns/rows in spreadsheet
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.0.1
Hardware: All All
: P3 Trivial with 8 votes (vote)
Target Milestone: ---
Assignee: frank
QA Contact: issues@sc
: 14007 55181 60285 63916 84528 (view as issue list)
Depends on:
Reported: 2002-08-22 07:59 UTC by jmills
Modified: 2013-08-07 15:14 UTC (History)
8 users (show)

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

Testdocument for Testcasespecification (7.62 KB, application/vnd.oasis.opendocument.spreadsheet)
2007-08-03 15:17 UTC, frank
no flags Details
Testcase Specification (12.00 KB, text/html)
2007-08-03 15:18 UTC, frank
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description jmills 2002-08-22 07:59:21 UTC
Unless I'm doing it the wrong way, if I have a column (or row)
which I want to move sideways, I miss the ability
to paste a column AND INSERT at the same time

eg highlight column F
highlight column B
 --- if I PASTE now it overwrites column B
what I want to do is insert the cut values

XL has a "Insert cut column" right clicked item at this point .....

same applies to rows.

(The other way to do it would be to drag rows or columns to their new positions....)

this is a usability request.
Comment 1 frank 2002-08-22 08:37:44 UTC
Hi Falko,

1 4 u

Comment 2 falko.tesch 2003-10-08 13:36:09 UTC
Add "Insert copied/cut cells" to context menu.
It allows to paste clipboard content* to the desired location w/o(!)
overwriting the existing data (but to "shift" the existing data instead)
* This cipboard content must be formerly cut/copied cells from the
Comment 3 falko.tesch 2003-10-08 13:36:27 UTC
Comment 4 frank 2003-10-08 16:20:42 UTC
what's about Paste Special Shift cells ... ?

Comment 5 bettina.haberer 2003-12-05 17:59:48 UTC
Hello Nikals, please give approval for this evaluated OO.o 2.0 flagged
If you confirm with the target OO.o 2.0, then please keep it on your
owner (or the owner of the concerning developer) for implementation.
In case you want this issue for 'OOo Later', then please reset the
target milestone. If you decline the issue finally, please set the
resolution to 'Wontfix' (but do not close). In case of 'OOo Later' or
'Wontfix' please reset it on Bettina's owner. Thank you.
Comment 6 Martin Hollmichel 2004-05-28 15:01:14 UTC
according to the announcement on releases
( this issue
will be re-targeted to OOo Later.
Comment 7 frank 2005-10-13 13:17:12 UTC
*** Issue 55181 has been marked as a duplicate of this issue. ***
Comment 8 frank 2006-03-03 09:29:49 UTC
*** Issue 60285 has been marked as a duplicate of this issue. ***
Comment 9 frank 2006-04-11 13:49:47 UTC
*** Issue 63916 has been marked as a duplicate of this issue. ***
Comment 10 thomas.benisch 2007-06-11 15:44:15 UTC
reassign to TBE
Comment 11 thomas.benisch 2007-06-11 15:47:51 UTC
set target OOo 2.x, priority P3
Comment 12 thomas.benisch 2007-06-11 15:48:21 UTC
Comment 13 thomas.benisch 2007-07-06 08:52:20 UTC
fixed on CWS calccolrowmove

The following files are affected:

Comment 14 kpalagin 2007-07-10 12:15:11 UTC
what makes this issue different from 14007?
Also, when this fix is planned for integration into master?

Thanks a lot for your work!
K. Palagin.
Comment 15 thomas.benisch 2007-07-11 14:18:53 UTC
Issue #14007 describes basically the same enhancement.
As I already checked in the code with the issue number #7180,
I will set #14007 to duplicate. Please note, that #14007 has
currently 80(!) votes.

It is planned to integrate this enhancement into OOo 2.4.
Comment 16 thomas.benisch 2007-07-11 14:34:46 UTC
*** Issue 14007 has been marked as a duplicate of this issue. ***
Comment 17 kpalagin 2007-07-11 15:28:20 UTC
What would the reason to miss 2.3?
Comment 18 thomas.benisch 2007-07-11 15:38:19 UTC
We already missed the feature deadline for OOo 2.3, which was July 5th, 2007.
Feature deadline means, that the CWS must be integrated until that date.
What's still missing for this issue is a feature specification and the
corresponding CWS
calccolrowmove must pass the QA.
Comment 19 kpalagin 2007-07-11 21:14:27 UTC
I think our users would rather have non-specced, non-QAed, but very usefull 
feature now, instead of specced/QAed 6 month later.

Is there a way other distributions could get the code in patch-like way so 
that they could give the feature to their users and do real-life QA?
Comment 20 8daysaweek 2007-07-11 22:21:47 UTC
Removing my vote (as it's "fixed"), and adding myself to CC.

Thanks for sorting this out tbe.  Even if we still have to wait for 2.4 at least
the end is in sight.  It has been a long time coming and I'm relieved to see
this old issue cleared up :-)
Comment 21 thomas.benisch 2007-07-12 10:06:41 UTC
I know this is dissatisfying, but as soon as the CWS is integrated the feature is
available in the next developer snapshot, which can be downloaded from
In addition the source code changes can be extracted from CVS and everybody is free
to include those changes and build an own distribution. As far as I know you always
have full installation sets for OOo, I'm not sure if patch sets are supported.
Comment 22 thomas.benisch 2007-07-19 15:13:05 UTC
The specification is available at
Comment 23 frank.loehmann 2007-07-20 12:42:05 UTC
Set target
Comment 24 thomas.benisch 2007-07-25 11:21:51 UTC
TBE->FST: Please verify on CWS calccolrowmove.
Comment 25 frank 2007-08-03 15:17:35 UTC
Created attachment 47295 [details]
Testdocument for Testcasespecification
Comment 26 frank 2007-08-03 15:18:18 UTC
Created attachment 47296 [details]
Testcase Specification
Comment 27 frank 2007-08-03 15:22:18 UTC
found fixed on cws calccolrowmove using Windows and Solaris build.
Comment 28 frank 2007-08-28 14:39:23 UTC
found integrated on master SRC680m226 using Solaris, Windows and Linux build.
Comment 29 frank 2007-12-13 12:47:34 UTC
*** Issue 84528 has been marked as a duplicate of this issue. ***
Comment 30 lohner 2007-12-13 12:53:52 UTC
Should issue 21280 be set as a duplicate of this? It also has a relationship
with issue 14007.
Comment 31 ds13 2008-01-21 17:19:02 UTC
Hi, I wonder, if Issue 21280 will be fixed with this, too? Can anybody tell?
Comment 32 tanstaafl 2010-02-26 19:38:10 UTC
How is this 'fixed'? I don't see 'Insert cut/copied cells' in any context menu