MS Excel 2003 XML filter failed

Discuss the spreadsheet application

MS Excel 2003 XML filter failed

Postby fillera » Fri Oct 02, 2009 10:12 pm

Hi,

I'm trying to open in Calc a MS Excel 2003 spreadsheet saved on XML format.

Calc only shows XML tags in the first column, without decode them.

When I try to probe MS Excel 2003 XML import filter (from menu-bar: Tools / XML filter configuration), Calc shows only one blank sheet.

An example file is attached on this post.

Any idea would be appreciate.

Thanks in advanced.

Fernando
Attachments
ejemplo.zip
(2.08 KiB) Downloaded 48 times
OpenOffice.org 3.1.1 (Linux OpenSUSE 11.0)
fillera
 
Posts: 2
Joined: Fri Oct 02, 2009 9:51 pm

Re: MS Excel 2003 XML filter failed

Postby Villeroy » Sat Oct 03, 2009 10:26 am

No program can do anything with that file since it is not valid XML (at least this is what FIrefox tells me about it).
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 12.04, Apache OpenOffice 4.x
User avatar
Villeroy
Volunteer
 
Posts: 17291
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: MS Excel 2003 XML filter failed

Postby fillera » Sat Oct 03, 2009 12:46 pm

Thanks a lot Villeroy,

I have solved syntax bugs in the original xml file, and I can view it in my browser (FireFox) without mistakes.

However, when I try to open it with Calc, I get the same effect: xml tags are showed in the first column of the spreadsheet without decoding.

An example file is attached on this post.

Again, any idea would be appreciate.

Thanks in advanced.
Fernando
Attachments
ejemplo.xml.zip
(6.33 KiB) Downloaded 49 times
OpenOffice.org 3.1.1 (Linux OpenSUSE 11.0)
fillera
 
Posts: 2
Joined: Fri Oct 02, 2009 9:51 pm

Re: MS Excel 2003 XML filter failed

Postby Cambirder » Sat Oct 03, 2009 1:56 pm

Afraid I can't open that file in FF I get the following error message

This XML file does not appear to have any style information associated with it. The document tree is shown below. (I've not posted the tree)

I can open the file in Excel 2007, and if I do a straight save the file opens in Calc so that would seem to be do to something Excel 2003 is doing. Still get that error message in FF though.
OOo 3.3 on Windows 7 & 3.2.1 on Mint 10
User avatar
Cambirder
Volunteer
 
Posts: 647
Joined: Thu Nov 22, 2007 1:01 am


Return to Calc

Who is online

Users browsing this forum: Google [Bot] and 19 guests