Issue 55181 - Missing capability to cut/copy/paste entire rows/columns
Summary: Missing capability to cut/copy/paste entire rows/columns
Status: CLOSED DUPLICATE of issue 7180
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOO 2.0 Beta2
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords: oooqa
Depends on:
Blocks:
 
Reported: 2005-09-28 12:21 UTC by eyalzvi
Modified: 2005-10-13 13:17 UTC (History)
2 users (show)

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

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description eyalzvi 2005-09-28 12:21:44 UTC 
Calc is missing a basic capability that is present in "major competing products"
- the ability to select entire rows or columns, and to cut/copy/paste them.

Currently, in order to move a column, the user needs to:

1. Select the column.
2. Cut (or copy).
3. Go to the target place.
4. Insert a new column.
5. Paste.
6. Format the column (eg. width) to be the same as the source column.
7. Delete the source column.

Wouldn't it be simpler to:

1. Select the column.
2. Cut.
3. Go to the target place.
4. Paste.
Comment 1 Matthias Basler 2005-09-30 20:33:02 UTC 
Your solution would require that the PC "knows" whether you want to
- paste the column's content over the content in this column OR
- insert the column before the selected column

But I have an alternative suggestion, at least for moving columns/lines: Many
table implementations today allow table column reordering, i.e. you just drag a
column header and drop it between two other columns (often with a small arrow
indicating between which two columns it would be placed). The only difference
would be that in OOo this would not just "visually"  reorder the columns, but
actually move the contents of affected cells internally.
For lines this could work in the same way. (Just as a suggestion.)

(P.S. This is not a bug, but a feature wish. Corrected.)
Comment 2 eyalzvi 2005-10-01 00:25:00 UTC 
First of all I agree that technically this is a feature request. However as this
is rather basic functionality that's missing, and given that Excel users are
used to have it, it may be regarded as a defect. In other words, this is not a
bug in code, but a "bug" in the product feature. Anyway...

To answer your question, how Calc should "know" whether the user intends to
insert rows/columns or paste them over exiting data:

- The normal Paste action should paste over existing content, as it currently does.

- Add actions to the context (right-click) menu: "Insert cells" (or as Excel
does: "Insert copied cells" and "Insert cut cells").

Regarding your suggestion for move rows/columns by dragging - it's an excellent
idea. However I think that it's good only for moving short "distances" within
the sheet, so it should be supported in addition to proper cut/copy/paste of
rows/columns.
Comment 3 Matthias Basler 2005-10-02 10:28:44 UTC 
Makes sense. Confirmed.
Comment 4 frank 2005-10-13 13:17:13 UTC 
This is a double to Issue 7180

*** This issue has been marked as a duplicate of 7180 ***
Comment 5 frank 2005-10-13 13:17:33 UTC 
closed double