Re: [libreoffice-users] regular expression for calc

If the code you are looking for only occurs once per cell you could use
find() or search() against each cells to determine if the code is present
then countif() the results where greater than zero.

On Sun, Mar 12, 2017 at 1:50 PM, Regina Henschel <rb.henschel@t-online.de>
wrote:

> Hi Gary,
>
> find the option "Search criteria = and <> must apply to whole cells" in
> Tools > Options > Calc > Calculate. Try it with disabled option.
>
> Kind regards
> Regina
>
> Gary Collins schrieb:
>
> > Hi Brian
> > I wish i could say it did help but unfortunately not. It works with the
> > whole cell contents but doesnt seem to pick out a word within the cell. For
> > instance, one of my list has contents "X1 G43". Now if I have "X1 G43" in
> > the cell Xn (using your example) i get count 1 returned which is correct;
> > but if i have "X1" in cell Xn it returns 0, which is clearly wrong (at
> > least as far as my requirements are concerned). And yes, i do have regular
> > expressions enabled in Calc >  Calculate. My version is 5.2.2.2 x64 and im
> > using 64bit windows 7.
> >
> > G.
>
>
> --
> To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-uns
> ubscribe/
> 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

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
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