Re: [office-formula] query / comment on XOR() - let's change XOR

[Eike Rathke <erack@sun.com>]

Hi David,

On Tuesday, 2007-02-13 13:31:07 -0500, David A. Wheeler wrote:

> I agree with Brad Hards and Eike, we should change the definition of XOR.  And my thanks to Brad Hards for telling us this!!
> 
> Eike, will you do that please?   You may as well change {Logical L}* to {Logical L}+,
> and fix the extraneous yellow line.

Will do.

> I've looked around, and all sources agree with Brad.

I compared with Kspread 1.4.2, also there =XOR(1;1;1) yields TRUE.

I assume some confusion arose from discussions like in
http://en.wikipedia.org/wiki/Talk:Exclusive_or#More_than_2_operands
http://en.wikipedia.org/wiki/XOR_gate#More_than_two_inputs

Now I just wonder why something was defined that none of the
applications implement..

  Eike

-- 
Automatic string conversions considered dangerous. They are the GOTO statements
of spreadsheets.  --Robert Weir on the OpenDocument formula subcommittee's list.