- Open a new sheet - Create and save a basic macro - File -> save as - Select a name and save in Excel 97/2000/XP/2003 ... close calc Reopen file just saved and you can see that there are no macro. There are no problems saving on ODS format.
Found in LibO 3.4.4 and 3.4.5
Still on 3.5.1.2
XLS can't store basic macros. There is no way to implement your feature request. There is a feature request for storing VBA macros in XLS(X) but this is a totally different story and then only a feature request and not a bug.