Bug 140144 - Drag'n drop sheets between documents
Summary: Drag'n drop sheets between documents
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.0.3.1 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Sheet
  Show dependency treegraph
 
Reported: 2021-02-04 03:06 UTC by Sjobeck
Modified: 2023-08-19 04:33 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
Screenshot, select to move/copy to other document (11.79 KB, image/png)
2021-02-05 07:13 UTC, m_a_riosv
Details
Video showing how to copy sheet by dragging (138.01 KB, video/mp4)
2022-02-10 23:42 UTC, Rafael Lima
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Sjobeck 2021-02-04 03:06:00 UTC
Description:
it would be nice to drag a worksheet to another workbook

Steps to Reproduce:
put two workbooks side by side and try to drag-n-drop a worksheet in to the other workbook

Actual Results:
nothing

Expected Results:
it pops in to the first workbook


Reproducible: Always


User Profile Reset: Yes



Additional Info:
N.A.
Comment 1 m_a_riosv 2021-02-04 15:31:23 UTC
I hope you know it can be done right-clicking on the sheet tab and selecting 'mov/copy sheet'
Comment 2 Sjobeck 2021-02-04 16:50:55 UTC
That only works inside the same workbook. I am referring to between two workbooks.
Comment 3 m_a_riosv 2021-02-05 07:13:49 UTC
Created attachment 169488 [details]
Screenshot, select to move/copy to other document

It works between different spreadsheets. You can select it in 'Location-To document'
Comment 4 m_a_riosv 2021-02-05 07:14:56 UTC
In this place you must not set up as new your own report, someone else must do it.
Comment 5 eisa01 2022-02-05 13:25:55 UTC
Confirming this

I checked, and MSO allows you to move sheets between open workbooks with drag and drop

Needs to be evaluated by the UX team
Comment 6 Heiko Tietze 2022-02-08 11:36:38 UTC
You can drag a sheet from one document to another if you drop it on the active sheet. It will copy the sheet but move the content; so close but no cigar.

To do:
* accept sheet source when target is sheet tabs area
* ideally copy or move as done within the document using the ctrl modifier; but definitely do not mix copy and move as of now
Comment 7 Rafael Lima 2022-02-10 23:42:49 UTC
Created attachment 178209 [details]
Video showing how to copy sheet by dragging

(In reply to Heiko Tietze from comment #6)
> You can drag a sheet from one document to another if you drop it on the
> active sheet. It will copy the sheet but move the content; so close but no
> cigar.

I tested it using LO 7.4 and it seems the current implementation already delivers the intended behavior.

In the attached video I drag the sheet "Test" onto another Calc instance and hold "Ctrl" before dropping it. As a result, a copy of the original sheet appears and the original data is kept.

Doing this without holding Ctrl will move the sheet and delete the data in the original document.

Maybe we already offer the requested feature... what we need is to document this workflow in the Help.
Comment 8 eisa01 2022-02-12 09:00:39 UTC
Ah, if you hold over the sheet area it works

In my comment I was referring to the fact I couldn't copy the sheet at all, because I was trying to drop it in the sheet tabs

This copies the sheet, which I would say is the expected behavior - it would be weird if it moves?

It would be nice if it's also possible to drag and drop to the sheet tabs