Re: gnubie questions

[Andrew Pimlott <gnumeric andrew pimlott net>]

[ 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