I’m not sure if this is a limitation of .xls format or a bug/missing feature. I know that macros are considered experimental at this point, but here’s my problem.
If you create a macro in Libre Calc and save the file as an .xls (97/2000/XP/2003) format, the macro will not save to the file. This has been tested on 3.4.5 and 3.5.0rc3
I open or create a new .xls file. I record a macro and save it to the document. I am able to run the macro while still in the document. As soon as I close the document and open it again, the macro is no longer listed.
If I save the spreadsheet as .ods the macro saves properly.
I’m also able to create a simple macro in Excel 2010 and save the file as .xls. When I open with Libre Calc the macro is listed and I can run it without issue.
Again, is this a limitation of .xls or is Libre not saving the macro because of a bug?