[Libreoffice-bugs] [Bug 156465] save to xls and xlsx files corrupted
https://bugs.documentfoundation.org/show_bug.cgi?id=156465 Stéphane Guillou (stragu) changed: What|Removed |Added Regression By||Dennis Francis Version|7.3.0.3 release |7.3.0.0.alpha1+ See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=14 ||8117, ||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=14 ||6826 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 156465] save to xls and xlsx files corrupted
https://bugs.documentfoundation.org/show_bug.cgi?id=156465 Aron Budea changed: What|Removed |Added Blocks||104839 OS|Linux (All) |All CC||aron.bu...@gmail.com Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=104839 [Bug 104839] [META] Saved XLSX files that MS Excel can't open -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 156465] save to xls and xlsx files corrupted
https://bugs.documentfoundation.org/show_bug.cgi?id=156465 --- Comment #15 from Gabor Kelemen (allotropia) --- Created attachment 188816 --> https://bugs.documentfoundation.org/attachment.cgi?id=188816=edit Minimized example file -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 156465] save to xls and xlsx files corrupted
https://bugs.documentfoundation.org/show_bug.cgi?id=156465 Gabor Kelemen (allotropia) changed: What|Removed |Added Blocks||75057 Status|UNCONFIRMED |NEW Version|24.2.0.0 alpha0+ Master |7.3.0.3 release CC||dennisfrancis...@gmail.com, ||kelem...@ubuntu.com Keywords||bibisected, bisected, ||regression Ever confirmed|0 |1 --- Comment #14 from Gabor Kelemen (allotropia) --- 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 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 Thu Sep 02 14:33:55 2021 +0530 committer Miklos Vajna Mon Sep 06 08:47:50 2021 +0200 [API CHANGE] oox: fix import of chart date categories Adding CC to: Dennis Francis Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=75057 [Bug 75057] [META] OOXML Chart object issues -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 156465] save to xls and xlsx files corrupted
https://bugs.documentfoundation.org/show_bug.cgi?id=156465 --- Comment #13 from Elmar --- 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. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 156465] save to xls and xlsx files corrupted
https://bugs.documentfoundation.org/show_bug.cgi?id=156465 QA Administrators changed: What|Removed |Added Ever confirmed|1 |0 Status|NEEDINFO|UNCONFIRMED -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 156465] save to xls and xlsx files corrupted
https://bugs.documentfoundation.org/show_bug.cgi?id=156465 --- Comment #12 from QA Administrators --- [Automated Action] NeedInfo-To-Unconfirmed -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 156465] save to xls and xlsx files corrupted
https://bugs.documentfoundation.org/show_bug.cgi?id=156465 --- Comment #11 from Elmar --- 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 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 156465] save to xls and xlsx files corrupted
https://bugs.documentfoundation.org/show_bug.cgi?id=156465 --- Comment #10 from Elmar --- Created attachment 188567 --> https://bugs.documentfoundation.org/attachment.cgi?id=188567=edit error that O365 gives -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 156465] save to xls and xlsx files corrupted
https://bugs.documentfoundation.org/show_bug.cgi?id=156465 --- Comment #9 from Elmar --- Created attachment 188566 --> https://bugs.documentfoundation.org/attachment.cgi?id=188566=edit xlsx opened in O365 and saved to ODS has error in Calc, and in O365 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 156465] save to xls and xlsx files corrupted
https://bugs.documentfoundation.org/show_bug.cgi?id=156465 --- Comment #8 from Elmar --- Created attachment 188565 --> https://bugs.documentfoundation.org/attachment.cgi?id=188565=edit saved using Calc 7.3 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 156465] save to xls and xlsx files corrupted
https://bugs.documentfoundation.org/show_bug.cgi?id=156465 --- Comment #7 from Elmar --- Created attachment 188564 --> https://bugs.documentfoundation.org/attachment.cgi?id=188564=edit xlsx created in excel, opend in LOdev and saved to new name -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 156465] save to xls and xlsx files corrupted
https://bugs.documentfoundation.org/show_bug.cgi?id=156465 Stéphane Guillou (stragu) changed: What|Removed |Added Status|UNCONFIRMED |NEEDINFO CC||stephane.guillou@libreoffic ||e.org Ever confirmed|0 |1 --- Comment #6 from Stéphane Guillou (stragu) --- 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! -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 156465] save to xls and xlsx files corrupted
https://bugs.documentfoundation.org/show_bug.cgi?id=156465 --- Comment #5 from Elmar --- Created attachment 188556 --> https://bugs.documentfoundation.org/attachment.cgi?id=188556=edit the msg LO v6.4 and v7.4 report note this is a warning, but does not sop opening file -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 156465] save to xls and xlsx files corrupted
https://bugs.documentfoundation.org/show_bug.cgi?id=156465 --- Comment #4 from Elmar --- Created attachment 188555 --> https://bugs.documentfoundation.org/attachment.cgi?id=188555=edit the unrecoverable error when opening in Office365 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 156465] save to xls and xlsx files corrupted
https://bugs.documentfoundation.org/show_bug.cgi?id=156465 --- Comment #3 from Elmar --- Created attachment 188554 --> https://bugs.documentfoundation.org/attachment.cgi?id=188554=edit then tried LO v6.4 to save file - it worked as it should -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 156465] save to xls and xlsx files corrupted
https://bugs.documentfoundation.org/show_bug.cgi?id=156465 --- Comment #2 from Elmar --- Created attachment 188553 --> https://bugs.documentfoundation.org/attachment.cgi?id=188553=edit Save orginal excel file to ODS -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 156465] save to xls and xlsx files corrupted
https://bugs.documentfoundation.org/show_bug.cgi?id=156465 --- Comment #1 from Elmar --- Created attachment 188552 --> https://bugs.documentfoundation.org/attachment.cgi?id=188552=edit original source file created by Excel -- You are receiving this mail because: You are the assignee for the bug.
