OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.

office-comment message

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]

Subject: Re: [office-comment] Re: Very Weak String Support in ODF

• From: Eike Rathke <erack@sun.com>
• To: office-comment@lists.oasis-open.org
• Date: Wed, 13 Jun 2007 19:51:25 +0200

```Hi Leonard,

On Saturday, 2007-06-09 12:12:28 +0300, Leonard Mada wrote:

> One thing in common that every study on human errors has brought to
> light is that errors increase as formulas get more complex. The
> workaround for the FIND/SEARCH()-problem makes the formula definitely
> more complex, what do you think?
>  1.)     = OR( FIND("a"; ...) ; FIND("b"; ...) )
>  2.)     = OR( IF( ISERR( FIND("a"; A1) );  0 ; FIND("a"; A1) ) ; IF(
> ISERR( FIND("b"; A1)) ;  0 ; FIND("b"; A1) ) )
>
> Please feel free to correct the above formula IF you find the error. I
> was NOT able to make OOo Calc compute it. After more that 15  minutes I
> gave up.

Actually I didn't experience any problem with #2, it works exactly like
you wrote it, giving TRUE if A1 contains "a" or "b", else FALSE.
However, of course compared to #1 it is overly complex. That is where
IFNA comes in, what we currently discuss on the subcommittee's list.

= OR( IFNA( FIND("a"; A1); 0) ; IFNA( FIND("b"; A1); 0) )

Eike

--
OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS
```

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]