On 10/31/06, Eike Rathke <[EMAIL PROTECTED]> wrote:

> Kohei wrote: (regarding the FIND() function)
> >I would rather it returns -1 instead of 0 if the string is not found.

I don't know where Kohei wrote that or in what context, but the FIND()
spreadsheet function does return neither 0 nor -1, it returns an error
condition.

I wrote this in the issue:
http://qa.openoffice.org/issues/show_bug.cgi?id=66590

and, IMO, my comment was taken slightly out of context. ;-)

What I meant to say is that, *if* we were to go ahead and change this
function to return a numeric value to indicate an error condition, I'd
rather see it returning -1, instead of 0.

But this alone is not at all an endorsement on my part.  I still
question whether or not we should change the behavior of the built-in
function in question, without careful consideration to
interoperability and backward compatibility of documents.

Kohei

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to