2027 Views 2 Replies Latest reply: Aug 17, 2010 11:49 AM by valuearb
As far as I know, there is no way to change the default settings of XL imported documents.
There is a possible workaround but I'm not sure that it's a viable one for your own use.
Create a document from the blank template.
Define fonts, size to fit your needs.
Save as a template.
Now, create a new document from this template.
Open your XL imported document.
Take care of the hierarchy of tables in the document.
Select the contents of a table in the lower hierarchy level (a table which may be referenced by other ones but which don't grab datas from other ones)
Copy to the clipboard
Go to the new blank document
Paste matching style in the existng blank table.
This way, you will get a table matching your formatting requirements.
Rename the table according to the original one.
Repeat the process for every table taking care to don't duplicate a table grabbing datas from a non existing one.
I hope that my poor English was sufficient to describe the process.
Yvan KOENIG (VALLAURIS, France) mardi 17 août 2010 20:42:43