I'm going to suggest creating a new blank calc document and using the import function. Could you possibly provide an example file attached to this thread?
iPhone of Gallo On 2009-11-06, at 13:40, Brian McKee <[email protected]> wrote: > On Fri, Nov 6, 2009 at 3:09 AM, Malcolm Fitzgerald > <[email protected]> wrote: >> I'm receiving files from a web site that are supposed to be in >> excel 97-2000 >> format. When I'm on a windows platform OO calc opens the file as a >> spreadsheet. When I try to open the same files on my Mac they open >> in OO >> Write, even though I've specified that I want to open an MS >> excel .xls file. >> >> I've opened the files in a text editor and inspected them. They >> contain >> nothing but an HTML table so I'm a little annoyed that anyone even >> pretends >> that they are excel files. However, MS excel opens them and >> utilises the >> HTML code to format the cells. OO Calc on windows opens them and I >> need the >> same functionality on the mac. Can anyone suggest anything? > > You probably need the Developer Tools installed to have this command > available > SetFile -c XCEL -t XLS8 filenameToOpenInExcel > assuming here that you don't actually have Excel on that Mac. > > Or, what happens when you change the filename to .ods? > > Oddly, GetFileInfo on an .ods file shows no creator or type info - > does anyone know why they that is? > > Brian > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
