Bug 102337 - Data > XML Source ... does not read XML if the version number and encoding are specified with single quotes
Summary: Data > XML Source ... does not read XML if the version number and encoding ar...
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.1.4.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Data-XMLsource
  Show dependency treegraph
 
Reported: 2016-09-21 20:32 UTC by la .myrf.
Modified: 2019-08-14 16:18 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
XML file from WHO clinical trials registry (21.01 KB, text/xml)
2016-09-21 20:32 UTC, la .myrf.
Details

Note You need to log in before you can comment on or make changes to this bug.
Description la .myrf. 2016-09-21 20:32:28 UTC
Created attachment 127530 [details]
XML file from WHO clinical trials registry

To reproduce error:

Data > XML Source ...

Select an XML file that begins with:

<?xml version='1.0' encoding='UTF-8' ?>

^ LibreOffice will not read a file that begins like this.

Change file to the following:

<?xml version="1.0" encoding="UTF-8" ?>

LibreOffice will read the file perfectly.

This is important because the WHO Clinical Trials registry automatically generates XML files of the first type, and need to be manually converted to the second. I have attached an example XML file to this bug report.

Here is the link to the WHO page where the XML file was generated:

http://apps.who.int/trialsearch/
Comment 1 Julien Nabet 2016-09-21 21:00:36 UTC
In xml file, there was this:
<?xml version='1.0' encoding='UTF-8" ?>
(with double quote at the end)

But even after replacing this one with simple quote, it doesn't open the XML file on pc Debian x86-64 with master sources updated today.
However, I don't have any error message, it just does nothing and "Import" button stays disabled.
Let's put this one to NEW.
Comment 2 la .myrf. 2016-09-21 22:07:08 UTC
Apologies, I must have uploaded the wrong version of the example file.

It works in LibreOffice with all double-quotes, and it doesn't if there are single quotes.
Comment 3 Aitor 2017-09-28 14:47:14 UTC
XML files generated from SAP J2EE contain single quotes too, and must be manually changed to import with Libreoffice.
Comment 4 QA Administrators 2018-09-29 02:42:04 UTC Comment hidden (obsolete)
Comment 5 himajin100000 2018-09-29 09:14:21 UTC
on my environment, I cannot reproduce this bug, probably due to 

https://gitlab.com/orcus/orcus/commit/321c2e1c61fa5cb2aa793d4d31f8a764658ac521
>Mar 1, 2017 Support single-quoted attribute values

https://gitlab.com/orcus/orcus
version :0.13.1 
Release Date: 2017-11-15

and 

https://opengrok.libreoffice.org/diff/core/download.lst?r1=%2Fcore%2Fdownload.lst%400f73433b&r2=%2Fcore%2Fdownload.lst%4038c4f463
Comment 6 himajin100000 2018-11-20 21:26:25 UTC
Should we close this?
Comment 7 Kohei Yoshida 2019-08-14 16:18:33 UTC
Yeah this issue should be fixed by now.  This was a bug in orcus, which I fixed long ago.  The fix should be incorporated in the current build.