emacs-orgmode
[Top][All Lists]
Advanced

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

[O] Table formula not returning an error


From: Sebastien Vauban
Subject: [O] Table formula not returning an error
Date: Thu, 06 Oct 2011 16:21:13 +0200
User-agent: Gnus/5.110018 (No Gnus v0.18) Emacs/24.0.50 (windows-nt)

Hello,

I was surprised by how 10 minutes was converted to 0.02 hour in a table:

| Tâche      | HH:MM | Frac |
|------------+-------+------|
| Avril 2011 | 0:1O  | 0.02 |
|------------+-------+------|
|            |       | 0.02 |
#+TBLFM: $3='(/ (float (org-hh:mm-string-to-minutes $2)) 
60.);%.2f::@3$3=vsum(@address@hidden)

I took me less than 2 minutes to discover the problem -- wanna play the
"1 diff game" (in the table itself, not in the formula)? -- and fix it:

| Tâche      | HH:MM | Frac |
|------------+-------+------|
| Avril 2011 |  0:10 | 0.17 |
|------------+-------+------|
|            |       | 0.17 |
#+TBLFM: $3='(/ (float (org-hh:mm-string-to-minutes $2)) 
60.);%.2f::@3$3=vsum(@address@hidden)

But I'm surprised I did not see any error reported.

Best regards,
  Seb

-- 
Sebastien Vauban




reply via email to

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