Re: [libreoffice-users] Match cell against any of range of regexes?

Hi Stephan,

On 01/07/11 10:00, Stephan Zietsman wrote:
> I've had a look at the spreadsheet, and tried a few formulas.  It
> seems that to do this with formulas is quite tricky and unfortunately
> I couldn't get it done.  I tried a few different approaches and I
> think it is technically possible.  However, I also think that it would
> take quite some time to write such a formula (if it is indeed
> possible).
>
> As was mentioned before, it can be done with macros.  Would you
> consider using a macro instead?

Continued thanks for all your efforts. If I could whip up a macro like 
buttered toast I'd do so, but unfortunately for me that would first 
involve giving myself a grounding in writing bespoke LO macros. I can 
however write a bit of Perl, and I've started trying to tackle the 
problem that way :-) Although I think I'll have to finish the current 
batch by hand for now, because unlike writing code at least that has a 
definite end point...

LO macros would definitely be a good skill to learn eventually, even if 
it's not at the top of my todo list at the moment. I haven't yet 
searched for any tutorials or the like, but I'd be interested to hear if 
you have any personal favourites which you think would suit someone who 
knows general programming and just needs an intro to the syntax, 
conventions and frameworks / objects involved in LO scripting.

That said, I've noticed there are at least four different languages one 
can use. I don't know if any of them would allow writing scripts which 
are broadly cross-compatible with other office suites (even if a little 
tweaking is needed) but my preference would be for that, so I could help 
non-LO-using friends and such.

Thanks again and best regards,

--Ryan

--
Unsubscribe instructions: E-mail to users+help@global.libreoffice.org
In case of problems unsubscribing, write to postmaster@documentfoundation.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted