MS Excel 2003 XML filter failed

Discuss the spreadsheet application
Post Reply
fillera
Posts: 2
Joined: Fri Oct 02, 2009 9:51 pm

MS Excel 2003 XML filter failed

Post by fillera »

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 133 times
OpenOffice.org 3.1.1 (Linux OpenSUSE 11.0)
User avatar
Villeroy
Volunteer
Posts: 31264
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: MS Excel 2003 XML filter failed

Post by Villeroy »

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 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
fillera
Posts: 2
Joined: Fri Oct 02, 2009 9:51 pm

Re: MS Excel 2003 XML filter failed

Post by fillera »

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 147 times
OpenOffice.org 3.1.1 (Linux OpenSUSE 11.0)
User avatar
Cambirder
Volunteer
Posts: 647
Joined: Thu Nov 22, 2007 1:01 am

Re: MS Excel 2003 XML filter failed

Post by Cambirder »

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
Post Reply