Issue 6705 - copying multiple "not-all-together" selected cells please
Summary: copying multiple "not-all-together" selected cells please
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.1
Hardware: All All
: P3 Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: falko.tesch
QA Contact: issues@sc
: 21924 44033 64659 (view as issue list)
Depends on:
Reported: 2002-08-02 10:02 UTC by lars
Modified: 2010-04-16 07:54 UTC (History)
2 users (show)

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


Note You need to log in before you can comment on or make changes to this issue.
Description lars 2002-08-02 10:02:35 UTC
select cells. With STRG select cells elsewhere. You can't copy them. One should 
be able to do so though (also one should be able to drag and drop them 
Comment 1 oc 2002-11-28 13:00:28 UTC
Hi Falko,
Comment 2 magrawal 2003-05-01 22:16:22 UTC
I am assuming that this means that if I want to copy a2:a49 and h4:
h98, I should be able to do that and then paste it somewhere else in 
the spreadsheet into adjacent columns. For example b2:c96 in the above 
case (2 columns by 95 rows)

I am trying to request such a feature and I hope this request means 
exactly that.
Comment 3 lars 2003-05-01 23:44:59 UTC

no; it means:

if I select A1:F1 and A3:F3 and copy them and place the cell marker 
(focus, active cell) at A7 and "copy", A1:F1 is pasted into A7:F7 and 
A3:F3 is pasted into A9:F9.

Selecting the reference cell in the original selection which is the 
starting cell when pasting into the current active cell (ref. cell is 
top left in my example) or pasting "merged" like you seem to have 
described (pasting into A7:F7 and A8:F8 in my example) may be extra 
Comment 4 falko.tesch 2003-10-08 13:47:00 UTC
Of course you can't.
There is no way how to define how and where to paste them!
Even our competitors knows this and do not offer this feature either.
Comment 5 falko.tesch 2003-10-08 13:47:11 UTC
Comment 6 lars 2003-10-08 14:05:51 UTC
keeping the relative position?

Comment 7 falko.tesch 2003-10-08 14:22:17 UTC
No, this is not possible because the target could be smaller,
different what-so-ever.
Again: There IS a good reason why noone(!) has this feature.
Comment 8 falko.tesch 2003-10-08 14:22:28 UTC
Comment 9 lars 2003-10-08 16:02:28 UTC
copying multiple "not-all-together" selected cells is nothing more 
than copying a block of cells big enough to contain all the "single" 
cells with some cells marked as not-to-be-copied really.

What is this good reason?
Comment 10 lars 2006-04-23 11:50:02 UTC
*** Issue 64659 has been marked as a duplicate of this issue. ***
Comment 11 ooo 2006-05-15 12:52:04 UTC
*** Issue 53901 has been marked as a duplicate of this issue. ***
Comment 12 ooo 2006-05-15 12:57:24 UTC
*** Issue 44033 has been marked as a duplicate of this issue. ***
Comment 13 kpalagin 2007-01-05 15:45:15 UTC
*** Issue 73153 has been marked as a duplicate of this issue. ***
Comment 14 kpalagin 2007-01-05 15:51:27 UTC
*** Issue 21924 has been marked as a duplicate of this issue. ***
Comment 15 dz0 2008-03-14 12:21:51 UTC
there are workarounds in copetitor program

and I for example need sometimes to extract some data with Find All and then
copy to text file -- so this feature (or similar workaround) would be really usefull
Comment 16 dz0 2008-09-22 14:11:27 UTC
WHY is it closed?
Comment 17 dz0 2009-05-07 14:41:12 UTC
this problem can be made less missleading, 
if the "Copy" icon would not become inactive, but when user press "Copy" button
(or Ctrl+C) -- 
warning dialog would appear, explaining, that "Copy action on multiple
selections can't be used". (this behavior is made in excel)
Comment 18 Rainer Bielefeld 2010-04-16 07:54:21 UTC
This has been fixed (partially) with Issue 25855