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

Ryan Jendoubi wrote:
> This is set up pretty much how I'd like it to work (without the looong list
> of input on the first sheet).
>
> I wasted half my day Googling this and trying various things, and the IRC
> channel has declared it impossible without a macro.
>
> If you've thought of a winning formula I'll be hugely grateful!

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?

Regards
Stephan

-- 
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