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

Calc Default settings and Configuation files

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


Joined: 07 May 2005
Posts: 2

PostPosted: Sun May 15, 2005 8:00 am    Post subject: Calc Default settings and Configuation files Reply with quote

New to Oo and these forums and would like to customize Oo. Where does one set default row width, column width, font to use, etc. for ALL NEW spreadsheets? Also is there a file which stores the customized toolbar settings such as the XLB file in Excel, which can be copied to various computers so they all have the custom toolbars I would like to use? Or do I need to set them all up on each machine and then change each machine every time I make changes on one. Is there a doc which goes through and explains all this?

Thank you for any info provided!
philpc
Back to top
View user's profile Send private message
8daysaweek.co.uk
Super User
Super User


Joined: 29 Nov 2003
Posts: 2130
Location: UK

PostPosted: Sun May 15, 2005 8:04 am    Post subject: Re: Calc Default settings and Configuation files Reply with quote

philpc wrote:
New to Oo and these forums and would like to customize Oo. Where does one set default row width, column width, font to use, etc. for ALL NEW spreadsheets?

You would need to create a default template:
http://www.8daysaweek.co.uk/forums/viewtopic.php?t=53

philpc wrote:
Also is there a file which stores the customized toolbar settings such as the XLB file in Excel, which can be copied to various computers so they all have the custom toolbars I would like to use? Or do I need to set them all up on each machine and then change each machine every time I make changes on one. Is there a doc which goes through and explains all this?

Thank you for any info provided!
philpc

Not a complete answer, but this should point you in the right direction:
http://www.8daysaweek.co.uk/forums/viewtopic.php?t=33

HTH Smile,
_________________
James
www.8daysaweek.co.uk - A User-Focused OOo site
Back to top
View user's profile Send private message Visit poster's website AIM Address
philpc
Newbie
Newbie


Joined: 07 May 2005
Posts: 2

PostPosted: Fri May 20, 2005 8:15 pm    Post subject: Reply with quote

Thank you James for your quick response. Haven't been able to try all the suggestions till today. The template solution worked fine. As well once I found where all the config files were stored from your second URL, I got all my config data moved to other computers no problem. As well found that if I only want to copy my toolbar changes you can just copy the xml files buried way down in C:\Documents and Settings\phil\Application Data\OpenOffice.org1.9.79\user\config\soffice.cfg\modules\scalc\toolbar for the respective toolbar. Just make sure you close the quickstarter and then restart and your toolbar settings have been updated.
Again thank you for your info.
Phil Very Happy
Back to top
View user's profile Send private message
8daysaweek.co.uk
Super User
Super User


Joined: 29 Nov 2003
Posts: 2130
Location: UK

PostPosted: Sun May 22, 2005 1:56 am    Post subject: Reply with quote

No problem, glad it worked out and thanks for posting your results Smile
_________________
James
www.8daysaweek.co.uk - A User-Focused OOo site
Back to top
View user's profile Send private message Visit poster's website AIM Address
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