Opening Excel 2003 XML docs ends up in Writer

Discuss the spreadsheet application

Opening Excel 2003 XML docs ends up in Writer

Postby nickduddy » Fri May 09, 2008 5:45 am

Hi,

I've been experimenting with OO recently (on Windows and mac OS) and have come across what would be a show stopper for me - the seeming inability to open "Excel 2003 XML" documents. When I try, either from Calc or by double clicking, they always open in Writer in an unusable format instead of being a regular spreadsheet which I can work on. I've only been able to test this on Windows so far - my Mac is at home.

If I resave this document in Excel as "Excel Workbook" it is then OK in Calc - but that's no use to me as our users receive Excel 2003 XML files from an automaticed system which they need to be able to work on.

I've tested in both OO2.4 and the 3.0 beta on seperate PCs and get the exact same results. Any advice?

Nick.
nickduddy
 
Posts: 2
Joined: Fri May 09, 2008 5:32 am

Re: Opening Excel 2003 XML docs ends up in Writer

Postby Hagar Delest » Fri May 09, 2008 10:22 am

Can you upload a sample file here? It seems to work fine usually: Microsoft Excel 2003 XML (xml) support?
AOO 4.1.7 on Xubuntu 20.04 and 4.1.5 on Windows 10 (with winPenPack port).
User avatar
Hagar Delest
Moderator
 
Posts: 28951
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Opening Excel 2003 XML docs ends up in Writer

Postby nickduddy » Sat May 10, 2008 3:11 am

Actually, I can now add a bit to the puzzle.

After looking more closely at these documents and then replicating it with a dummy doc, I can see that these documents are essentially the result of a 'save as webpage' in Excel, NOT an Excel XML format. They are programatically generated really and it's an external system which we won't be able to have modified.

As documents, they open up in a presentable but varying formats in browsers, I tested IE and Firefox on Windows and Safari and Firefox on my Mac. The 'problem' is that as they are used in my business, they need to be opened and editable as a spreadsheet and so far I haven't been able to do that in anything but Excel.

I'm going to keep poking about but maybe just have to accept that OO hasn't got this capability at this time. I'd love to know if it's on the roadmap or if it's been discussed before.
nickduddy
 
Posts: 2
Joined: Fri May 09, 2008 5:32 am

Re: Opening Excel 2003 XML docs ends up in Writer

Postby Hagar Delest » Fri May 16, 2008 10:24 pm

I don't know, try the issue tracker and upload a file sample on their site (giving all the details for the external application): [Tutorial] Reporting bugs.
AOO 4.1.7 on Xubuntu 20.04 and 4.1.5 on Windows 10 (with winPenPack port).
User avatar
Hagar Delest
Moderator
 
Posts: 28951
Joined: Sun Oct 07, 2007 9:07 pm
Location: France


Return to Calc

Who is online

Users browsing this forum: No registered users and 17 guests