Aah, now I see, I did the same mistake I always do on this list, I emailed the OP personally. I do that a lot since this list changed its behaviour, sorry. I never learn, as it seems… Just in case anyone is curious, here is what I wrote this morning (local time), even though it doesn't mean much any more, since a better answer already arrived on this list:
---------- Forwarded message ---------- From: Johnny Rosenberg <[email protected]> Date: 2013/2/8 Subject: Re: [libreoffice-users] IF w/ Regular Expression To: Joel Madero <[email protected]> 2013/2/7 Joel Madero <[email protected]>: > Hi All, > > I have enabled regular expressions in LibreOffice settings but still am > unable to get this one to work. Here is my line: > > IF(N200="*regression*",1,0) > > Not sure what I'm missing. Thanks! As far as I know, IF doesn't support regular expressions. In your case, this will probably work: IF(ISNA(FIND("regression";N200));0;1) I know, very clumsy and probably slow too. Johnny Rosenberg > > -- > *Joel Madero* > LibreOffice QA Volunteer > [email protected] > > -- > For unsubscribe instructions e-mail to: [email protected] > Problems? > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > 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 > -- For unsubscribe instructions e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ 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
