From mboxrd@z Thu Jan  1 00:00:00 1970
From: Cecil Westerhof <CecilWesterhof@xs4all.nl>
Subject: Problem with lisp code in spreadsheet
Date: Sat, 16 Jun 2007 19:50:07 +0200
Message-ID: <1182016207.6246.127.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 1HzcPc-0004tY-Hv
	for emacs-orgmode@gnu.org; Sat, 16 Jun 2007 13:50:12 -0400
Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43)
	id 1HzcPa-0004rU-2r
	for emacs-orgmode@gnu.org; Sat, 16 Jun 2007 13:50:11 -0400
Received: from [199.232.76.173] (helo=monty-python.gnu.org)
	by lists.gnu.org with esmtp (Exim 4.43) id 1HzcPZ-0004rQ-Tp
	for emacs-orgmode@gnu.org; Sat, 16 Jun 2007 13:50:09 -0400
Received: from smtp-vbr10.xs4all.nl ([194.109.24.30])
	by monty-python.gnu.org with esmtp (Exim 4.60)
	(envelope-from <CecilWesterhof@xs4all.nl>) id 1HzcPZ-0005HT-7m
	for emacs-orgmode@gnu.org; Sat, 16 Jun 2007 13:50:09 -0400
Received: from Barebusta.DecebalComp (DecebalComputing.xs4all.nl
	[213.84.157.201])
	by smtp-vbr10.xs4all.nl (8.13.8/8.13.8) with ESMTP id l5GHo8dW013764
	for <emacs-orgmode@gnu.org>; Sat, 16 Jun 2007 19:50:08 +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>

In a row I have the following formula's:
  =$3
  ='(getHours $2);%.2f
  ='(/ 67 0.72);%.1f
  ='(/ $3 (getHours $2));%.1f
This gives:
  67
  0.72
  93.1
  0.0

I would expect the last two to return the same number. Why is this not
the case?

When I change the last formula to:
  ='(/ 67 (getHours $2));%.1f
I get:
  93.5

What is happening here?

-- 
Cecil Westerhof <CecilWesterhof@xs4all.nl>