From mboxrd@z Thu Jan 1 00:00:00 1970 From: OSiUX Subject: relative row reference in table formula Date: Thu, 1 Mar 2012 11:01:39 -0300 Message-ID: <20120301140139.GC7899@merlot.gcoop.coop> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="da4uJneut+ArUgXk" Return-path: Received: from eggs.gnu.org ([208.118.235.92]:36350) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1S36Zu-0008Uf-DE for emacs-orgmode@gnu.org; Thu, 01 Mar 2012 09:02:00 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1S36Zo-0008Pp-BD for emacs-orgmode@gnu.org; Thu, 01 Mar 2012 09:01:53 -0500 Received: from merlot.gcoop.coop ([67.208.113.123]:52776) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1S36Zo-0008PU-7J for emacs-orgmode@gnu.org; Thu, 01 Mar 2012 09:01:48 -0500 Received: from merlot.gcoop.coop (merlot [127.0.0.1]) (Authenticated sender: xuiso@osiux.com.ar) by merlot.gcoop.coop (Postfix) with ESMTPSA id ABDAC149CF9 for ; Thu, 1 Mar 2012 11:02:04 -0300 (ART) Content-Disposition: inline List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org To: emacs-orgmode@gnu.org --da4uJneut+ArUgXk Content-Type: text/plain; charset=us-ascii Content-Disposition: inline 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 thanks! -- :: Osiris Alejandro Gomez (OSiUX) osiux@osiux.com.ar AA70 93FD B6EF EB42 6920 7530 A799 B226 74C8 A3FE http://osiux.com http://wiki.buenosaireslibre.org --da4uJneut+ArUgXk Content-Type: application/pgp-signature; name="signature.asc" Content-Description: Digital signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) iQIcBAEBAgAGBQJPT4FDAAoJEKeZsiZ0yKP+H14P/2xcUJJnrGVji407gBnMu6Ca U0DSGo3uO1zdpAkNi+URiu/q565Um5WM+L2weC2SCZIrgO8dvKaaOsliQz5MAN0O IL1salFtG7HgLA9mxeOl9160t9zvTbzs9nUs2oO137j2wQDKp6jLIOOLo5xT5bsI TRTJQXIwLOEXl5KFTa8spYtcvoJbP1c1xMtsyunyHwkFYn3kMVuiBEvg4fQptpYo A0nZr1sJA1Lgg5LvPGU1w97qbG1nJgubb57QEygoYMRgdRrOEXtMOd57Eu/HbBAK kfnUmaE61vGI53W0K/f4pPTaO/T8VOU3nTOtgPdAtqWlEM9sqftKoLijzVagVLvd fW3uOyhc1UKM6lovqivDkOkmI5WMK9TjESLSA4JraTj1IxvwPy09VBW0ZKMYNRnM QTh5CgD4hy8obzHgl+yq4AZjBsO7CqlUzsina9Ftebkzvus9+bqYzElzTnkhTR/H kUqeO78qh4WJf8XcvW8cX+4t7TP0tWhISTs/0shTGQaANZAhezF0uA+AiXzjdVAg ljy4Gu6O99nRJmqMp4B8aR8zOh6W1Sb8Nw0qhXa4aJ3DCVzjD5jmxN7foibEJUuZ MkLlTDND5jCgi3kyzE4iyQ9FRrIqOcbrkrm+hYeuhm+Rc/qooGRWxxeF9D80PKZ/ dKD6veV5TZ/9n0bW1X3X =16M+ -----END PGP SIGNATURE----- --da4uJneut+ArUgXk--