[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [O] relative row reference in table formula
From: |
Juan Pechiar |
Subject: |
Re: [O] relative row reference in table formula |
Date: |
Thu, 1 Mar 2012 14:54:49 -0200 |
User-agent: |
Mutt/1.5.20 (2009-06-14) |
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(@address@hidden);%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.