[Libreoffice-bugs] [Bug 143958] New: FILEOPEN: Can't open third-party generated XLSX file, docProps/custom.xml related

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=143958

            Bug ID: 143958
           Summary: FILEOPEN: Can't open third-party generated XLSX file,
                    docProps/custom.xml related
           Product: LibreOffice
           Version: 7.0.6.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Keywords: filter:xlsx
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: plateauwolf at qq.com

Created attachment 174428
  --> https://bugs.documentfoundation.org/attachment.cgi?id=174428&action=edit
Sample file provided by the original reporter

This is a bug report translated and forwarded from a Chinese LibreOffice user
forum.  The original report (in Chinese) is:
https://bbs.libreofficechina.org/thread-2881-1-1.html

Description:

The XLSX format files exported from 金蝶 (Kingdee) ERP system's web tools can't
be opened by LibreOffice, while MS Office and Kingsoft WPS open them correctly.
 Sample file attached.

>From the analysis in the original report, it seems the culprit is in the XLSX
file's docProps/custom.xml file.  It starts with (after the mandatory <?xml
version="1.0"?> line):
<q1:Properties
xmlns:vt="http://schemas.openxmlformats.org/officeDocument/2006/docPropsVTypes"
xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"
xmlns:q1="http://schemas.openxmlformats.org/officeDocument/2006/custom-properties">
If one changes that line to
<q1:Properties
xmlns:q1="http://schemas.openxmlformats.org/officeDocument/2006/custom-properties"
...
i.e., move the "xmlns:q1" part to the first place, the file can be opened by
LibreOffice.

I don't know what the OOXML standard says, but since MS Office accepts such a
file, unless it's strictly forbidden by the standard, having LO allow such a
small deviation from the proper order should be beneficial to users.

Additional information:

I can reproduce that neither LO 7.0.6 or 7.2.0 RC3 can open the attached sample
file:

Version: 7.0.6.2 (x64)
Build ID: 144abb84a525d8e30c9dbbefa69cbbf2d8d4ae3b
CPU threads: 2; OS: Windows 10.0 Build 19043; UI render: default; VCL: win
Locale: zh-CN (zh_CN); UI: en-US
Calc: threaded

Version: 7.2.0.3 (x64) / LibreOffice Community
Build ID: 2a7ea282da28d665a7dc086360567b4aea27bf08
CPU threads: 2; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win
Locale: zh-CN (zh_CN); UI: zh-CN
Calc: threaded

7.2.0 RC3 first claims the file may be damaged and offers to repair it, but
when told "yes", can not repair and returns "General input/output error". 
7.0.6 just gives "General input/output error" directly.

Another user (not the original reporter) can reproduce that the sample file
opens in MS Office 2016 for Windows and MS Office 365 for Mac without problems.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210819/f1b739c0/attachment-0001.htm>