Download it now!
Bug 141907 - Copying multiple, non-continuous cells in different columns should be possible
Summary: Copying multiple, non-continuous cells in different columns should be possible
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.0.0.5 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-04-26 09:27 UTC by Larsen
Modified: 2021-05-01 20:19 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Larsen 2021-04-26 09:27:05 UTC
Description:
(separated from bug #95554)


Steps to Reproduce:
- Open a new Calc document
- Enter anything in different cells over different rows and columns, e.g.:
	A1: 1
	B2: 2
	C3: 3
- While holding the Ctrl-key, select those three cells
- Press Ctrl+C



Actual Results:
Error message "This function cannot be applied to a multiple selection" (translated from the German text I get)



Expected Results:
LO should copy the cell data, so I could insert it into the document at some other point. For example, after having copied the data from above, select cell A7 and insert it. Result should be:
	A7: 1
	B8: 2
	C9: 3



Reproducible: Always


User Profile Reset: No



Additional Info:
I first noticed this problem with 5.0.0.5 (x86). Problem persists with 7.0.5.2 (x64), Windows 10 20H2.

See also bug #141847.
Comment 1 Buovjaga 2021-04-29 17:37:36 UTC
Reproduced.

Copying of non-continuous cells in a single column was only implemented some years ago.

Arch Linux 64-bit
Version: 7.2.0.0.alpha0+ / LibreOffice Community
Build ID: 9224109de3cf2b620ff1165d31e9fb2a4cd680cf
CPU threads: 8; OS: Linux 5.11; UI render: default; VCL: kf5 (cairo+xcb)
Locale: fi-FI (fi_FI.UTF-8); UI: en-US
Calc: threaded
Built on 29 April 2021
Comment 2 Roland Kurmann 2021-05-01 18:07:41 UTC
I agree that this multi selection would be good, but I would expect a different result.

Steps to Reproduce:
- Open a new Calc document
- Enter anything in different cells over different rows and columns, e.g.:
	A1: 1
	B2: 2
	C3: 3
- While holding the Ctrl-key, select those three cells
- Press Ctrl+C

Select cell A7 and insert it. Result should be:
	A7: 1
	A8: 2
	A9: 3

Rationale: Relative distance of selection (gaps) is not considered in current versions of Calc, e.g. 7.1.1.2:

Steps for illustration:
1. Open a new Calc document
2. Enter
    A1: 1
    C1: 2
    E1: 3
3. Select A1
4. Press Ctrl and select C1 and E1
5. Go to cell A3
6. Paste by Ctrl-V

Actual (and expected) result:
A3: 1
B3: 2
C3: 3
The gaps are not there anymore. Only the selected cells are pasted.

I think having gaps in the pasted result is another issue. I think such a behavior is possible, but it should have different commands, menu entries, and shortcuts. It has to be done the same way for all different kinds of selections. So, I propose that another issue is created for the gap behavior.