[NTLUG:Discuss] OpenOffice Spreadsheet Macro Guide?

[John K. Taber]

Any guides on writing macros for OpenOffice spreadsheet.

I need to repetitively extract URL paths from a spreadsheet column,
change the URLs with the spreadsheet's find and replace function.

Then, I need to put the updated URLs back into the column they came
from.

I use two simple dumb macros that I wrote in MS Office for this, but 
I'm not sure how to do this in OpenOffice.

Any pointers will be appreciated.