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.
