Hi Leonard, On Wednesday, 2008-11-26 23:37:00 +0200, Leonard Mada wrote:
> I just noticed the following formula in one of the issues:
>
> "=IF(AND((ISERROR(SEARCH("Pass",$F8))),
> (ISERROR(SEARCH("Warn",$F8))),
> (ISERROR(SEARCH("Closed",$F8)))),0,1)"
IIRC we already mentioned the to be implemented IFERROR() function in
this context somewhere.
> And this only because SEARCH() returns an ERROR if the string is not found.
> [http://www.openoffice.org/issues/show_bug.cgi?id=91146]
That issue has a different topic.
> How many examples should I provide to get the developers implement an
> alternative Search function that returns 0 IF the string is not found.
I don't think it is a matter of the amount of examples. Usually no issue
is. Actually the process would be:
1. Propose the new function to the OASIS formula subcommittee, using the
comments form at OASIS. You know where it is.
2. Wait until the proposal is discussed and accepted.
3. Find someone who will implement it.
But, once IFERROR() was implemented, a different SEARCH() would only be
necessary to distinguish between not found and propagated error. So for
the overall enhancement it may be better to skip steps #1 and #2 and
start with #3 to implement IFERROR(), as that may be useful in all
context where an expression may return an error.
> The explanation that this is different than Excel is strange considering
> issue 5658, which is definitely a more severe inconsistency than this
> one [http://www.openoffice.org/issues/show_bug.cgi?id=5658].
Nice to throw in an unrelated but one of the most controversially
discussed issues with the most useless comments we have :-/ This really
does not help.
Eike
--
OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer.
SunSign 0x87F8D412 : 2F58 5236 DB02 F335 8304 7D6C 65C9 F9B5 87F8 D412
OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS
Please don't send personal mail to the [EMAIL PROTECTED] account, which I use
for
mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED]
Thanks.
pgpgxsVQM18dr.pgp
Description: PGP signature
