From mboxrd@z Thu Jan 1 00:00:00 1970 From: Rustom Mody Subject: making flexible table formulas Date: Mon, 28 Feb 2011 23:05:07 +0530 Message-ID: Mime-Version: 1.0 Content-Type: multipart/mixed; boundary="===============0991449891==" Return-path: Received: from [140.186.70.92] (port=40643 helo=eggs.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1Pu701-00068A-TV for emacs-orgmode@gnu.org; Mon, 28 Feb 2011 12:35:11 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1Pu700-0005S3-Ut for emacs-orgmode@gnu.org; Mon, 28 Feb 2011 12:35:09 -0500 Received: from mail-iy0-f169.google.com ([209.85.210.169]:45893) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1Pu700-0005Rn-Rp for emacs-orgmode@gnu.org; Mon, 28 Feb 2011 12:35:08 -0500 Received: by iyf13 with SMTP id 13so4212665iyf.0 for ; Mon, 28 Feb 2011 09:35:07 -0800 (PST) List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org To: emacs-orgmode --===============0991449891== Content-Type: multipart/alternative; boundary=20cf3043474ed450a5049d5b19d7 --20cf3043474ed450a5049d5b19d7 Content-Type: text/plain; charset=ISO-8859-1 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" I guess this may not be a reasonable request -- but with org you never know :-) so asking if there is some way. --20cf3043474ed450a5049d5b19d7 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable When using orgmode for hacking on data in a table (org a la spreadsheet)=A0= 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

=A0 #+TBLFM: @8$2=3Dvsum(@1$2..@7$2)

But now I have a problem: I= f 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 over= written with a computation.

So basically I want the @1 and @7 which are hardcoded above to be repla= ced by something to the effect: "everything above..." and the @8$= 2 should be something to the tune of "bottom of $2"

I gues= s this may not be a reasonable request -- but with org you never know :-) s= o asking if there is some way.
--20cf3043474ed450a5049d5b19d7-- --===============0991449891== Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline _______________________________________________ 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 --===============0991449891==--