From mboxrd@z Thu Jan 1 00:00:00 1970 From: Kim Toms Subject: Table equations: II on lhs Date: Mon, 1 Feb 2010 12:08:20 -0500 Message-ID: <1513b3111002010908l10a2fe09y34370a2cac29b371@mail.gmail.com> Mime-Version: 1.0 Content-Type: multipart/mixed; boundary="===============1764890416==" Return-path: Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1NbzlM-0003RZ-Bf for emacs-orgmode@gnu.org; Mon, 01 Feb 2010 12:08:36 -0500 Received: from [199.232.76.173] (port=45186 helo=monty-python.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1NbzlL-0003Qd-4A for emacs-orgmode@gnu.org; Mon, 01 Feb 2010 12:08:35 -0500 Received: from Debian-exim by monty-python.gnu.org with spam-scanned (Exim 4.60) (envelope-from ) id 1NbzlI-00059d-2e for emacs-orgmode@gnu.org; Mon, 01 Feb 2010 12:08:33 -0500 Received: from mx20.gnu.org ([199.232.41.8]:3093) by monty-python.gnu.org with esmtps (TLS-1.0:RSA_AES_256_CBC_SHA1:32) (Exim 4.60) (envelope-from ) id 1NbzlG-00058h-W8 for emacs-orgmode@gnu.org; Mon, 01 Feb 2010 12:08:31 -0500 Received: from mail-bw0-f215.google.com ([209.85.218.215]) by mx20.gnu.org with esmtp (Exim 4.60) (envelope-from ) id 1NbzlB-0008EL-5T for emacs-orgmode@gnu.org; Mon, 01 Feb 2010 12:08:25 -0500 Received: by bwz7 with SMTP id 7so2852999bwz.26 for ; Mon, 01 Feb 2010 09:08:20 -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@gnu.org --===============1764890416== Content-Type: multipart/alternative; boundary=0015174feb503899ef047e8d0861 --0015174feb503899ef047e8d0861 Content-Type: text/plain; charset=ISO-8859-1 I am using a simple table to add up some estimates for tasks. On the left hand side of the equations in the TBLFM line I can't get an expression like @II$2 to work. Here's an example | task | estimate | probable | |-------+----------+----------| | one | 12 | 2 | | two | 10 | 3 | |-------+----------+----------| | total | 22 | 5 | #+TBLFM: @4$2=vsum(@I..@II-1)::@4$3=vsum(@I..@II-1) I'd like to be able to put @II$2 on the LHS of the equation. That way, when I add a row to the table, the equation doesn't have to change. A workaround for the above table is to use $LR2 and $LR3 instead of the more general references. --0015174feb503899ef047e8d0861 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable I am using a simple table to add up some estimates for tasks. =A0On the lef= t hand side of the equations in the TBLFM line I can't get an expressio= n like @II$2 to work.

Here's an example
= | task =A0| estimate | probable |
|-------+----------+----= ------|
| one =A0 | =A0 =A0 =A0 12 | =A0 =A0 =A0 =A02 |
| two= =A0 | =A0 =A0 =A0 10 | =A0 =A0 =A0 =A03 |
|-------+----------+----------|
| total | =A0 =A0 =A0= 22 | =A0 =A0 =A0 =A05 |
#+TBLFM: @4$2=3Dvsum(@I..@II-1)::@4$3=3Dvsum(@I..@II-1)

I'd like to be able to put @II$2 on the LHS of the equati= on. =A0That way, when I add a row to the table, the equation doesn't ha= ve to change.

A workaround for the above table is to use $LR2 and $LR3= instead of the more general references.
--0015174feb503899ef047e8d0861-- --===============1764890416== 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 --===============1764890416==--