To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=72508
User er changed the following:
What |Old value |New value
================================================================================
CC|'' |'villeroy'
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Wed Apr 11 14:01:53 +0000
2007 -------
Villeroy,
The formula you can use as a workaround is
{=SUM(NOT(ISERROR(FIND("A";Data))))-SUM(ISBLANK(Data))}
And
> btw: AND/OR don't work at all in array context.
well, they just work as in Excel and never return an array, not even if two
arrays were passed as arguments, which isn't always what one might expect..
you'll have to use the {=SUM(...)} workarounds.
Eike
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
