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


Help: OASIS Mailing Lists Help | MarkMail Help

office-comment message

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

Subject: Re: [office-comment] [formula] Equality operator

Hi Brad,

On Friday, 2007-03-30 17:41:43 +1000, Brad Hards wrote:

> > > The equality operator has a couple of unexpected (to me) test cases:
> > > =ISNA(NA()=NA()) is required to be true.
> > > I don't agree with the logic "If there's an error on either side, the
> > > result is an error -- even if you're comparing the "same" error on both
> > > sides.". That isn't intuitive, and makes for messy logic.
> >
> > Indeed, the description is correct, but the result value is not, it
> > should be Error instead. The NA() function generates an error and the
> > error is propagated through the expression, which is the usual behavior.
> That means that ISNA() can never return true - it can only ever be false (the 
> argument was not an NA() error) or an Error (if the argument is an error). 
> I'm not sure that makes sense. This is an intentional error check function.

Ah, so yes, I was mislead, =ISNA(NA()=NA()) must be TRUE because
=NA()=NA() is Error, that's what the comment refers to. So what in that
test case's comment do you actually disagree with?


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