Yeah it does. I'll be honest, I don't use spreadsheets much so I don't have personal experience with it, but yeah it does support that.

I was curious, so I followed up on this. Here's what a quick Google search turned up:

To open an XLSM file in LibreOffice Calc, you can generally open it directly. However, you might need to save it in a different format (like ODS) to ensure compatibility, especially if you're dealing with macros. LibreOffice Basic is not directly compatible with Excel VBA macros, so you may need to rewrite the macros to use LibreOffice Basic.

In other words, you may need to save your Excel documents as open document files, but after that their macros should work just as they did. Either way, macros are supported and in fact there are a few different scripting languages you can use.