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
____________________________________________________________________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now.
http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
