Hi Leonard, On Wednesday, 2008-10-01 20:53:46 +0200, Leonard Mada wrote:
> There is NO mention in the Help that comes with OOo-m29 that FIND() does > not search for regular expressions, and I was fairly convinced that it > actually works. For SEARCH() it mentions "The search supports regular expressions.", as it (hopefully) does for all other functions that support regex; for FIND() it does not as that does not. Might be improved to explicitly mention non-regex-awareness in this case and cross-reference the SEARCH() function; please file an issue with the Documentation project. > The only trouble I have with the new formula is that the already ugly > formula got another 4 chars wider (making at 20 formulas another 80 > chars). I desperately hope that the #VALUE! error gets fixed. ;-) Don't despair.. this will probably not be changed. For interop with other applications also ODFF defines to return an error if the string was not found. In Calc it is planned to support the IFERROR() function though that will ease handling of such cases and also improve runtime performance of expressions such as IF(ISERROR(something);errorcase;something) 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.
pgpYKBZSdYaTc.pgp
Description: PGP signature
