From mboxrd@z Thu Jan  1 00:00:00 1970
From: Juan Pechiar <juan@pechiar.com>
Subject: Re: relative row reference in table formula
Date: Thu, 1 Mar 2012 14:54:49 -0200
Message-ID: <20120301165449.GA6258@soloJazz.com>
References: <20120301140139.GC7899@merlot.gcoop.coop>
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 eggs.gnu.org ([208.118.235.92]:58437)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <juan@pechiar.com>) id 1S39Hl-0007z9-9k
	for emacs-orgmode@gnu.org; Thu, 01 Mar 2012 11:55:26 -0500
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <juan@pechiar.com>) id 1S39HM-0002BW-Dv
	for emacs-orgmode@gnu.org; Thu, 01 Mar 2012 11:55:20 -0500
Received: from oproxy8-pub.bluehost.com ([69.89.22.20]:48730)
	by eggs.gnu.org with smtp (Exim 4.71)
	(envelope-from <juan@pechiar.com>) id 1S39HL-000298-Ug
	for emacs-orgmode@gnu.org; Thu, 01 Mar 2012 11:54:56 -0500
Content-Disposition: inline
In-Reply-To: <20120301140139.GC7899@merlot.gcoop.coop>
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <https://lists.gnu.org/mailman/options/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/archive/html/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <https://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=subscribe>
Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
To: OSiUX <xuiso@osiux.com.ar>
Cc: emacs-orgmode@gnu.org

Hi Osiris,

On Thu, Mar 01, 2012 at 11:01:39AM -0300, OSiUX wrote:
> is possible to define the reference to the last row of the following @II+$3, to avoid
> having to change the number of row (@4$3)?
>
> in this example does not calculate:
>
>   | date             | item          |    cost |
>   |------------------+---------------+---------|
>   | [2012-03-01 jue] | item 1        |   30.00 |
>   | [2012-03-01 jue] | item 2        |   20.00 |
>   |------------------+---------------+---------|
>   |                  |               |   30.00 |
>   #+TBLFM: @II+$3=vsum(@I..@II);%0.2f

It should be '@II+1$3' according to documentation, but anyway it
doesn't get evaluated.

However, '@>$3' (meaning the last row, col 3) does get evaluated
correctly.

In any case, if you add/remove rows/columns using M-S-arrows, the
absolute formula references get updated accordingly (e.g. formula at
@4$3 goes to @5$3 after inserting a row).

Saludos,
.j.