From mboxrd@z Thu Jan  1 00:00:00 1970
From: Pete Phillips <pete@smtl.co.uk>
Subject: Re: problems with table mode
Date: Mon, 21 Apr 2008 07:38:19 +0100
Message-ID: <24015.1208759899@localhost>
References: <18277.1208719947@localhost>
	<07985476-0678-41F5-BB31-94E7F7E2010F@science.uva.nl>
	<18940.1208723747@localhost>
	<28F7F848-17BF-462C-B89D-A9E110D1E0FB@science.uva.nl>
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 1Jnpfn-0004Fk-Rr
	for emacs-orgmode@gnu.org; Mon, 21 Apr 2008 02:38:43 -0400
Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43)
	id 1Jnpfm-0004EM-1f
	for emacs-orgmode@gnu.org; Mon, 21 Apr 2008 02:38:43 -0400
Received: from [199.232.76.173] (helo=monty-python.gnu.org)
	by lists.gnu.org with esmtp (Exim 4.43) id 1Jnpfl-0004EA-Pj
	for emacs-orgmode@gnu.org; Mon, 21 Apr 2008 02:38:41 -0400
Received: from mailhost.smtl.co.uk ([193.131.77.174])
	by monty-python.gnu.org with esmtp (Exim 4.60)
	(envelope-from <pete@smtl.co.uk>) id 1Jnpfl-00034A-Gk
	for emacs-orgmode@gnu.org; Mon, 21 Apr 2008 02:38:41 -0400
In-reply-to: <28F7F848-17BF-462C-B89D-A9E110D1E0FB@science.uva.nl> 
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: Carsten Dominik <dominik@science.uva.nl>
Cc: org-mode mailing list <emacs-orgmode@gnu.org>

Hi Carsten

>>>>> "Carsten" == Carsten Dominik <dominik@science.uva.nl> writes:

    Carsten> the correct formula line would be

    Carsten> #+TBLFM:
    Carsten> @6$2=vsum(@II+1$2..@III-1$2)::@7$2=@1$2+@2$2-@III+1

Well, this is what I have been using, but I've had to change it each
time I add a new date. Hence my search for something more generic.

    Carsten> In order to make sure that the formula stays correct, you
    Carsten> need to make sure that you add more lines to the table only
    Carsten> with the proper command M-S-<down>.  When using this
    Carsten> command, the absolute references in the formulas are
    Carsten> modified.

Ah - OK - this is clearly a solution - I have been using kill and yank
commands to add new entries.

    Carsten> I can see that a construct like you have been using would
    Carsten> be useful, because it would allow normal editing of the
    Carsten> table and still keep the correct results.  I have taken a
    Carsten> note, maybe this can be implemented at some point.

OK - not a major problem now I understand what the problem is.

Thanks
Pete