From mboxrd@z Thu Jan  1 00:00:00 1970
From: Russell Adams <RLAdams@AdamsInfoServ.Com>
Subject: Re: Table summation
Date: Tue, 1 Apr 2008 11:19:35 -0500
Message-ID: <20080401161935.GF2015@odin.demosthenes.org>
References: <20080401160501.GE2015@odin.demosthenes.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
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 1JgjD9-0002pl-TL
	for emacs-orgmode@gnu.org; Tue, 01 Apr 2008 12:19:47 -0400
Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43)
	id 1JgjD9-0002ou-9r
	for emacs-orgmode@gnu.org; Tue, 01 Apr 2008 12:19:47 -0400
Received: from [199.232.76.173] (helo=monty-python.gnu.org)
	by lists.gnu.org with esmtp (Exim 4.43) id 1JgjD8-0002oP-TM
	for emacs-orgmode@gnu.org; Tue, 01 Apr 2008 12:19:46 -0400
Received: from squirtle.drak.net ([72.52.144.201])
	by monty-python.gnu.org with esmtps
	(TLS-1.0:DHE_RSA_AES_256_CBC_SHA1:32) (Exim 4.60)
	(envelope-from <rladams@adamsinfoserv.com>) id 1JgjD8-0001sB-Hr
	for emacs-orgmode@gnu.org; Tue, 01 Apr 2008 12:19:46 -0400
Received: from [206.180.154.177] (helo=localhost)
	by squirtle.drak.net with esmtpa (Exim 4.68)
	(envelope-from <rladams@adamsinfoserv.com>) id 1JgjCt-00052F-72
	for emacs-orgmode@gnu.org; Tue, 01 Apr 2008 11:19:31 -0500
Content-Disposition: inline
In-Reply-To: <20080401160501.GE2015@odin.demosthenes.org>
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

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