open office cell self-reference?

[John D Lamb]

On Sun, 2011-10-09 at 13:11 +1100, Karl Auer wrote:
> I want to put a formula in a cell that refers to the cell above the one
> with the formula in it. For example, I want F2 to contain a formula that
> displays the value in F1.
> 
> Easy enough of course: =F1
> 
> But here's the kicker: If someone adds a new row after F1, which will
> make F2 into F3, I want the formula to now refer to F2.
> 
> That is, the reference in F2 needs to be relative to F2. It needs to
> refer to "the cell above me". When F2 then becomes F3, because someone
> has inserted a new row, the formula should still reference "the cell
> above me".

=OFFSET(F2,-1,0,1,1)

will do it.

-- 
JDL