Dear Sir:
I begin to use the Beta version of open office Cal.
I have used a function as follows:
={SUM(NOT(ISERROR(SEARCH(A27;A16:A26)))*D18:D26)}
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 file test openoffice.ods sheet 1 Cell E17:E19 .So I transfer another file Process Data base-Test.ods in EXCEL to Open Office beta version. But unfortunately the same function can not be worked. Please check the sheet ref table the cell A2 and F14.
What is happen in this file. Is there some problem still not solved in the Beta version?
Thanks for your help.
The second file will send in next email. Because your capacity is not enough.
Best regards, Mozart LIU
test openoffice.ods
Description: application/vnd.oasis.opendocument.spreadsheet
No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.11.8 - Release Date: 2005-5-10
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
