This is a followup of bug 163842 where XLSX>XLSX was fixed so for XLS>XLSX. Sample files can 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: Repaired Records: Drawing from /xl/drawings/drawing1.xml part (Drawing shape) Repaired Records: Drawing from /xl/drawings/drawing2.xml part (Drawing shape) Samples are attachment 197536 [details] and attachment 197537 [details]. Regressed from the following commit in 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
Confirm in Version: 25.2.0.0.alpha1+ (X86_64) / LibreOffice Community Build ID: 94afced0195ef824e575176e33c79ca57484cd5c CPU threads: 8; OS: Windows 10 X86_64 (10.0 build 19045); UI render: Skia/Vulkan; VCL: win Locale: ru-RU (ru_RU); UI: en-US Calc: threaded
(In reply to Timur from comment #0) > This is a followup of bug 163842 where XLSX>XLSX was fixed so for XLS>XLSX. To clarify, that turned out to be a different issue in the end. > Regressed from the following commit in 7.0: The fundamental issue / missing feature seems to be LO not supporting the export of form controls. Previously they got lost on save, and after the change the file gets corrupted. Even if this is still unsupported, would be good to at least return to the state where files didn't get corrupted.
This is related or the same as bug 136397 but so far See Also is enough. I prefer to have file shown as corrupted than to silently lose data.
(In reply to Timur from comment #3) > This is related or the same as bug 136397 but so far See Also is enough. > I prefer to have file shown as corrupted than to silently lose data. Just idea for future: even better would be to warn user before/during saving. So it will not be a suprise when opening the file again. I don't know if we have similar workflow already in LO.
Gülşah Köse committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/e7f05ee2e3c03350e13da607a3e48a822f8baf7e tdf#164141 Fix command button xls to xlsx convert problem. It will be available in 25.8.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.
This was about "command button " and I close as Fixed. Color is bug 164924. Macro not working is out of the scope. Related tickets are in See also. Full sample is in bug 119046 , general case is bug 136397. Regression is bug 165300.