Re: [Orgmode] Table summation

[Eddward DeVilla]

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
<address@hidden> 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(@address@hidden)
>  >
>  > 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                            address@hidden
>
>  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.
>  address@hidden
>  http://lists.gnu.org/mailman/listinfo/emacs-orgmode
>