Re: Help with Gnumeric

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

On Sat, 2008-10-04 at 18:47 +0200, Jean Bréfort wrote:
> Le vendredi 03 octobre 2008 à 12:43 +0000, Robert Paul Bywater a écrit :
> >  
> > I am a novice at Gnumeric so I need help.
> >  
> > I have an array in a Gnumeric sheet, let's call it B1:K50.
> >  
> > I want to do numeric operations on *all* the elements in this array.
> >  
> > Firstly, I highlight the array. (But one cell seems to still be more
> > 'active' than the others,
> > it is white while the others are blue. It is usually B1. Why is that?
> > I want my formula applied 
> > to *all* the cells. How do I ensure this?).
>
> The destination cells should not be the same as the cells containing
> your original data, or you'll end with cyclic dependencies which might
> not give anything significant.
>
> >  
> > One kind of operation I want to do is like this:
> > =product((a-B1:K50)*(b-B1:K50))
> > where a,b are constants and are integers as are the elements in
> > B1:K50.
>
> I don't undestand your formula. Anyway, the product function does not
> accept that kind or argument.

Well, it does. On the otehr hand it calculates the product of a large
number of terms each being the product of 2 differences. I doubt you
really mean that.

Andreas


-- 
"Liberty consists less in acting according to
one's own pleasure, than in not being subject 
to the will and pleasure of other people. It 
consists also in our not subjecting the wills 
of other people to our own."  Rousseau

Andreas J. Guelzow
Pyrenean Shepherds