I have XLSX files created with OnlyOffice/Nextcloud containing OnlyOffice macros. After opening and saving the XLSX with LibreOffice calc, the macros are gone - when the file is opened with OnlyOffice. MS Excel does not delete OnlyOffice macros.
Please attach the file. And try to save as Xlsm, format for saving macros. And test all from LO in MSO.
Created attachment 174649 [details] Testfile with onlyoffice macro
(In reply to Timur from comment #1) > Please attach the file. And try to save as Xlsm, format for saving macros. > And test all from LO in MSO. Example-file with an OnlyOffice Macro has been attached. OnlyOffice uses Open XML format to my understanding. The Macros seems to be in the jsaProject.bin file. *.xlsm is not supported by OnlyOffice.
[Automated Action] NeedInfo-To-Unconfirmed
In general, XLSM is for VBA and this seems like JavaScript macro. Findings: - OnlyOffice doesn't support proper format XLSM so it saves macro in XLSX; - MSO doesn't see and run that macro, but it leaves it unchanged on save to XLSX; - LO doesn't edit or run that macro, and it doesn't save it. I think this (fileopen issue) is NotOurBug, OnlyOffice should save it properly. I don't think it's worth a bug to make a workaround of keeping that unknown content. This report prompted me to test saving to XLS* of javascript macro and it doesn't work. But I'll open a new bug from example in bug 118440.
Thanks. Is LO generally removing all "unknown" items from its files? I think the MSO behavior would make users more happy. Any chance to reconsider this NotOurBug-decision? If I report the problem at OnlyOffice, they might say the MSO is doing it right and that LO should get it right...
MSO is not doing right, it doesn't see that macro, and that was the main drive to put NOB. So I guess that bug should be reported to OnlyOffice to fix that and after that please set this one Unconfirmed with new file.