I am using version 2.3 of OpenOffice.org. My problem is : the use of
wildcards.
In Excel, a count can include a wildcard (such as "*data*") on either side
of the data to be searched for. When that is opened in OpenOffice.org, the
* can only be used after the data ("data*") in order for the count to
recognize the data searched for. In OpenOffice.org "*data*" returns a count
of '0'. Is there a fix for this? Thank you.
=COUNTIF(A5:A10;"*DATANAME*")
----------
CONFIDENTIALITY NOTICE: This E-mail is covered by the Electronic
Communications Privacy Act, 18 U.S.C. '' 2510-2521 and is legally privileged.
This information is confidential information and is intended only for the use
of the individual or entity named above. If the reader of this message is not
the intended recipient, you are hereby notified that any dissemination,
distribution or copying of this communication is strictly prohibited.
