From mboxrd@z Thu Jan  1 00:00:00 1970
From: "Eddward DeVilla" <eddward@gmail.com>
Subject: Re: Table summation
Date: Tue, 1 Apr 2008 16:58:51 -0500
Message-ID: <b71b18520804011458m731709c5m7b16b79005c7ac3a@mail.gmail.com>
References: <20080401160501.GE2015@odin.demosthenes.org>
	<20080401161935.GF2015@odin.demosthenes.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43)
	id 1JgrHj-0003ZT-LG
	for emacs-orgmode@gnu.org; Tue, 01 Apr 2008 20:57:03 -0400
Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43)
	id 1JgrHj-0003Z7-0T
	for emacs-orgmode@gnu.org; Tue, 01 Apr 2008 20:57:03 -0400
Received: from [199.232.76.173] (helo=monty-python.gnu.org)
	by lists.gnu.org with esmtp (Exim 4.43) id 1JgrHi-0003Z2-SE
	for emacs-orgmode@gnu.org; Tue, 01 Apr 2008 20:57:02 -0400
Received: from yw-out-1718.google.com ([74.125.46.155])
	by monty-python.gnu.org with esmtp (Exim 4.60)
	(envelope-from <eddward@gmail.com>) id 1JgrHi-0004Xi-Lt
	for emacs-orgmode@gnu.org; Tue, 01 Apr 2008 20:57:02 -0400
Received: by yw-out-1718.google.com with SMTP id 9so602078ywk.66
	for <emacs-orgmode@gnu.org>; Tue, 01 Apr 2008 17:57:02 -0700 (PDT)
In-Reply-To: <20080401161935.GF2015@odin.demosthenes.org>
Content-Disposition: inline
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <http://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/pipermail/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <http://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=subscribe>
Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
To: emacs-orgmode@gnu.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
>