Issue 105403 - Need an XML filter to convert XML document into a table
Summary: Need an XML filter to convert XML document into a table
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: version58
Hardware: All All
: P2 Trivial with 1 vote (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2009-09-28 08:00 UTC by walidz
Modified: 2013-01-29 21:38 UTC (History)
3 users (show)

See Also:
Issue Type: FEATURE
Latest Confirmation in: ---
Developer Difficulty: ---

xml file (17.36 KB, text/xml)
2009-09-28 08:02 UTC, walidz
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description walidz 2009-09-28 08:00:30 UTC
Opening an XML file is trivial task in ms excel . I can easily open any XML
document from MS. Excel and it is automatically converted into a table ,without
the need to specify any schema

However, Calc does not have this feature , the Writer opens it as normal text file

I assigned this issue P2 , since most database applications now can export their
data into XML format , and Calc should handle these data intuitively

Attached an XML file , 
1- open it from  excel : the file is converted into a table with filter header
2- open it from Calc : the Writer will open it as a normal text file
Comment 1 walidz 2009-09-28 08:02:26 UTC
Created attachment 65000 [details]
xml file
Comment 2 Snigdha 2012-10-01 04:56:44 UTC
Platform: Windows 7
Configuration: Open Office 3.4.1 developer snapshot

This bug is a feature bug where it fails to perform a particular functionality.
Function is to open an xml document in the table format. When xml doc is opened in Excel it is opened in table format but when the same xml doc is opened in Calc it is opened in normal text format.

I was able to replicate the bug in the specified environment and here are steps to reproduce it.

Steps to reproduce:
1. download or create an xml document
2. open the xml document using Calc, we can see that doc is opened in normal text format
3. open the same xml document in Excel and it will be converted into table format.

This is a bug and as it is crucial to convert an xml document data into table format, this bug has more priority and that is why it is a P2 bug. 

Submitted by : Snigdha Chennadi
Commented on : Sept,30th
Comment 3 Regina Henschel 2012-10-01 13:49:15 UTC
Such filer is indeed missing. The file contains structured data generated by "Oracle Reports".
Comment 4 Regina Henschel 2012-10-04 21:47:27 UTC
Please have a look at
and (9 pages)

They describe how to do it.