Ask Your Question
0

Merge to Workbook

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

chetan 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

Comments

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 +0100 )edit

1 Answer

Sort by » oldest newest most voted
1

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

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

Stats

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

Seen: 134 times

Last updated: Jun 27 '18