From mboxrd@z Thu Jan 1 00:00:00 1970 From: Carsten Dominik Subject: Re: [BUG] Table not recomputed (incorrect results) Date: Tue, 10 Sep 2013 09:52:20 +0200 Message-ID: <2F10A217-094B-4E37-8E6E-9C2CBE3C2E39@gmail.com> References: <86a9jlflul.fsf@somewhere.org> <9C939351-40D7-4E6F-8CE1-CDC30227E006@gmail.com> <8661u9f762.fsf@somewhere.org> Mime-Version: 1.0 (Mac OS X Mail 6.5 \(1508\)) Content-Type: multipart/signed; boundary="Apple-Mail=_DB93C944-7453-4F8F-A47C-EF38F38EF48E"; protocol="application/pgp-signature"; micalg=pgp-sha1 Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:47186) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1VJIkO-00037X-GY for emacs-orgmode@gnu.org; Tue, 10 Sep 2013 03:52:34 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1VJIkI-0006ts-M2 for emacs-orgmode@gnu.org; Tue, 10 Sep 2013 03:52:28 -0400 Received: from mail-ee0-x236.google.com ([2a00:1450:4013:c00::236]:64338) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1VJIkI-0006tk-Ep for emacs-orgmode@gnu.org; Tue, 10 Sep 2013 03:52:22 -0400 Received: by mail-ee0-f54.google.com with SMTP id e53so3737932eek.27 for ; Tue, 10 Sep 2013 00:52:21 -0700 (PDT) In-Reply-To: <8661u9f762.fsf@somewhere.org> 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: Sebastien Vauban Cc: emacs-orgmode@gnu.org --Apple-Mail=_DB93C944-7453-4F8F-A47C-EF38F38EF48E Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii On 10.9.2013, at 09:49, Sebastien Vauban = wrote: > Hi Carsten, >=20 > Carsten Dominik wrote: >> On 10.9.2013, at 04:32, "Sebastien Vauban" = wrote: >>>=20 >>> I'm loosing my latin with the following table, which Org declares as >>> "converged" or "already stable". >>>=20 >>> --8<---------------cut here---------------start------------->8--- >>> #+TITLE: Birthday >>>=20 >>> * Commande >>>=20 >>> | mini sandwiches | 261 | 1.00 | 260.00 | >>> | rauwkostchotels | 2 | 36. | 72.00 | >>> | koude hapjes | 130 | | 0.00 | >>> | dessertjes (in hapjes glaasjes) | 90 | 3 | 0.00 | >>> |---------------------------------+-----+------+--------| >>> | total | | | 332. | >>> #+TBLFM: $4=3D$2*$3;%.2f::@2$3=3D30*1.2::@5$4=3Dvsum(@1..@-1) >>> --8<---------------cut here---------------end--------------->8--- >>>=20 >>> Obviously, if you look at the amounts, it isn't correct... >>=20 >> The first four lines are all above the first hline and >> are therefore treated as header and are exempt from calculation. >> Formular applying to these fields are ignored. >=20 > Whoa. Did not know that... (or already forgotten about!) It has to be like this, otherwise any column formula would destroy the = header! - Carsten >=20 >> Add a header line to the table: >=20 > OK, thanks! >=20 > Best regards, > Seb >=20 > --=20 > Sebastien Vauban >=20 >=20 --Apple-Mail=_DB93C944-7453-4F8F-A47C-EF38F38EF48E Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename=signature.asc Content-Type: application/pgp-signature; name=signature.asc Content-Description: Message signed with OpenPGP using GPGMail -----BEGIN PGP SIGNATURE----- iEYEARECAAYFAlIuz7QACgkQ9hweYzZiJkwCCgCdFjHi7o7ekXthD2XrBOss6BkE R38AoIlGlpnSr1g/ynaL1Dpt2yQSmPFI =0lLk -----END PGP SIGNATURE----- --Apple-Mail=_DB93C944-7453-4F8F-A47C-EF38F38EF48E--