From mboxrd@z Thu Jan 1 00:00:00 1970 From: =?utf-8?Q?Oliver_Ve=C4=8Dern=C3=ADk?= Subject: Spreadsheet calculations (24.3/8.0-pre) Date: Mon, 18 Mar 2013 10:52:32 +0100 Message-ID: <87li9lm3vj.fsf@kerstf.org> Mime-Version: 1.0 Content-Type: text/plain Return-path: Received: from eggs.gnu.org ([208.118.235.92]:43788) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1UHX5d-0006xE-MO for emacs-orgmode@gnu.org; Mon, 18 Mar 2013 06:14:51 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1UHX5a-0007di-JF for emacs-orgmode@gnu.org; Mon, 18 Mar 2013 06:14:49 -0400 Received: from plane.gmane.org ([80.91.229.3]:53504) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1UHX5a-0007db-CL for emacs-orgmode@gnu.org; Mon, 18 Mar 2013 06:14:46 -0400 Received: from list by plane.gmane.org with local (Exim 4.69) (envelope-from ) id 1UHX5s-0003XW-Eu for emacs-orgmode@gnu.org; Mon, 18 Mar 2013 11:15:04 +0100 Received: from 178.112.84.104.wireless.dyn.drei.com ([178.112.84.104]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Mon, 18 Mar 2013 11:15:04 +0100 Received: from ov by 178.112.84.104.wireless.dyn.drei.com with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Mon, 18 Mar 2013 11:15:04 +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 Hi, I'm trying to do some simple calculations, but the results are plain wrong. I started the minimal example with `emacs -Q -l minimal.emacs org/minimal.org'. My Emacs is 24.3 with Org-mode version 8.0-pre (release_8.0-pre-116-g65cde8 @ /home/ov/p/org-mode/lisp/): #+TITLE: Nutrition Facts #+CONSTANTS: b=100 j=4.182 #+TBLNAME: nf | Product | kJ | kcal | |-----------+------+------| | Bread | 1372 | 328 | | Butter | 3054 | 730 | | Marmalade | 926 | 221 | #+TBLFM: $3=$2/$j;%.0f Here are some calculations per portion (plain wrong): | Product | g | kJ | kcal | |-----------+------+------+------| | Bread | 50.6 | 658 | 157 | | Butter | 11.5 | 150 | 36 | | Marmalade | 19.7 | 256 | 61 | |-----------+------+------+------| | | | 1064 | 254 | #+TBLFM: $3='(* $2 (/ (org-lookup-first $1 '(remote(nf,@I$1..@II$1)) '(remote(nf,@I$2..@II$2))) 100));N%.0f::$4=$3/$j;%.0f::@>$3..$4=vsum(@I..II) Expected: | Product | g | kJ | kcal | |-----------+------+------+------| | Bread | 50.6 | 694 | 166 | | Butter | 11.5 | 351 | 84 | | Marmalade | 19.7 | 182 | 44 | |-----------+------+------+------| | | | 1227 | 294 | #+TBLFM: $4=$3/$j;%.0f::@>$3..$4=vsum(@I..II) Using the constant b is also totally wrong: | Product | g | kJ | kcal | |-----------+------+----+------| | Bread | 50.6 | 0 | 0 | | Butter | 11.5 | 0 | 0 | | Marmalade | 19.7 | 0 | 0 | |-----------+------+----+------| | | | 0 | 0 | #+TBLFM: $3='(* $2 (/ (org-lookup-first $1 '(remote(nf,@I$1..@II$1)) '(remote(nf,@I$2..@II$2))) $b));N%.0f::$4=$3/$j;%.0f::@>$3..$4=vsum(@I..II) These results are achieved using `C-c C-c' on the first column of the format line. If I use `C-u C-c C-c' in the tabel I get different results *every* time. E.g. pressing `C-u C-c C-c' three times on the `B' of `Bread': | Product | g | kJ | kcal | |-----------+------+--------+-------| | Bread | 50.6 | 32606 | 7784 | | Butter | 11.5 | 59888 | 14297 | | Marmalade | 19.7 | 110192 | 26306 | |-----------+------+--------+-------| | | | 202686 | 48387 | #+TBLFM: $3='(* $2 (/ (org-lookup-first $1 '(remote(nf,@I$1..@II$1)) '(remote(nf,@I$2..@II$2))) 100));N%.0f::$4=$3/$j;%.0f::@>$3..$4=vsum(@I..II) If I go to the end of the format line and press `C-c C-c' I get totally different results as at the beginning: | Product | g | 1064 | 254 | |-----------+------+------+------| | Bread | 50.6 | 1064 | 254 | | Butter | 11.5 | 1470 | 351 | | Marmalade | 19.7 | 2790 | 666 | |-----------+------+------+------| | | | 5324 | 1271 | #+TBLFM: $3='(* $2 (/ (org-lookup-first $1 '(remote(nf,@I$1..@II$1)) '(remote(nf,@I$2..@II$2))) 100));N%.0f::$4=$3/$j;%.0f::@>$3..$4=vsum(@I..II) If I use `M-x org-table-recalculate-buffer-tables' even the headlines get screwed up. Am I doing something wrong or are there severe problems in the spreadsheet mode? Thanks in advance! -- Regards, Oliver