Hi Kohei, On Tuesday, 2006-10-31 13:04:25 -0500, Kohei Yoshida wrote:
> >> >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. ;-) Yes, seems like.. > 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. That's the point. You won't be able to save the document to "that other" spreadsheet application's file format and load it there and have it work the same. As the original submitter of that issue stated "This is the normal behaviour and is fully logical." I'd add "yes, that's fully logical, but not the normal behavior in spreadsheet applications." ;-) Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to this [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Thanks. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
