Hello Sylvic,
Please, turn on "Enable regular expressions in formulas" in Tools ->
Options -> OpenOffice.org Calc -> Calculate.
quoted from OpenOffice.org Help:
The search supports regular expressions. You can enter "all.*", for
example to find the first location of "all" followed by any characters.
If you want to search for a text that is also a regular expression, you
must precede every character with a \ character. You can switch the
automatic evaluation of regular expression on and off in Tools - Options
- OpenOffice.org Calc - Calculate.
Best wishes,
Alex Janssen
Sylvic wrote:
Dear Sir:
I begin to use the Beta version of open office Cal.
I have used a function as follows:
={SUM(NOT(ISERROR(SEARCH(B12;A1:A9)))*B1:B9)}
It can run in EXCEL but not in Open Office 1.1. Now I am so glad when
I open it in the beta version it works as in the first file "test open
office" Cell B13:B14.So I transfer another file in EXCEL to Open
Office beta versionas the file 2--Process Database Test. But
unfortunately the same function can not be worked. Please check these
files.
What is happen in them? Is there some problem still not solved in the
Beta version?
Thanks for your help.
Because of your capacity I only can send in two emails.
Best regards, Mozart LIU
------------------------------------------------------------------------
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.11.10 - Release Date: 5/13/2005
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
