From mboxrd@z Thu Jan  1 00:00:00 1970
From: Daniel Hornung <daniel.hornung@gmx.de>
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: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([2001:4830:134:3::10]:35897)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <daniel.hornung@gmx.de>) 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 <daniel.hornung@gmx.de>) 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 <daniel.hornung@gmx.de>) 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
	<emacs-orgmode@gnu.org>; Mon, 19 Jan 2015 01:19:08 +0100
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <https://lists.gnu.org/mailman/options/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/archive/html/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <https://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=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--