Re: Table summation

From: "Eddward DeVilla" <eddward@gmail.com>
To: emacs-orgmode@gnu.org
Subject: Re: Table summation
Date: Tue, 1 Apr 2008 16:58:51 -0500	[thread overview]
Message-ID: <b71b18520804011458m731709c5m7b16b79005c7ac3a@mail.gmail.com> (raw)
In-Reply-To: <20080401161935.GF2015@odin.demosthenes.org>

I'm not sure how tolerant you mean.  Would it help to use @-I and @-II

Edd

On Tue, Apr 1, 2008 at 11:19 AM, Russell Adams
<RLAdams@adamsinfoserv.com> wrote:
> On Tue, Apr 01, 2008 at 11:05:01AM -0500, Russell Adams wrote:
>  > Speaking of tables today, I thought I'd post a question that I haven't
>  > found a simple answer for.
>  >
>  > How do you sum a table reliably? (ie: tolerant of editing)
>  >
>  > This table requires the use of org-table-insert-row (etc...) in order
>  > to keep the formula correct.
>  >
>  > | Header |
>  > |--------|
>  > |      1 |
>  > |      2 |
>  > |      3 |
>  > |      4 |
>  > |      5 |
>  > |--------|
>  > |     15 |
>  > #+TBLFM: @7$1=vsum(@I..@II)
>  >
>  > How can I do something like this, where the last cell is automatically
>  > the sum of the column, and not an absolute reference that must be maintained?
>  >
>  > |      1 |
>  > |      2 |
>  > |      3 |
>  > |      4 |
>  > |      5 |
>  > |--------|
>  > |     15 |
>  > #+TBLFM: LAST=vsum($0..$0)
>  >
>  > Thanks.
>
>  In reply to myself, perhaps a way to refer to last cell would work.
>
>  |     15 |
>
> |--------|
>  |      1 |
>  |      2 |
>  |      3 |
>  |      4 |
>  |      5 |
>  #+TBLFM: @1$1=vsum($I..$LAST)
>
>  That way using tab on the value "5" would add a new line and not break
>  the formula reference.
>
>
>
>  Thanks.
>
>
>  ------------------------------------------------------------------
>  Russell Adams                            RLAdams@AdamsInfoServ.com
>
>  PGP Key ID:     0x1160DCB3           http://www.adamsinfoserv.com/
>
>  Fingerprint:    1723 D8CA 4280 1EC9 557F  66E8 1154 E018 1160 DCB3
>
>
>  _______________________________________________
>  Emacs-orgmode mailing list
>  Remember: use `Reply All' to send replies to the list.
>  Emacs-orgmode@gnu.org
>  http://lists.gnu.org/mailman/listinfo/emacs-orgmode
>