Created attachment 161945 [details] 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.
Created attachment 161946 [details] Test xlsx file saved from the ODS file
No repro with: Version: 7.1.0.0.alpha0+ (x64) Build ID: ff508f6d8a3e58d29e9e7622006a7103fb0a2849 CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; VCL: win Locale: hu-HU (hu_HU); UI: en-US Calc: CL (from win64-bibisect-7.1 this does not contain other UI languages than en-US)
i can't reproduce it in Version: 7.1.0.0.alpha0+ Build ID: 70479e1f4cb3c120f46239a648e65f035af2922d CPU threads: 4; OS: Linux 4.19; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded and MSO 2010 Could you please try to reproduce it with a master build from http://dev-builds.libreoffice.org/daily/master/ ? You can install it alongside the standard version. I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' if the bug is still present in the master build
Also not reproduced in Version: 6.4.4.0.0+ Build ID: 4f8325dbcb63627997289889a377a4893e03fcf1 CPU threads: 4; OS: Linux 4.19; UI render: default; VCL: gtk3; Locale: en-US (en_US.UTF-8); UI-Language: en-US Calc: threaded
Dear Kevin Suo, This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INSUFFICIENTDATA due to lack of needed information. For more information about our NEEDINFO policy please read the wiki located here: https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed. Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-NeedInfo-Ping
Dear Kevin Suo, Please read this message in its entirety before proceeding. Your bug report is being closed as INSUFFICIENTDATA due to inactivity and a lack of information which is needed in order to accurately reproduce and confirm the problem. We encourage you to retest your bug against the latest release. If the issue is still present in the latest stable release, we need the following information (please ignore any that you've already provided): a) Provide details of your system including your operating system and the latest version of LibreOffice that you have confirmed the bug to be present b) Provide easy to reproduce steps – the simpler the better c) Provide any test case(s) which will help us confirm the problem d) Provide screenshots of the problem if you think it might help e) Read all comments and provide any requested information Once all of this is done, please set the bug back to UNCONFIRMED and we will attempt to reproduce the issue. Please do not: a) respond via email b) update the version field in the bug or any of the other details on the top section of our bug tracker Warm Regards, QA Team MassPing-NeedInfo-FollowUp