[Libreoffice-bugs] [Bug 133955] New: FILESAVE XLSX: Resaving ODS to XLSX and Reopen With MSO Causes Error Warnings

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 133955
           Summary: FILESAVE XLSX: Resaving ODS to XLSX and Reopen With
                    MSO Causes Error Warnings
           Product: LibreOffice
           Version: 6.4.4.2 release
          Hardware: All
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: suokunlong at 126.com

Created attachment 161945
  --> https://bugs.documentfoundation.org/attachment.cgi?id=161945&action=edit
Test ODS file

------------------
Steps to Reproduce:
------------------

1. Download the World Bank historical classification of countries by income
spreadsheet in the following link:

Webpage:
https://datahelpdesk.worldbank.org/knowledgebase/articles/906519-world-bank-country-and-lending-groups

Direct link:
http://databank.worldbank.org/data/download/site-content/OGHIST.xls

2. Open that xls file with Calc, move the tab named "Country Analytical
History" to a new spreadsheet, using the "Move/Copy Worksheet" context mene.
Then save this new spreadsheet as an ODS file.

3. Save the ODS file generated in step 2 to an XLSX file, and then open the
XLSX file with Microsoft Office Excel 2010.

----------------
Current Result:
----------------

Excel shows a warning message indicates there is unreadable contents in the
xlsx file, asking whether to try to repair. If choose "Yes", it gives the
following repair result (translated):

Deleted component: with XML error in /xl/externalLinks/externalLink1.xml.
(Cached value from reference to external formula) invalid name characters. Row
2, column 768.
Removed function: /xl/workbook.xml partial external formula reference
(workbook).
Deleted records: /xl/worksheets/sheet1.xml partial formula.
Repared records: /xl/worksheets/sheet1.xml partial cell information.
Repared records: /xl/worksheets/sheet1.xml partial column information.
Repared records: /xl/worksheets/sheet1.xml Partial conditional formating.

----------------
Expected Result:
----------------

Calc should generate a valid xlsx file and be opened without error in MSO.

版本: 6.4.4.0.0+
Build ID: 2dfd8f48d11b05243b9b4b315be94f86e09480df
CPU 线程: 4; 操作系统: Linux 5.6; UI 渲染: 默认; VCL: gtk3; 
区域语言: zh-CN (zh_CN.UTF-8); UI 语言: zh-CN
Calc: threaded

Fedora 32 x64.

-- 
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/20200613/894d8999/attachment.htm>