Bug 72734 (CDATA-import) - FILEOPEN xml : cannot import when xml contains CDATA
Summary: FILEOPEN xml : cannot import when xml contains CDATA
Status: RESOLVED WORKSFORME
Alias: CDATA-import
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.1.3.2 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Format-Filters
  Show dependency treegraph
 
Reported: 2013-12-15 17:49 UTC by thierry.deillon
Modified: 2021-11-02 10:35 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
xml with CDATA (84 bytes, application/xml)
2013-12-15 17:49 UTC, thierry.deillon
Details

Note You need to log in before you can comment on or make changes to this bug.
Description thierry.deillon 2013-12-15 17:49:18 UTC
Created attachment 90805 [details]
xml with CDATA

XML documents containing CDATA cannot be imported : the document structure is not detected => no way to assign a tag to a cell.
Comment 1 retired 2013-12-31 11:25:22 UTC
Confirmed:4.2.0.1:OSX

Setting to NEW. I try to open the test document with LO 4.2.0.1 and get an immideate crash.
Comment 2 QA Administrators 2015-04-19 03:23:32 UTC Comment hidden (obsolete)
Comment 3 Buovjaga 2015-06-19 14:25:26 UTC
Opens as plain text.

Win 7 Pro 64-bit Version: 5.1.0.0.alpha1+
Build ID: 437210d58f32177ef1829d704f7f4d2f1bbfbfdd
TinderBox: Win-x86@39, Branch:master, Time: 2015-06-18_07:21:56
Locale: fi-FI (fi_FI)
Comment 4 QA Administrators 2016-09-20 10:12:02 UTC Comment hidden (obsolete)
Comment 5 eisa01 2018-03-17 14:19:01 UTC
Still present

Version: 6.1.0.0.alpha0+
Build ID: 8e8dd8f320a3ff59ff8a16c1a7a867888ce80700
CPU threads: 2; OS: Mac OS X 10.12.6; UI render: default; 
TinderBox: MacOSX-x86_64@49-TDF, Branch:master, Time: 2018-03-13_23:59:29
Locale: en-US (en_US.UTF-8); Calc: group
Comment 6 QA Administrators 2019-03-18 03:45:46 UTC Comment hidden (obsolete)
Comment 7 eisa01 2019-04-20 17:29:02 UTC
This is still present

Version: 6.3.0.0.alpha0+
Build ID: ea9c13be02ba731074fa4207944ff7df40a0fb5c
CPU threads: 2; OS: Mac OS X 10.13.6; UI render: default; VCL: osx; 
TinderBox: MacOSX-x86_64@49-TDF, Branch:master, Time: 2019-04-10_20:43:17
Locale: en-US (en_US.UTF-8); UI-Language: en-US
Calc: threaded
Comment 8 mhonline 2020-01-21 23:21:39 UTC
opposit to the help-file, the feature Import flat XML (without schema) to Calc (Menu/Data/XML-Source) is still not really implemented (LO 6.3.3), even the simple implemented version does not do, what is expected.
This issue is about 7 years open now. 

m.
Comment 9 Kevin Suo 2021-11-02 10:35:20 UTC
There is no such issue with the current 7.2 branch and master. Close as WORKSFORME. Please reset to NEW if you can still reproduce with the newer versions.

Just to clarify, the correct steps to import the xml source is via "Data -> XML Source" in Calc (and then select the source file so that you can assign the tree element to cells), not by opening the xml directly.

This function is handled by the liborcus filter and orcus has gained a lot of improvements thus it should have been fixed someone.

I guess it was fixed in Orcus in:
https://gitlab.com/orcus/orcus/-/commit/714645bcaa12155868ea33c55e917ca8e80d60f6
in year 2013 (this bug was reported at the end of 2013, maybe at that time the orcus version used by libreoffice has not yet been upgraded).