Ask Your Question

open in worksheet calc differnet files [closed]

asked 2012-04-17 11:50:04 +0200

aroushdi gravatar image

Hi I have may calc files ods files , What I want to do is have all these ods file in one file with different sheets . can u tell me how to do it manually rather copy and past and how to automate it if possible .

thks Amr

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-18 02:09:40.860888

1 Answer

Sort by » oldest newest most voted

answered 2012-09-17 08:35:46 +0200

rl gravatar image

How many is many?

You can move sheets into a different file by right click on the tab > Move/Copy Sheet ...

If you put too many sheets into one file, switching between them by scrolling to the right tab might not be easier than just loading all of the files and switching via the Window menu.

Not to speak of possible stability issues.

edit flag offensive delete link more

Question Tools


Asked: 2012-04-17 11:50:04 +0200

Seen: 119 times

Last updated: Sep 17 '12