OpenOffice has macros and functions, too. You'd have to rewrite any existing ones, as while it also uses a form of BASIC, the APIs are soemwhat different, but that's a one-time porting cost.
There's also a repository of OpenOffice macros.
Thanks for that feedback... when I checked OO some years back it was severely lacking in that area.
I'll check it out again one of these days.