we are using libre office 3.5. some of the xml file generated by oracle xml publisher are not opening in libre office and some files which are opening are not showing full data. That is when we are opening the file in Windows Excel, there are 3000 rows, libre office is showing only 2000 rows.
kindly help.
Thanks & Regards
Rampal
What’s the exact output format? I suppose it isn’t plain XML but any of the MS Office formats, maybe xsl / xlsx. So, would it be possible to select another output format?
HI,
It is .xml format only.
Thanks & Regards
Hi @RampalKumar, Please file a bug about this problem. The QA team will be happy to help you track down this issue! Thanks!
Had similar problem in 3.6 (even worse - could not open particular xml file at all). Try LibreOffice 4.0. For me all problems with xml were solved in it.
Hi @RampalKumar,
It’s not clear to me if this is a shortcoming in LibreOffice, or if it’s an enhancement to request (e.g. feature parity/superset with MS-Office), but in either case, please file a bug about this problem. The QA team will be happy to help you get to the root of this import issue.
Please post a link to any bugs you file in a comment below using the format “fdo#123456”.
Thanks!
We need to be careful here: the problem is not necessarily with LibreOffice.
Oracle BI Publisher is a complex application for which templates can be created in different applications. The XML you have been trying to open in Calc is probably not OOXML. More details about the document’s creation and content would be needed, but for all we know, it might be that this XML is either not well-formed/not valid or perhaps just bad.
If further investigation reveals that this Oracle BI Publisher XML is valid and should give adequate results in any XML tool, then we are facing a great opportunity to improve LibreOffice’s handling of XML even more.
@CyanCG, Note that Rampal Kumar is able to open the file in both Excel and Calc, it’s just that less data is showing in Calc. That sounds like a good candidate for an enhancement (even if the XML is invalid). Calc should aim to handle all files Excel can handle (plus more 
@qubit1 you’re right, I wasn’t thinking about it that way. By the way, right now, how does LibreOffice normally handle invalid or ill-formed XML? Does it offer to step through the document’s errors?
@CyanCG – re: ill-formed XML, I’m not sure (but that’s probably another great question to ask on this site