Linux Archive

Linux Archive (http://www.linux-archive.org/)
-   Ubuntu User (http://www.linux-archive.org/ubuntu-user/)
-   -   open office cell self-reference? (http://www.linux-archive.org/ubuntu-user/585290-open-office-cell-self-reference.html)

Karl Auer 10-09-2011 02:11 AM

open office cell self-reference?
 
Hi there.

This question might be better posed in an OpenOffice group, but Ubuntu
folk are OO users, so maybe you guys have an answer for me :-)

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

I've googled lots, experimented lots, but cannot find this (to me,
obvious) way of referencing a cell.

Any ideas?

Regards, K.

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~
Karl Auer (kauer@biplane.com.au) +61-2-64957160 (h)
http://www.biplane.com.au/kauer/ +61-428-957160 (mob)

GPG fingerprint: DA41 51B1 1481 16E1 F7E2 B2E9 3007 14ED 5736 F687
Old fingerprint: B386 7819 B227 2961 8301 C5A9 2EBC 754B CD97 0156
--
ubuntu-users mailing list
ubuntu-users@lists.ubuntu.com
Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-users

John D Lamb 10-09-2011 08:07 AM

open office cell self-reference?
 
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


--
ubuntu-users mailing list
ubuntu-users@lists.ubuntu.com
Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-users


All times are GMT. The time now is 03:04 AM.

VBulletin, Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO ©2007, Crawlability, Inc.