search

ONLYOFFICE / DocumentServer

ONLYOFFICE Docs is a free collaborative online office suite comprising viewers and editors for texts, spreadsheets and presentations, forms and PDF, fully compatible with Office Open XML formats: .docx, .xlsx, .pptx and enabling collaborative editing in real time.
https://www.onlyoffice.com
GNU Affero General Public License v3.0
4.57k stars 1.05k forks source link

Copy or move sheets to another spreadsheet file #1437

Open arkgnan opened 2 years ago

arkgnan commented 2 years ago

Do you want to request a feature or report a bug? feature

What is the current behavior? when I copy/move the sheet, there isn't a choice to another file as the target location. in libreoffice or google spreadsheet we can choose it.

What is the expected behavior? I hope onlyoffice has this feature Screenshot_34

Did this work in previous versions of DocumentServer? NO DocumentServer version: 6.4 Operating System: Windows 10 Browser version: I use Desktop App

Rita-Bubnova commented 2 years ago

Hello, @arkgnan. You could move a worksheet to another spreadsheet file using drag-and-drop.

But, add "Copy or move sheets to another spreadsheet file" to the context menu - it's a good idea. We discuss this issue with our team in issue 49116 in our private issue tracker.

Plinsboorg commented 2 months ago

Hi @Rita-Bubnova, I'm trying to copy the worksheet from one document to the other using the desktop apps, but I can't do it. Same as in the issue description I don't have this option in the menu. But drag-and-drop doesn't seem to work either. I have desktop app version 8.0.1.31

Plinsboorg commented 2 months ago

Ok, I understand it now. It does not allow to drag-and-drop the sheet from the spreadsheet if this is the only sheet in the document. So first I need to create a copy of the sheet inside the same document, and then drag it to the different document. This way it works. But it was far from intuitive, to be honest.

VladimirProkofiev52 commented 2 months ago

Hello! @Plinsboorg I confirm that currently in our editor there is no option to move a single sheet from an XLSX file.
This is a great enhencement, please create a separate issue and we will definitely try to implement this enhencement.