Integratation the all of worksheets

Discuss the spreadsheet application

Integratation the all of worksheets

Postby hayato » Wed Apr 16, 2008 4:57 am

Hi there.

I want to integrate the all of worksheets to one worksheets. What should I do?
There are more than 50 worksheets on one book file. I want to see all of worksheet on one worksheet.
Someone help me, please!!!
hayato
 
Posts: 3
Joined: Mon Apr 14, 2008 8:48 pm

Re: Integratation the all of worksheets

Postby kingfisher » Wed Apr 16, 2008 5:46 am

Use the menu Insert >Sheet from file. There's the command line if you want something faster but I don't know the syntax; it involves concatenating the files.
Apache OpenOffice 4.1.6 on PCLinuxOS
User avatar
kingfisher
Volunteer
 
Posts: 2120
Joined: Tue Nov 20, 2007 10:53 am

Re: Integratation the all of worksheets

Postby hayato » Wed Apr 16, 2008 6:12 am

Thank you for the post, kingfisher!

Does someone know the syntax? Please teach me the exmple of it!!!!!!

Or the method I want to do is not for beginners like me?
hayato
 
Posts: 3
Joined: Mon Apr 14, 2008 8:48 pm

Re: Integratation the all of worksheets

Postby kingfisher » Wed Apr 16, 2008 7:43 am

Have a look at this post by TerryE on the other forum. I suspect that you could complete the task using the GUI by the time you work out the command line.
Apache OpenOffice 4.1.6 on PCLinuxOS
User avatar
kingfisher
Volunteer
 
Posts: 2120
Joined: Tue Nov 20, 2007 10:53 am

Re: Integratation the all of worksheets

Postby hayato » Wed Apr 16, 2008 8:05 am

Thank you very much, kingfisher!!!!!

I'm gonna check it out!!!!

I really appreciate your fast and effective posts!
hayato
 
Posts: 3
Joined: Mon Apr 14, 2008 8:48 pm


Return to Calc

Who is online

Users browsing this forum: No registered users and 32 guests