When using orgmode for hacking on data in a table (org a la spreadsheet)  I have this situation<br>Say I am concentrating on column 2 and I want the bottom cell to be the sum of the above cells<br>For a 7 row table with 8th row having the total I get<br>
<br>  #+TBLFM: @8$2=vsum(@1$2..@7$2)<br><br>But now I have a problem: If say I add a row to the table then the next time I recompute the formula(s) the ninth row is not affected and the 8th row which is now data gets overwritten with a computation.<br>
<br>So basically I want the @1 and @7 which are hardcoded above to be replaced by something to the effect: &quot;everything above...&quot; and the @8$2 should be something to the tune of &quot;bottom of $2&quot;<br><br>I guess this may not be a reasonable request -- but with org you never know :-) so asking if there is some way.<br>