Bug 109231 - FILEOPEN: XML: General Error up to LO 6.0 and wrong data from 6.1 when the data contains a < symbol
Summary: FILEOPEN: XML: General Error up to LO 6.0 and wrong data from 6.1 when the da...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: dataLoss
Depends on:
Blocks: File-Opening
  Show dependency treegraph
 
Reported: 2017-07-20 11:40 UTC by Oleg K
Modified: 2023-04-14 18:02 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
problem file (26.54 KB, text/xml)
2017-07-20 11:40 UTC, Oleg K
Details
problem file PDF as shown in MSO (125.33 KB, application/x-pdf)
2018-07-30 10:16 UTC, Timur
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Oleg K 2017-07-20 11:40:48 UTC
Created attachment 134748 [details]
problem file

Trying to open an XML file with LibreOffice and results error dialog which says "General Error. General input/output error."
Comment 1 Xisco Faulí 2017-07-20 14:24:38 UTC
it seems the file doesn't have a correct format. Probably you will get an error if you open it in another app (ie. firefox )
Comment 2 Oleg K 2017-07-20 14:45:19 UTC
This file i can open using Microsoft Office 2007. And I found the problem.
When inner of the node includes the following characters - "<" it fails to open the files. For example  
<Data ss:Type="String">ÄàòàÎêîí÷Àðåíäû<ÄàòàÐåãÄîãÀðåíäû</Data>

May be it has to be the fact that Calc considers "<" as the end of the node, instead of "</"
Comment 3 Julien Nabet 2017-07-24 16:36:12 UTC
On pc Debian testing x86-64, the attached file doesn't open on Firefox 5.2.20, it shows an error.
Comment 4 Timur 2017-07-25 09:59:43 UTC Comment hidden (obsolete)
Comment 5 Julien Nabet 2017-07-25 10:40:02 UTC Comment hidden (obsolete)
Comment 6 Timur 2017-07-25 15:47:39 UTC Comment hidden (obsolete)
Comment 7 Oleg K 2017-07-25 16:09:12 UTC
I'm sorry. But i open this file in Wicrosoft office and wps office to.but Libre office can't open this file. 
Why? The main reason is the how Libre office parse xml. In xml <,> is a special characters and libre office parse whis file how simple xml. 
I think that support libreoffice such files will not be bad overall for the product
Comment 8 Xisco Faulí 2017-07-26 15:19:03 UTC
Confirmed in

Version: 6.0.0.0.alpha0+
Build ID: e0b6a4a2d2dec4e9614f27fc03f84b1c578028ec
CPU threads: 4; OS: Linux 4.8; UI render: default; VCL: gtk3; 
Locale: ca-ES (ca_ES.UTF-8); Calc: group

and

LibreOffice 3.3.0 
OOO330m19 (Build:6)
tag libreoffice-3.3.0.4

If I delete the < from 'ÄàòàÎêîí÷Àðåíäû<ÄàòàÐåãÄîãÀðåíäû' the file is opened correctly
Comment 9 Julien Nabet 2017-07-28 20:19:58 UTC
Perhaps NOTOURBUG because I'm afraid we're dependent on libxslt/libxml2 libraries (for both, last stable versions are used).
Comment 10 QA Administrators 2018-07-29 02:38:48 UTC Comment hidden (obsolete)
Comment 11 Oleg K 2018-07-29 06:24:42 UTC Comment hidden (obsolete)
Comment 12 Timur 2018-07-30 10:16:47 UTC
Created attachment 143819 [details]
problem file PDF as shown in MSO

Oleg, thank you for following your bugs, but: please write version you tested with. And test with master from dev-builds.libreoffice.org/daily/master/.

Up to LO 6.0 we had general error. From LO 6.1 we have worse: no error shown but file opens with wrong data. Attached is PDF how it shows in MSO.
Comment 13 QA Administrators 2019-07-31 02:54:03 UTC Comment hidden (obsolete)
Comment 14 Timur 2019-08-19 10:59:09 UTC Comment hidden (obsolete)
Comment 15 Timur 2021-04-08 13:53:27 UTC
Repro 7.2+. No data shown.
Comment 16 Michael Warner 2021-04-08 23:39:11 UTC
(In reply to Oleg K from comment #7)
> I'm sorry. But i open this file in Wicrosoft office and wps office to.but
> Libre office can't open this file. 
> Why? The main reason is the how Libre office parse xml. In xml <,> is a
> special characters and libre office parse whis file how simple xml. 
> I think that support libreoffice such files will not be bad overall for the
> product

I can think of some ways we could work around this issue but tbh I'm surprised MS Office would produce something like this in the first place. I would expect that to be smarter about escaping angle brackets in content.
Comment 17 QA Administrators 2023-04-09 03:26:14 UTC
Dear Oleg K,

To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present.

If you have time, please do the following:

Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the information from Help - About LibreOffice.
 
If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice.

Please DO NOT

Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not 
appropriate in this case)


If you want to do more to help you can test to see if your issue is a REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/

2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to 'inherited from OOo';
4b. If the bug was not present in 3.3 - add 'regression' to keyword


Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa

Thank you for helping us make LibreOffice even better for everyone!

Warm Regards,
QA Team

MassPing-UntouchedBug