Date: prev next · Thread: first prev next last
2017 Archives by date, by thread · List index


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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.