Description: If I save to XLS or XLSX, when open in Excel wants to repair file but is not successful Steps to Reproduce: 1.opens xlsx in LO 2.save to ODS 3.open in Excel, responds err1.pn 4. open with LO 6-4-7-2 and 7-4-0-0 responds warning err2.png Actual Results: gets error Excel cannot repair Expected Results: should work Reproducible: Always User Profile Reset: No Additional Info: [Information automatically included from LibreOffice] Locale: en-GB Module: SpreadsheetDocument [Information guessed from browser] OS: Linux (All) OS is 64bit: yes Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 529dce3d5b695637a1ccc8b4b697d87c5db0d3a2 CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: en-GB (en_GB.UTF-8); UI: en-GB Calc: threaded
Created attachment 188552 [details] original source file created by Excel
Created attachment 188553 [details] Save orginal excel file to ODS
Created attachment 188554 [details] then tried LO v6.4 to save file - it worked as it should
Created attachment 188555 [details] the unrecoverable error when opening in Office365
Created attachment 188556 [details] the msg LO v6.4 and v7.4 report note this is a warning, but does not sop opening file
Please clarify your steps and the summary/description as they don't match: do you open the ODS or the XLSX in Office 365 and LO? Regarding the message in LO, this is related to large spreadsheets. It might depend on if you have the experimental "very large spreadsheet" setting turned on in 24.2. Thank you!
Created attachment 188564 [details] xlsx created in excel, opend in LOdev and saved to new name
Created attachment 188565 [details] saved using Calc 7.3
Created attachment 188566 [details] xlsx opened in O365 and saved to ODS has error in Calc, and in O365
Created attachment 188567 [details] error that O365 gives
This is the way I work: I have a VM with Win10. I don't work in Wu=in unless I have to I have been working with LOdev versions for as long as I can remember - just every now and then I get problems then I revert back to the previous working Dev version. If someone sends me an xlsx to work with, I will save it as an ODS then when happy will save to xlsx and send to the Win users. I checked Win and it has opened ODS files up to 17Jul23, since i do not have any ODS files saved to XLSX but the Stable version 7.3 and 7.4 saving to XLSX also give the error in Win Also note that I saved the T-1...xlsx file in Win to ODS, and when I tried to open the ODS, I got the error that is T-1...png
[Automated Action] NeedInfo-To-Unconfirmed
I typically download dev on a Tuesday, these were the dates I did, I prefix the zips with upload date: 230607; 230613; 230627; 230703; 230721; 230725 I delete older ones when when issues I have reported have been resolved. I also upgrade Linux Mint Cinnamon (LMC) 21.1 to 21.2 on 230718, but reversed that on 24th because of other issues. The download on 21st was thus whilst I was on LMC21.2; and I was working with a colleague who is using Win and that I picked up the problem when she could not open my XLSX. Then tried out the LO7.3 and found that it did the same. The LO6.4 example came from a LMC20.1 VM that I created because of having some problems with older versions of some apps. Not sure if this detail helps.
Confirming in Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 34387332173782498acd4998c7c665d04ebc3c7d CPU threads: 15; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: hu-HU (hu_HU); UI: en-US Calc: threaded that ODS attachment 188553 [details] saved to xlsx and opened in Excel gives unreadable content error and repairs it with message: Removed Part: /xl/drawings/drawing2.xml part. (Drawing shape) Repaired Part: /xl/worksheets/sheet1.xml part. The sheet1.xml issue seems to be reproducible by saving either the original xlsx or the ods, with any LO version to xlsx. Tried 3.3, 4.0, 5.0, 6.0, 7.x to 24.2master - all seems to be bad (maybe not for the same reason from Excels point of view, but that's irrelevant in the end). Let's set that aside for a separate report. The issue with the Drawing shape (there is a chart on a hidden sheet, that seems to be the culprit) begun in 7.3 with: https://git.libreoffice.org/core/+log/f547cf17a179ebd7de5c2b4dd2d00d0027a25429 author Dennis Francis <dennisfrancis.in@gmail.com> Thu Sep 02 14:33:55 2021 +0530 committer Miklos Vajna <vmiklos@collabora.com> Mon Sep 06 08:47:50 2021 +0200 [API CHANGE] oox: fix import of chart date categories Adding CC to: Dennis Francis
Created attachment 188816 [details] Minimized example file
There was a hidden sheet in the fiile which was a mess, in a workbook received from a colleague. When I deleted the sheet, everything was fine. The offending sheet had been created years ago.