From mboxrd@z Thu Jan 1 00:00:00 1970 From: Daniel Hornung Subject: Table calculations with hline references Date: Mon, 19 Jan 2015 01:19:04 +0100 Message-ID: <5451536.a99QyLx36R@whatnow> Mime-Version: 1.0 Content-Type: multipart/signed; boundary="nextPart6525914.ErtH8Ykc7T"; micalg="pgp-sha1"; protocol="application/pgp-signature" Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:35897) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1YD03n-0007it-OJ for emacs-orgmode@gnu.org; Sun, 18 Jan 2015 19:19:16 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1YD03i-0001WG-Pr for emacs-orgmode@gnu.org; Sun, 18 Jan 2015 19:19:15 -0500 Received: from mout.gmx.net ([212.227.17.22]:59539) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1YD03i-0001W8-FJ for emacs-orgmode@gnu.org; Sun, 18 Jan 2015 19:19:10 -0500 Received: from mailsender ([82.83.240.239]) by mail.gmx.com (mrgmx101) with ESMTPSA (Nemesis) id 0M2Glc-1XuMkC1y7g-00s8c0 for ; Mon, 19 Jan 2015 01:19:08 +0100 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 --nextPart6525914.ErtH8Ykc7T Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset="iso-8859-1" Hi, I am trying to calculate a field using references to horizontal lines=20= according to http://orgmode.org/manual/References.html For example: | col1 | col2 | |------+------| | foo | 1 | | bar | 2 | | baz | 4 | |------+------| | sum | | | | | #+TBLFM: @II+1$2=3Dvsum(@I$2..@II$2) The field to the right of "sum" (@5$2 as a fixed reference) should be "= 7". The output is as follows though (the cursor was in the "baz" field when I pressed "C-u C-c *" to recalculate all formulas): | col1 | col2 | |------+------| | foo | 1 | | bar | 2 | | 7 | 7 | |------+------| | 10 | 10 | | | | #+TBLFM: @II+1$2=3Dvsum(@I$2..@II$2) Could anyone enlighten me where I made a mistake here? Thanks a lot, Daniel =2D-=20 Mein =F6ffentlicher Schl=FCssel / My public key: 4096R/600ACB3B 2012-04= =2D01 Fingerabdruck / Fingerprint: 9902 575B B9A0 C339 CFDF 250B 9267 CA6B 600A CB3B Runterladen z.B. bei/ Get it e.g. from: pgp.mit.edu, subkeys.pgp.net, pgp.uni-mainz.de, pool.sks-keyservers.net= , ... --nextPart6525914.ErtH8Ykc7T Content-Type: application/pgp-signature; name="signature.asc" Content-Description: This is a digitally signed message part. Content-Transfer-Encoding: 7Bit -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.22 (GNU/Linux) iQIcBAABAgAGBQJUvE17AAoJEJJnymtgCss7EvMQAKPZeT4Qek5sdS3YxXPQAUQz 84G7Mh0Qub91dJU0/V6cdhO+Wk6kwrEywO6/3fmafhmzDcybtbsMTI4Elon9Utf/ FJr8lIqQOLhpbbCq4d5LMI39OmonPWlHT4ep1ALfpWfSH00luCmi+eDe4ZM5HNYR q4xVc/8Qpwz/mtLCoWFCEzZXl/hcjJJ7OXcdEz6keUVcdM5YP+lzv8/37lejJ9XJ pw5rZETT5fxucmx2ErsQctNApShB7oybFSt6UsPmVQqyCRLjTYkV6jerbvAdeIrU Vk+i0oxx+U5DO74bL3MHRNeU6hUC7Z7qXVzlj3prBWVgims2UvGiIxc7uSPTE9A3 cE/pSjovF4F20LIHjILwEpQLXHWB4S6w+On+VQM22HUFcgoZYiFJt/hLiKGcRH4x R4mb+bF85DhwxG8SZhduUovkONNWoPOvTDKdIVqdk9QuqDq+ppttJiu+patGhnmU Zh8FKTDasho9WejhWxRcvvGFoYc52gvBZjl7MXkqet/DzkmFJaoo0YeoySslXras hv3jDFgX5J0ORRep2dUK4XMc9pdT8tpybSw7pDU2hpX8Gctz40677WITVuPtcL8Q cmQJp6KbCKbloQhN8uizDNg9+y9d/1vzsL3xVZyY6okG1n6qjdleHAp08dJ6WRbn E562w7/6OqudqCH4T12K =NEAl -----END PGP SIGNATURE----- --nextPart6525914.ErtH8Ykc7T--