RE: gnubie questions

[Phillip Shelton <shelton usq edu au>]

Excel has a function called Address that does what you want.  At the moment
I can not tell you if Gnumeric has it as I do not have a copy of gnumeirc to
test with.

And yes you could get a stale value.

And no, that sort of linking has not been thought of.  It would be difficult
to do as it would have to be a non-spreadsheet function.
No spreadsheet function could do that becuase if you entered the 6 in the
second cell, you would overwrite the fuction in that cell.  The best bet is
to have a extra cell that has the common value in it (This is the only cell
that is ever changed) and have both the "linked" cells referenc that extra
cell.

Phill

-----Original Message-----
From: Andrew Pimlott [mailto:gnumeric andrew pimlott net]
Sent: Tuesday, 9 July 2002 12:19 PM
To: gnumeric-list gnome org
Subject: Re: gnubie questions


[ I am the original poster.  I was screwing around with my mail
config and sent the original message with a bogus From: address, and
didn't keep a copy for myself.  Nice of the message to finally show
up.  :-) ]

On Mon, Jul 08, 2002 at 10:14:25PM -0400, Jody Goldberg wrote:
> On Thu, Mar 28, 2002 at 10:43:13PM -0500, ota pimlott net wrote:
> >   - Is there a function to get the value of the cell at a given row
> >     and column?  Ie, F such that =F(1, 1) is equivalent to =A1.
> >     Seems like a no-brainer, but I couldn't find it in my scan
> >     through the docs.
> There are 2 approaches.
>     =INDEX
>     =OFFSET

Ugh.  I take from looking at the documentation that neither of these
is a general solution, because they only work within a fixed range.
Ie, if my row and column parameters can be arbitrarily large, I'm
stuck.

> Beware neither is fully supported yet, things do not get
> recalculated all the time.

Meaning I could get a stale value?

> >   - Is there any feature that would allow me to identify two or more
> >     cells with each other, requiring that they always have the same
> >     value?  I would want to be able to change any one of them, and
> >     have the others all change automatically.
> I don't understand.

Say I link A1 and B2.  Then if I enter 5 in A1, both A1 and B2 get
value 5.  If I then enter 6 in B2, both A1 and B2 get value 6.

Thanks for your reply,
Andrew
_______________________________________________
gnumeric-list mailing list
gnumeric-list gnome org
http://mail.gnome.org/mailman/listinfo/gnumeric-list