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

Overriding document properties

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


Joined: 20 May 2005
Posts: 1

PostPosted: Fri May 20, 2005 5:22 am    Post subject: Overriding document properties Reply with quote

I'd like to override the properties of a document when it is opened, specifically the margins. I have a few thousand xls files with margins set to 0" on the left and right, and they don't print correctly. It seems that the 'margin' property is set in each sheet of the document. Is there a method for setting a margin globally for all documents?
Back to top
View user's profile Send private message
Dale
Super User
Super User


Joined: 21 Feb 2005
Posts: 1440
Location: Australia

PostPosted: Tue May 24, 2005 10:50 pm    Post subject: Re: Overriding document properties Reply with quote

jsacksteder wrote:
I'd like to override the properties of a document when it is opened, specifically the margins. I have a few thousand xls files with margins set to 0" on the left and right, and they don't print correctly. It seems that the 'margin' property is set in each sheet of the document. Is there a method for setting a margin globally for all documents?


Given the enormous depth of my experience in OOo (about two minutes worth) - This sounds like a job for a macro or even more appropriately some sort of code (Java, C, whatever). I've got even less knowledge about programming than I do about calc.

Try posting your query to the Macro and API forum and see if you get a response.
_________________
Dale
To err is human, but to destroy your slippers in the process takes a real son of a bitch: Me!

OOo documentation from the source
http://documentation.openoffice.org
Guides, FAQ, How Tos
Back to top
View user's profile Send private message
probe1
Moderator
Moderator


Joined: 18 Aug 2004
Posts: 2560
Location: Chonburi Thailand Asia

PostPosted: Wed May 25, 2005 12:01 am    Post subject: Reply with quote

Opening an XLS file here with OOo results in a page style "TAB_Tabelle#" (german version) for every table# in the file.

These page styles hold the page margins.

Each style in use has to be corrected.

As Dale stated: This is a job for a macro!
I have some skeletons for adapting. Would you like a FilePicker dialogue to choose a file to change; or should all XLS-files in a given directory be changed?
Should it be saved as an XLS again (or *.sxc)? Do you like to define one standard style for a page layout to be used by all your files...?
_________________
Cheers
Winfried
My Macros
DateTime2 extension: insert date, time or timestamp, formatted to your needs
Back to top
View user's profile Send private message Visit poster's website
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