[O] relative row reference in table formula

[OSiUX]

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

thanks!

--

::

  Osiris Alejandro Gomez (OSiUX) os...@osiux.com.ar
  AA70 93FD B6EF EB42 6920 7530 A799 B226 74C8 A3FE
  http://osiux.com http://wiki.buenosaireslibre.org


signature.asc
Description: Digital signature

Re: [O] relative row reference in table formula

[Juan Pechiar]

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.