RE: gnubie questions

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


-----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.

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

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,
gnumeric-list mailing list
gnumeric-list gnome org

[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]