Created attachment 197535 [details] forum-es-7576.xlsx The attached files can all be opened in Excel in their current state. Open them in LO, save them as XLSX, and try opening them in Excel. => Excel is unable to open the files, and shows error message. Here's a list of some files from LO's bugzilla/forum files that are affected (a few of those are attached): forum-mso-de-63075.xls forum-mso-en4-114468.xls forum-mso-en4-268566.xls forum-mso-en4-280967.xls forum-mso-en4-52733.xls forum-mso-en4-56244.xls forum-mso-en4-67264.xls forum-es-7576.xlsx Not sure if the cause is the same, most have macros and form controls, where some content used to get lost in the past, and it's still lost, but at least in the past the roundtripped files could be opened in Excel. All in the list regressed from the following commit, bibisected using bibisect-win64-7.0: https://cgit.freedesktop.org/libreoffice/core/commit/?id=fd238380ae7820f12ac1f7c52d0f7180a93f3ba3 author Serge Krot <Serge.Krot@cib.de> 2020-05-13 22:52:52 +0200 committer Thorsten Behrens <Thorsten.Behrens@CIB.de> 2020-05-26 00:20:54 +0200 tdf#106181 XLSX export: output form controls
Created attachment 197536 [details] forum-mso-de-63075.xls
Created attachment 197537 [details] forum-mso-en4-67264.xls
The three sample files open without error message Microsoft® Excel® para Microsoft 365 MSO (versión 2410 compilación 16.0.18129.20100) de 64 bits
(In reply to m_a_riosv from comment #3) > The three sample files open without error message > Microsoft® Excel® para Microsoft 365 MSO (versión 2410 compilación > 16.0.18129.20100) de 64 bits Thanks for checking, but please note the reproduction steps: "The attached files can all be opened in Excel in their current state. Open them in LO, save them as XLSX, and try opening them in Excel."
Pls forgive the mistake. Only forum-en-7576.xlsx shows an error message when opened with Excel after save as XLSX, but after agreeing to correct it, it seems to open fine. Version: 25.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 7713d916e06a8388f849a758f928cbcfded6c0ae CPU threads: 16; OS: Windows 11 X86_64 (10.0 build 26100); UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded
The export to the sortState element in sheet1.xml is erroneous in forum-es-7576.xlsx. (In reply to Aron Budea from comment #0) > All in the list regressed from the following commit, bibisected using > bibisect-win64-7.0: > > https://cgit.freedesktop.org/libreoffice/core/commit/ > ?id=fd238380ae7820f12ac1f7c52d0f7180a93f3ba3 > author Serge Krot <Serge.Krot@cib.de> 2020-05-13 22:52:52 +0200 > committer Thorsten Behrens <Thorsten.Behrens@CIB.de> 2020-05-26 00:20:54 > +0200 > > tdf#106181 XLSX export: output form controls Are you sure about the commit? From the effected element I would expect, that something is wrong in https://cgit.freedesktop.org/libreoffice/core/commit/?id=a9f8f0a484965338221cad4f97d98f418b5ccff1 But I do not know how to make a bibisect.