From mboxrd@z Thu Jan  1 00:00:00 1970
From: Cecil Westerhof <CecilWesterhof@xs4all.nl>
Subject: how to clear computed values
Date: Tue, 10 Jul 2007 20:38:49 +0200
Message-ID: <1184092729.6283.91.camel@Barebusta.DecebalComp>
Mime-Version: 1.0
Content-Type: text/plain
Content-Transfer-Encoding: 7bit
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43)
	id 1I8Kjp-0001LN-5Z
	for emacs-orgmode@gnu.org; Tue, 10 Jul 2007 14:47:05 -0400
Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43)
	id 1I8Kjn-0001Dz-KQ
	for emacs-orgmode@gnu.org; Tue, 10 Jul 2007 14:47:04 -0400
Received: from [199.232.76.173] (helo=monty-python.gnu.org)
	by lists.gnu.org with esmtp (Exim 4.43) id 1I8Kjn-0001DJ-Fj
	for emacs-orgmode@gnu.org; Tue, 10 Jul 2007 14:47:03 -0400
Received: from smtp-vbr4.xs4all.nl ([194.109.24.24])
	by monty-python.gnu.org with esmtp (Exim 4.60)
	(envelope-from <CecilWesterhof@xs4all.nl>) id 1I8Kbu-00077c-HC
	for emacs-orgmode@gnu.org; Tue, 10 Jul 2007 14:38:55 -0400
Received: from Barebusta.DecebalComp (DecebalComputing.xs4all.nl
	[213.84.157.201])
	by smtp-vbr4.xs4all.nl (8.13.8/8.13.8) with ESMTP id l6AIcnhj078284
	for <emacs-orgmode@gnu.org>; Tue, 10 Jul 2007 20:38:50 +0200 (CEST)
	(envelope-from CecilWesterhof@xs4all.nl)
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <http://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/pipermail/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <http://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=subscribe>
Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
To: org-mode <emacs-orgmode@gnu.org>

I have a table like:
        |---------+---------+---------+--------+-------+----------+--------|
        | kmstand |    km's | prijs/l | liters | prijs | prijs/km |   km/l |
        |---------+---------+---------+--------+-------+----------+--------|
        |  155111 |       0 |         |        |  0.00 |   -0.000 |  0.000 |
        |  156146 |    1035 |   102.2 |  62.25 | 63.62 |    6.147 | 16.627 |
        |         | -156146 |         |        |  0.00 |   -0.000 |  0.000 |
        |---------+---------+---------+--------+-------+----------+--------|
        #+TBLFM: $2='(and @-1$-1 $1 (- $1 @-1$-1));N::$5='(and $3 $4 (/ (* $3 $4) 100));N%.2f::$6='(and $2 $5 (/ (* $5 100) $2));N%.3f::$7='(and $2 $4 (/ $2 $4));N%.3f

When there is nothing to display, there is now a '0' displayed, but I
would prefer it to be empty. Is this possible?
Also, why is prijs/km displayed as '-0.000'?
And why is the last field of km's displayed as  '-156146'? I expected
'0'.

-- 
Cecil Westerhof <CecilWesterhof@xs4all.nl>