We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Merge to Workbook

asked 2018-06-27 07:38:21 +0200

chetan gravatar image

updated 2021-06-01 01:27:36 +0200

Alex Kemp gravatar image

Hi Everyone I have opened 2 workbooks and during open event of libreoffice i want to merge these 2 open workbook together in one workbook. Can anyone share me a reference to perform this task.

I found one way to merge by writing a VB Macro, I am new to VB. Can anyone share me a reference source to perform this function or similar function.

edit retag flag offensive close merge delete


Remembering https://ask.libreoffice.org/en/questi...:

Don't you think it's a good idea to respond on comments / questions in return?
A forum isn't one-way. If you created something related to a task, you probably should not only mention, but also offer it.

Lupp gravatar imageLupp ( 2018-07-01 12:41:10 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2018-06-27 13:04:44 +0200

erAck gravatar image

The easiest way is to do it manually in a few steps:

  1. right click on a sheet tab for context menu
  2. choose Select All Sheets
  3. again right click on a sheet tab for context menu
  4. choose Move or Copy Sheet...
  5. Action Copy (preselected and can't be changed if all sheets are selected)
  6. Location To document, choose - new document -
  7. hit OK
  8. repeat for the second document to copy its sheets, but in Location To document choose the new Untitled 1 document (or the proper name if you saved it already after step 7) and the position where you want to insert the sheets
edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-06-27 07:38:21 +0200

Seen: 239 times

Last updated: Jun 27 '18