At 17:46 08/04/2008 +0100, John Yarnell wrote:
For some reason when I go to save a spreadsheet open office forgets to add the file extension xls and I have to add it manually otherwise if gets saved as "1 File" as opposed to a "Microsoft Excel Worksheet" and I'm prompted to select a program whenever I go to reopen the file, and I can't without renaming the file with an xls extension. The "automatic file name extension" box is ticked......make sense??...any ideas!!...
There are some filenames which will create this effect. If, for example, you include a recognised extension in the "File name" box of the Save As... dialogue, you can confuse OpenOffice into not appending the proper extension. If you save a Calc spreadsheet in Excel format and choose "name.doc" as the name but have the automatic extension ticked, you will get a valid Excel file (as you have discovered) but with the useless name "name.doc" - without the .xls extension. (That's on my 2.4 for Windows XP.)
Avoid dots in file names except at the point where they introduce the extension.
I trust this helps. Brian Barker --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
