Created attachment 169051 [details] disable-vba-refactoring.oxt: a simple extension prevent VBA being changed by LO. Sets VBA - UseExport to false. If you round-trip attachment 109955 [details] in 6.4, Excel will complain about the VBA code on load. This was working until LO 6.4 change by author Serge Krot on 2020-06-09 10:34:32 commit 577dd32b1c4eb0a4cff574fbabca987cb52b831b tdf#106181 XLSX export: output form controls Prepared general algorithm to ouput form controls into XLSX. For now only CHECKBOX is supported with a possibility to link withem to any worksheet/cell. To replicate: 1.) Go to Expert configuration under advanced settings and change Calc - Filter - Import - VBA - UseExport to false. (This prevents LO from making any changes to the VBA code - which is essential to it still working in Excel.) 2.) Open attachment 109955 [details] (ignore the macros) and save. A dialog box will inform you that no changes were made to the VBA code. 3.) Open the round-tripped file in Microsoft Excel. In 6.3 it only warned once about dangerous code. In 6.4 it warns twice - the second one about unreadable content. I personally tested with Excel 2010. I also round-tripped using LO 7.2 and the problem still exists in master.
The problem seems to have come with this line: -ImplWriteShape( aObj, rSolverContainer ); +ImplWriteShape( aObj, rSolverContainer, /*bOOxmlExport=*/true ); and // This code is expected to be called only for DOCX format. - if (xPropInfo.is() && bOOxmlExport) + if (xPropInfo.is())
I'm disappointed that this bug wasn't even acknowledged. Proposed fix at http://gerrit.libreoffice.org/c/core/+/113399
Justin Luth committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/a3c5c0f7ce73001adab7475fde1f8ffec4eef48b tdf#139786 partial revert tdf#106181 XLSX export: output form controls It will be available in 7.2.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Justin Luth committed a patch related to this issue. It has been pushed to "libreoffice-7-1": https://git.libreoffice.org/core/commit/4d63b046679539c1e0f5a6f44e87c9420d679f5b tdf#139786 partial revert tdf#106181 XLSX export: output form controls It will be available in 7.1.3. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Justin Luth committed a patch related to this issue. It has been pushed to "libreoffice-7-0": https://git.libreoffice.org/core/commit/babd187dfaa5181ddaec6612fb8efe12ac8ed350 tdf#139786 partial revert tdf#106181 XLSX export: output form controls It will be available in 7.0.6. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.