On Mon, Feb 28, 2011 at 9:35 AM, Rustom Mody <rustompm...@gmail.com> wrote:
> When using orgmode for hacking on data in a table (org a la spreadsheet) I > have this situation > Say I am concentrating on column 2 and I want the bottom cell to be the sum > of the above cells > For a 7 row table with 8th row having the total I get > > #+TBLFM: @8$2=vsum(@1$2..@7$2) > > 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. > > So basically I want the @1 and @7 which are hardcoded above to be replaced > by something to the effect: "everything above..." and the @8$2 should be > something to the tune of "bottom of $2" > Place the rows you want to sum between horizontal separator lines (see http://orgmode.org/manual/Built_002din-table-editor.html#Built_002din-table-editor ) Then you can do the following: #+TBLFM: @8$2=vsum(@I..@II) Which means, sum the columns between the first and the second separators. -Luke
_______________________________________________ Emacs-orgmode mailing list Please use `Reply All' to send replies to the list. Emacs-orgmode@gnu.org http://lists.gnu.org/mailman/listinfo/emacs-orgmode
