emacs-orgmode
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Orgmode] Problem with lisp code in spreadsheet


From: Carsten Dominik
Subject: Re: [Orgmode] Problem with lisp code in spreadsheet
Date: Sun, 17 Jun 2007 00:14:29 +0200


On Jun 16, 2007, at 19:50, Cecil Westerhof wrote:

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?

Since I don't know exactly what getHours does, I cannot be sure.
The most likely reason though is that $3 and $2 are interpolated into
Lisp expressions as strings, not as numbers.

See the discussion of the N mode flag in

http://staff.science.uva.nl/~dominik/Tools/org/org.html#Formula-syntax- for-Lisp

- Carsten





reply via email to

[Prev in Thread] Current Thread [Next in Thread]