From mboxrd@z Thu Jan  1 00:00:00 1970
From: Rainer Stengele <rainer.stengele@diplan.de>
Subject: question concerning table mode / vsum / automatic adjustments of
 indices
Date: Wed, 27 Aug 2008 13:35:02 +0200
Message-ID: <48B53BE6.9040503@diplan.de>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
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 1KYJJ2-000107-4t
	for emacs-orgmode@gnu.org; Wed, 27 Aug 2008 07:35:20 -0400
Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43)
	id 1KYJIy-0000zR-AG
	for emacs-orgmode@gnu.org; Wed, 27 Aug 2008 07:35:19 -0400
Received: from [199.232.76.173] (port=35202 helo=monty-python.gnu.org)
	by lists.gnu.org with esmtp (Exim 4.43) id 1KYJIy-0000zO-50
	for emacs-orgmode@gnu.org; Wed, 27 Aug 2008 07:35:16 -0400
Received: from main.gmane.org ([80.91.229.2]:60351 helo=ciao.gmane.org)
	by monty-python.gnu.org with esmtps (TLS-1.0:RSA_AES_256_CBC_SHA1:32)
	(Exim 4.60) (envelope-from <geo-emacs-orgmode@m.gmane.org>)
	id 1KYJIx-0003M8-Ey
	for emacs-orgmode@gnu.org; Wed, 27 Aug 2008 07:35:16 -0400
Received: from list by ciao.gmane.org with local (Exim 4.43)
	id 1KYJIo-0002Ay-Rf
	for emacs-orgmode@gnu.org; Wed, 27 Aug 2008 11:35:07 +0000
Received: from 212.34.176.74 ([212.34.176.74])
	by main.gmane.org with esmtp (Gmexim 0.1 (Debian))
	id 1AlnuQ-0007hv-00
	for <emacs-orgmode@gnu.org>; Wed, 27 Aug 2008 11:35:06 +0000
Received: from rainer.stengele by 212.34.176.74 with local (Gmexim 0.1
	(Debian)) id 1AlnuQ-0007hv-00
	for <emacs-orgmode@gnu.org>; Wed, 27 Aug 2008 11:35:06 +0000
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
Cc: =?ISO-8859-1?Q?Benedikt_Pf=FClb?= <benedikt.pfuelb@diplan.de>

I mostly have the same application of using org tables.
I have (many) columns with numbers and want to see the sum in the last row.

See this little example:

        |-------+--------|
        | items | amount |
        |-------+--------|
        | a     |    0.5 |
        | b     |    0.0 |
        | c     |    0.5 |
        |-------+--------|
        | sum   |     1. |
        |-------+--------|
#+TBLFM:    @5$2=vsum(@2..4)


Having the cursor on the row with "c"
and pressing <M-S-DOWN> I get this:

        |-------+--------|
        | items | amount |
        |-------+--------|
        | a     |    0.5 |
        | b     |    0.0 |
        |       |        |
        | c     |    0.5 |
        |-------+--------|
        | sum   |     1. |
        |-------+--------|
#+TBLFM:    @6$2=vsum(@2..@5)

everything is adjusted correctly!


Now I want to add a row after "c". Being on the row below "c"
when I press <M-S-DOWN> I get this:

        |-------+--------|
        | items | amount |
        |-------+--------|
        | a     |    0.5 |
        | b     |    0.0 |
        | c     |    0.5 |
        |       |        |
        |-------+--------|
        | sum   |     1. |
        |-------+--------|
#+TBLFM:    @6$2=vsum(@2..@4)

which is not what I want. I want "@5" as in the case before.
Is this a bug or a feature? How can I get what I need?

Thanks!


Rainer