Re: [libreoffice-users] regular expression for calc

Hi Regina,
Thank you, yes, that's cracked it. (*so* many pitfalls for the unwary!)

Best
Gary
--------------------------------------------
On Sun, 12/3/17, Regina Henschel <rb.henschel@t-online.de> wrote:

 Subject: Re: [libreoffice-users] regular expression for calc
 To: users@global.libreoffice.org
 Date: Sunday, 12 March, 2017, 17:50
 
 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-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
 

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