[Top][All Lists]
[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