From mboxrd@z Thu Jan  1 00:00:00 1970
From: "William Henney" <whenney@gmail.com>
Subject: Re: question concerning table mode / vsum / automatic adjustments of
 indices
Date: Fri, 29 Aug 2008 06:27:37 -0500
Message-ID: <41c818190808290427xa2776a8p2ff44f8ae6c16919@mail.gmail.com>
References: <48B53BE6.9040503@diplan.de>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
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 1KZ28i-0007qG-1c
	for emacs-orgmode@gnu.org; Fri, 29 Aug 2008 07:27:40 -0400
Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43)
	id 1KZ28h-0007p8-52
	for emacs-orgmode@gnu.org; Fri, 29 Aug 2008 07:27:39 -0400
Received: from [199.232.76.173] (port=34797 helo=monty-python.gnu.org)
	by lists.gnu.org with esmtp (Exim 4.43) id 1KZ28g-0007os-Oy
	for emacs-orgmode@gnu.org; Fri, 29 Aug 2008 07:27:38 -0400
Received: from ey-out-1920.google.com ([74.125.78.147]:63499)
	by monty-python.gnu.org with esmtp (Exim 4.60)
	(envelope-from <whenney@gmail.com>) id 1KZ28g-0003Eh-BN
	for emacs-orgmode@gnu.org; Fri, 29 Aug 2008 07:27:38 -0400
Received: by ey-out-1920.google.com with SMTP id 4so255594eyg.24
	for <emacs-orgmode@gnu.org>; Fri, 29 Aug 2008 04:27:37 -0700 (PDT)
In-Reply-To: <48B53BE6.9040503@diplan.de>
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: Rainer Stengele <rainer.stengele@diplan.de>
Cc: =?ISO-8859-1?Q?Benedikt_Pf=FClb?= <benedikt.pfuelb@diplan.de>, emacs-orgmode@gnu.org

Hi Rainer

On Wed, Aug 27, 2008 at 6:35 AM, Rainer Stengele
<rainer.stengele@diplan.de> wrote:
> 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=3Dvsum(@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?
>

The way you have written the vsum, org has no way of knowing that you
really want to sum all the rows between the previous two horizontal
lines. Instead, you should put vsum(@-II..@-I) to tell it this
explicitly. That way, you can even add/delete rows "by hand" and it
will still work.

Hope this helps

Will


--=20

 Dr William Henney, Centro de Radioastronom=EDa y Astrof=EDsica,
 Universidad Nacional Aut=F3noma de M=E9xico, Campus Morelia