OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Pasting in Calc

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
firetrain2
Newbie
Newbie


Joined: 20 Jan 2012
Posts: 3

PostPosted: Fri Jan 20, 2012 3:00 pm    Post subject: Pasting in Calc Reply with quote

I am trying to find out how to copy from one sheet to another in CALC and include the column widths and row heights.
If this can be done, is it possible to copy data, widths and heights to multiple sheets at once?
Back to top
View user's profile Send private message
mgroenescheij
Super User
Super User


Joined: 20 Apr 2011
Posts: 870
Location: Australia

PostPosted: Fri Jan 20, 2012 3:51 pm    Post subject: Reply with quote

Hi,

You can copy data to multiple sheets when you select these sheets.
You select sheets by holding the Control down and click on the sheet tabs.
While multiple sheets are selected you could drag the width of the Column and Height of the rows, but copy only copies data and formulas.
Be aware that it is not visible which sheets you have selected hence it is could create more problems than it solved.
Don't forget to click on a single sheet when done.

Martin
_________________
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button).
Back to top
View user's profile Send private message
qaz1qaz1qa
Power User
Power User


Joined: 21 Jan 2012
Posts: 68

PostPosted: Sun Jan 22, 2012 12:43 am    Post subject: Pasting in Calc Reply with quote

if you select the tab you want as the templet and right click it the option to Move/copy comes up in the shell menu.
choose it and make sure you tick the COPY option at the bottom.
The newly created tab will then have all the data and have all the columns and rows set as well. a perfect copy except for the name
Back to top
View user's profile Send private message
firetrain2
Newbie
Newbie


Joined: 20 Jan 2012
Posts: 3

PostPosted: Sun Jan 22, 2012 6:34 am    Post subject: Pasting to multiple sheets Reply with quote

Thanks mgroenescheij,
Your suggestion worked very well.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group