Apache OpenOffice (AOO) Bugzilla – Issue 105403
Need an XML filter to convert XML document into a table
Last modified: 2013-01-29 21:38:46 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
Created attachment 65000 [details] xml file
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
Such filer is indeed missing. The file contains structured data generated by "Oracle Reports".
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.