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: [email protected]
Reporter: [email protected]
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.
