An obscure bug creating Office documents

When creating an Excel 2003 document using the OM, the SaveAs dialog is displayed with the document type of the template (.xlt) instead of the default type (.xls).

If I create the document from the document library ListViewWebPart toolbar, selecting my custom Content Type, the SaveAs works as it always does defaulting to the .xls file extension. 

Under the circumstances at the client I am working for, I cannot try this with Excel 2007, but I suspect it is an Excel issue rather than WSS 3.0. Unfortunately, unlike a number of other warts in Excel, I cannot patch around this with VBA code in the template. When the problem occurs, clicking Tools > Options > Transition tab shows me that the default document type on Save is the default of MS Office Excel Document, or .xls that is.



About generation12

I am a SharePoint/.NET consultant in the twin cities.
This entry was posted in Today's Disenchantment and tagged . Bookmark the permalink.

Leave a Reply

Please log in using one of these methods to post your comment: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s