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 05:44:17 +0200 Message-ID: <9C939351-40D7-4E6F-8CE1-CDC30227E006@gmail.com> References: <86a9jlflul.fsf@somewhere.org> Mime-Version: 1.0 (Mac OS X Mail 6.5 \(1508\)) Content-Type: multipart/signed; boundary="Apple-Mail=_D4499DC6-03F4-440B-81A6-352FEE5B59C0"; protocol="application/pgp-signature"; micalg=pgp-sha1 Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:51714) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1VJEsL-0004sh-VM for emacs-orgmode@gnu.org; Mon, 09 Sep 2013 23:44:31 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1VJEsG-0004Za-3I for emacs-orgmode@gnu.org; Mon, 09 Sep 2013 23:44:25 -0400 Received: from mail-ee0-x234.google.com ([2a00:1450:4013:c00::234]:33743) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1VJEsF-0004ZM-RW for emacs-orgmode@gnu.org; Mon, 09 Sep 2013 23:44:20 -0400 Received: by mail-ee0-f52.google.com with SMTP id c41so3591157eek.11 for ; Mon, 09 Sep 2013 20:44:18 -0700 (PDT) In-Reply-To: <86a9jlflul.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=_D4499DC6-03F4-440B-81A6-352FEE5B59C0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=us-ascii On 10.9.2013, at 04:32, "Sebastien Vauban" wrote: > Hello, > > I'm loosing my latin with the following table, which Org declares as > "converged" or "already stable". > > --8<---------------cut here---------------start------------->8--- > #+TITLE: Birthday > > * Commande > > | 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=$2*$3;%.2f::@2$3=30*1.2::@5$4=vsum(@1..@-1) > > Total paid: *580 EUR*... > --8<---------------cut here---------------end--------------->8--- > > Obviously, if you look at the amounts, it isn't correct... > Hi Sebastien, 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. Add a header line to the table: | a | b | c | d | |---------------------------------+-----+------+------| | mini sandwiches | 261 | 1.00 | 261. | | rauwkostchotels | 2 | 36. | 72. | | koude hapjes | 130 | | 0 | | dessertjes (in hapjes glaasjes) | 90 | 3 | 270 | |---------------------------------+-----+------+------| | total | | | 0 | #+TBLFM: $4=$2*$3;%.2f::@2$3=30*1.2::@5$4=vsum(@1..@-1) Cheers - Carsten > What am I not seeing? > > Best regards, > Seb > > -- > Sebastien Vauban > > --Apple-Mail=_D4499DC6-03F4-440B-81A6-352FEE5B59C0 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----- iEYEARECAAYFAlIulZEACgkQ9hweYzZiJkzQdgCffkL3iUHD3pXTmIJ6gO4eualR Md4Anjk56dd/H03i2pNKZ9GAj3WHf7cw =EJY9 -----END PGP SIGNATURE----- --Apple-Mail=_D4499DC6-03F4-440B-81A6-352FEE5B59C0--