https://bugs.documentfoundation.org/show_bug.cgi?id=152238
Bug ID: 152238 Summary: FILESAVE: The structure of the book is broken when saving to LO in the .xlsm format in the case when the book (sheet) module has macros. Product: LibreOffice Version: 7.4.2.3 release Hardware: All OS: All Status: UNCONFIRMED Severity: normal Priority: medium Component: Calc Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: so...@comec92.ru Created attachment 183814 --> https://bugs.documentfoundation.org/attachment.cgi?id=183814&action=edit Book_LO_Codename.xlsm Attached to the message is a book Book.xlsm created in Excel 2016. The CodeName of book is "MyWorkbook". Book has the sheet "Data" with CodeName "Sheet". The workbook module contains an empty Workbook_Open() macro. Open Book.xlsm in LibreOffice and save as Book_LO.xlsm (see attachment). Open the workbook Book_LO.xlsm in Excel. The VBE editor shows that the structure of the book is broken: there are three book modules. In my opinion, the reason is that LO does not write the "Codename" attribute for the book tag "workbookPr" (\xl\workbook.xml) and sheet tag "sheetPr" (\xl\worksheets\sheet1.xml). The book Book_LO_Codename.xlsm (see attachment) was created by manually adding the specified attributes to the Book_LO.xlsm archive. There are no problems opening this workbook in Excel. -- You are receiving this mail because: You are the assignee for the bug.