[NTLUG:Discuss] [Bulk] OpenOffice Spreadsheet Macro Guide?

[Leroy Tennison]

John K. Taber wrote:
> 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.
>
> _______________________________________________
> http://ntlug.pmichaud.com/mailman/listinfo/discuss
>
>   
Newer versions of OpenOffice have a "Record Macro" function, might start 
there even if you need to customize it further.  OpenOffice macros are 
very OOP oriented, they're probably the best example I know of 
concerning losing sight of the end result for the sake of technological 
ideology.  It seems that everything must be object oriented.  What has 
been forgotten is that macros were intended to be "quick and dirty" and 
provide "ordinary people" with some means of automation without having 
to be a full-blown programmer.  All of that has been lost to OOP.