Bug 94982 - FILEOPEN XML Contents of a FastReport .xml not shown entirely (see comment 12)
Summary: FILEOPEN XML Contents of a FastReport .xml not shown entirely (see comment 12)
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.5.0 release
Hardware: x86 (IA32) All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: orcus_bugs
  Show dependency treegraph
 
Reported: 2015-10-12 12:14 UTC by Denis K
Modified: 2021-11-05 05:20 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:


Attachments
screenshot and example of xls-file (107.43 KB, application/zip)
2015-10-12 12:14 UTC, Denis K
Details
screenshot and example of xls-file (49.60 KB, application/zip)
2015-10-14 05:57 UTC, Denis K
Details
Problematic xml file (19.38 KB, text/xml)
2018-12-04 12:54 UTC, Buovjaga
Details
PDF file showing the xls (xml) file open in MSO 2010 (127.85 KB, application/pdf)
2021-11-02 10:47 UTC, Kevin Suo
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Denis K 2015-10-12 12:14:18 UTC
Created attachment 119534 [details]
screenshot and example of xls-file

Hello.

Версия: 5.0.2.2
ID сборки: 37b43f919e4de5eeaca9b9755ed688758a8251fe
Локаль: ru-RU (ru_RU)
OS: Windows 7 pro, v6.1.7601, x86

Calc: Error opening XLS-file, created by export from FastReport v3.20 preview. 
MS Office Excel opens this file correctly.
XLS-file created by FastReport v4.0.58 opens correctly.

Tested in Libre Office 4.4.2.1, 5.0.2.2, 5.0.1.2

In attachments:
- load_xls_from_fastreport.jpg: screenshot with error message
- fr3_preview_export.jpg: how make export file from FastReport toolbar in application
- xls_from_fr3.xls: example xls-file, created FR 3.20
Comment 1 raal 2015-10-12 16:38:00 UTC
Attachment does not contain xls file (contain wks file). Attach correct attachment.
Comment 2 Denis K 2015-10-14 05:57:36 UTC
Created attachment 119593 [details]
screenshot and example of xls-file

proper file with screenshot and example of xls-file. Previous file is wrong.
Comment 3 Buovjaga 2015-10-14 17:01:55 UTC
Confirmed.

Win 7 Pro 64-bit, Version: 5.0.2.2 (x64)
Build ID: 37b43f919e4de5eeaca9b9755ed688758a8251fe
Locale: fi-FI (fi_FI)

LibreOffice 3.5.0rc3 
Build ID: 7e68ba2-a744ebf-1f241b7-c506db1-7d53735
Comment 4 QA Administrators 2016-11-08 11:12:20 UTC Comment hidden (obsolete)
Comment 5 Denis K 2016-11-20 18:21:28 UTC
Bug is present.

Версия: 5.2.3.3 (x64)
ID сборки: d54a8868f08a7b39642414cf2c8ef2f228f780cf
Потоков ЦП: 4; Версия ОС: Windows 6.29; Отрисовка ИП: по умолчанию; 
Локаль: ru-RU (ru_RU); Calc: single
Comment 6 raal 2016-11-20 19:19:52 UTC
command line error:
Entity: line 460: parser error : xmlParseCharRef: invalid xmlChar value 0
<Data ss:Type="String">&#49&#48.&#49&#50.&#50&#48&#49&#53</Data>
Comment 7 Denis K 2016-11-21 12:11:39 UTC
Bug is present.

Версия: 5.3.0.0.alpha1
ID сборки: f4ca1573fcf445164c068c1046ab5d084e1b005f
Потоков ЦП: 2; Версия ОС: Windows 6.1; Отрисовка ИП: по умолчанию; 
Локаль: ru-RU (ru_RU); Calc: CL
Comment 8 QA Administrators 2017-11-22 15:41:15 UTC Comment hidden (obsolete)
Comment 9 Denis K 2017-11-27 16:42:24 UTC
Yes, bug is still present with the latest version of LibreOffice.

Версия: 5.4.3.2 (x64)
ID сборки: 92a7159f7e4af62137622921e809f8546db437e5
Потоков ЦП: 4; ОС:Windows 6.29; Отрисовка ИП: по умолчанию; 
Локаль: ru-RU (ru_RU); Calc: single
Comment 10 QA Administrators 2018-11-28 03:48:22 UTC Comment hidden (obsolete)
Comment 11 Denis K 2018-12-03 18:00:10 UTC
No error while opening xls-file. Tested in versions 6.1.1.2 and 6.1.3.2.
But, when file is open, there is no data on the sheet.

Версия: 6.1.1.2 (x64)
ID сборки: 5d19a1bfa650b796764388cd8b33a5af1f5baa1b
Потоков ЦП: 4; ОС:Windows 10.0; Отрисовка ИП: GL; 
Локаль: ru-RU (ru_RU); Calc: group threaded

Версия: 6.1.3.2 (x64)
ID сборки: 86daf60bf00efa86ad547e59e09d6bb77c699acb
Потоков ЦП: 4; ОС:Windows 10.0; Отрисовка ИП: GL; 
Локаль: ru-RU (ru_RU); Calc: group threaded
Comment 12 Buovjaga 2018-12-04 12:54:28 UTC
Created attachment 147273 [details]
Problematic xml file

The .xls was in fact an .xml. So the wrong file extension is throwing LibreOffice off now.
In older versions, even the .xml gives General error. Now it opens, but does not show all the contents.

Arch Linux 64-bit
Version: 6.3.0.0.alpha0+
Build ID: 9059457a1a8385cb80b5dd2c797cee77af4222a9
CPU threads: 8; OS: Linux 4.19; UI render: default; VCL: gtk3_kde5; 
Locale: fi-FI (fi_FI.UTF-8); UI-Language: en-US
Calc: threaded
Built on 30 November 2018
Comment 13 QA Administrators 2019-12-05 04:26:36 UTC Comment hidden (obsolete)
Comment 14 Kevin Suo 2021-11-02 10:45:13 UTC
File opens on 7.2 and master branch, but some content is not shown. May be a bug in the orcus SAX parser.
Comment 15 Kevin Suo 2021-11-02 10:47:03 UTC
Created attachment 176077 [details]
PDF file showing the xls (xml) file open in MSO 2010
Comment 16 Kevin Suo 2021-11-04 01:33:30 UTC
Yes, this is an Orcus bug. The parse result returned by Orcus is already not complete, content for only one cell is shown.
Comment 17 Kevin Suo 2021-11-05 05:18:40 UTC
From Kohei's comment in the Orcus issue ticket, the reason is that the XML contained in the test file is invalid.

Specifically, the character references such as &#48 are missing the closing ";" to complete the encoded character. Without that, this XML file is invalid.

While we can try to be too strict in following the standars and to to fix this, it take time. It is mentioned that this file is was generated by FastReport v3.20 preview, and you also mentioned that FastReport v4.0.58 opens correctly, thus FastReport must had realized the issue and fixed that in their code base.

For this reason I close this as NOTABUG.
Comment 18 Kevin Suo 2021-11-05 05:20:55 UTC
Sorry, typo ...file created by FastReport v4.0.58 opens correctly.