Ask Your Question
0

xml are not opening in libre office and some files which are opening are not showing full data

asked 2012-08-03 13:24:15 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >750 is welcome to improve it.

updated 2013-01-29 15:16:11 +0200

anonymous user

Anonymous

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

delete close flag offensive retag edit

Comments

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?

tohuwawohu ( 2012-08-03 17:15:32 +0200 )edit

HI, It is .xml format only.

Thanks & Regards

Rampal Kumar ( 2012-08-22 07:14:36 +0200 )edit

Hi @Rampal Kumar, Please file a bug about this problem. The QA team will be happy to help you track down this issue! Thanks!

qubit ( 2013-01-29 15:16:53 +0200 )edit
1

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.

Timon ( 2013-02-21 10:58:58 +0200 )edit

2 Answers

Sort by » oldest newest most voted
0

answered 2013-02-21 08:48:51 +0200

qubit gravatar image qubit flag of United States
5721 3 48 41

Hi @Rampal Kumar,

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!

link delete flag offensive edit
0

answered 2013-02-21 23:55:17 +0200

CyanCG gravatar image CyanCG flag of Canada
422 2 7 17
http://waidanian.wordpres...

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.

link delete flag offensive edit

Comments

@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 :-)

qubit ( 2013-02-22 06:09:28 +0200 )edit

@qubit 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 ( 2013-02-22 17:36:01 +0200 )edit

@CyanCG -- re: ill-formed XML, I'm not sure (but that's probably another great question to ask on this site :-)

qubit ( 2013-02-22 19:19:03 +0200 )edit

Login/Signup to Answer

Donate

LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!

Question tools

Follow

subscribe to rss feed

Stats

Asked: 2012-08-03 13:24:15 +0200

Seen: 197 times

Last updated: Feb 21