Re: cell referencing in function

[Jody Goldberg <jgoldberg home com>]

On Sat, Apr 21, 2001 at 03:08:34PM +0200, tiago pascoal netc pt wrote:
> or even better value("a",1), that would be quite nice. (is there such a
> function?)

INDIRECT

Be careful this is not fully implemented in Gnumeric.  It will not
recalculate automaticly in all cases.

    eg
        =indirect(A1)
    where A1 = "A2"
        it will recalculate if you change the content of A1
        will not recalculate if you change the content of A2

MS excel works around this by declaring that INDIRECT is a
'volatile' function.  This means that it is recalculated every time
anything is recalculated.  We're looking for something less drastic,
However, this problem is a fairly low priority.

Hope this helps
    Jody