Re: Range operators

["Andreas J. Guelzow" <aguelzow pyrshep ca>]

On Sat, 2009-03-21 at 17:19 -0600, Rita & Klaus Kuhnlein wrote:
> Sorry,
>
> the Gnumeric Help says that SUM-Function is Excel compatible. And  
> Excel declares the Komma as an operator and not as a delimeter of two  
> arguments. A Komma is a set union operator and a Blank is a  
> intersection operator. It is not an excuse for Gnumeric when Excel  
> makes an error. Gnumeric is better than Excel (hopefully)!

But the comma is also an argument separator. With the parentheses you
are using you have passed two arguments to the SUM function rather than
applied the comma operator. If you want to use the comma operator you
need to put in the correct parentheses:

SUM(A1:A2,A2:A3)   here the comma is an argument separator
SUM((A1:A2,A2:A3)) here the comma is a union operator

In Excel you will find a difference between those two expressions. In
Gnumeric the comma operator has some known bugs. Of course this has
nothing to do with whether the SUM function is Excel compatible or not.
It is the comma operator (when used) that is the problem. In your
formula you didn't use it though.

Andreas  
-- 
Andreas J. Guelzow <aguelzow pyrshep ca>