----- Original Message ----
From: Harold Fuchs <[EMAIL PROTECTED]>
To: [email protected]; [EMAIL PROTECTED]
Sent: Sunday, December 9, 2007 11:04:10 AM
Subject: Re: [users] openoffice documentation or bug?
On 09/12/2007 06:45, Henry Ballard wrote:
> I am using openoffice 2.3 - just downloaded it and installed it this
week.
>
> In calc, I was trying to search for something more than a simple
string - looking at the documentation of the regular expressions
"supported", I found that searching for "M" was fine but "[M]" is not found -
it
says #value (???). Then I tried =SEARCH("M|I";"Misty")
> and that doesn't work either. Then I tried
> =SEARCH("[:alnum:]";"Misty")
> with no different luck. So far, I'm wondering if any regular
expressions work. Or maybe there's some trick. Or the documentation is
misleading.
>
> Any insights?
>
> Thanks,
> Henry
>
>
>
Have you actually turned on the Regular Expression option? In the
Search
& Replace pane click More Options and then select Regular Expressions.
If that still fails, come back here with more information about exactly
what you are doing.
--
Harold Fuchs
London, England
Please reply *only* to [email protected]
Thanks for the hint - not that the Search and Replace (Find and Replace) pane
seemed relevant, logical, or effective, but if regular expressions are to be
turned off and on in the Find and Replace Pane, then perhaps they are turned
off and on in formulas as well, so I found Tools->Options->OpenOffice.org
Calc->Calculate, where there is an option called "Enable regular expressions in
formulas", which, when checked, has the desired effect. And there it is in the
description of the search function, just under the link to the list of regular
expressions, which sucked me in so I got all involved in the details rather
than paying attention to the part that told how to enable it. I would prefer
the default to be to have regular expressions enabled, but that's what I get
for using sed and vi for twenty years.
Thanks again,
Henry
____________________________________________________________________________________
Never miss a thing. Make Yahoo your home page.
http://www.yahoo.com/r/hs
