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 Sunday, 2007-03-25 20:42:20 +1100, Brad Hards wrote:

> openformula-20070322-wheeler, section 6.3.6
> 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.

> =“Hi”=”HI” is required to be true.
> There is a note about case sensitivity, and some explanation of OOo vs other 
> implementations. It seems silly to allow it to be true or false, and to still 
> have a test case.

Actually, when seen in the OpenDocument context, case-sensitivity
depends on the table:case-sensitive attribute, not just on some
application setting. I'll modify the description to clarify on that.


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

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