Issue 105403

Summary: Need an XML filter to convert XML document into a table
Product: Calc Reporter: walidz <openoffice>
Component: open-importAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P2 CC: issues, rb.henschel, schennad
Version: version58   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: FEATURE Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
xml file none

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 OpenOffice.org 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
  http://www.ibm.com/developerworks/xml/library/x-oocalc/
and (9 pages)
  http://www.ibm.com/developerworks/xml/library/x-oocalc/

They describe how to do it.