[NTLUG:Discuss] OpenOffice Spreadsheet Macro Guide?

[Robert Pearson]

On 4/23/06, John K. Taber <jktaber at charter.net> 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.

I was intrigued by your question so I Googled for "open office macros".
Keep in mind that most people use "OpenOffice" but some use "Open Office".
The most interesting results were---

<<http://www.ooomacros.org/>>

<<http://spreadsheets.about.com/od/openofficecalc/>>

which has many sub-topics. Two sub-topics of interest are---

<<http://spreadsheets.about.com/gi/dynamic/offsite.htm?zi=1/XJ&sdn=spreadsheets&zu=http%3A%2F%2Fdocumentation.openoffice.org%2FHOW_TO%2Fspreadsheet%2Fcalc1_EN.html>>

<<http://spreadsheets.about.com/gi/dynamic/offsite.htm?zi=1/XJ&sdn=spreadsheets&zu=http%3A%2F%2Fwww.ooomacros.org%2Ffiles.php%3Ftype%3Ddoc%23MacroLibraryHow-To>>

If you Google for "openoffice macros" you will not get the
"spreadsheets.about.com" hit because they use "Open Office".

HTH,  Robert...