I have MS Excel spreadsheets that fequently use COUNTIF (range,"A~*") to
count the how often the entry "A*" occurs.
The ~ is required as an escape character since, in Excel * otherwise
maps to any characters. (This must be a common requirement in UK
education since in UK exams A* is used as a grade.)
When imported into OpenOffice calc no conversion is made so the count
fails to find the A* values. (It is now looking for "A~*" values since
the ~ as escape is no longer required).
Clearly I could do a search/replace to change the formulae manually but
would rather not since, if resaved as .xls the =COUNTIF(H8:AG8;"A*")
now reports grade A as A* in error. (so no conversion is made in the
reverse direction either).
Is this the sort of thing I should report as a bug/request for
enhancement? If so, how should I go about it?
Philip Goodfellow
OS : Windows XP Pro SP2
Open Office 2.0.3
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
