Re: how to clear computed values

[Cecil Westerhof <CecilWesterhof@xs4all.nl>]

Op wo, 11-07-2007 te 12:19 +0200, schreef Carsten Dominik:
> > That works. I hoped that it was possible to see you are on the first
> > line after a hline, but this is good enough.
> 
> Of course this is possible, you are using Lisp:
> 
> (defun check-if-after-hline ()
> 	(save-excursion
>        (beginning-of-line 0)
>        (looking-at org-table-hline-regexp)))

Okay, now it is:
        |---+------------+---------+-------------------+---------+--------+-------+----------+--------|
        |   |      datum | kmstand | km's              | prijs/l | liters | prijs | prijs/km |   km/l |
        |---+------------+---------+-------------------+---------+--------+-------+----------+--------|
        | # |            |  155111 |                   |         |        |       |          |        |
        | # | 2007-07-09 |  156146 | 1035              |   102.2 |  62.25 | 63.62 |    6.147 | 16.627 |
        | # | 2007-07-11 |    6953 | Verkeerde kmstand |         |        |       |          |        |
        | # |            |         |                   |         |        |       |          |        |
        |---+------------+---------+-------------------+---------+--------+-------+----------+--------|
        #+TBLFM: $4='(if (and (nz @-1$3) (nz $3)) (if (> $3 @-1$3) (- $3 @-1$3) (if (not (check-if-after-hline)) "Verkeerde kmstand" "")) "");N::$7='(if (and (nz $5) (nz $6)) (format "%.2f" (/ (* $5 $6) 100)) "");N::$8='(if (and (nz $4) (nz $7)) (format "%.3f" (/ (* $7 100) $4)) "");N::$9='(if (and (nz $4) (nz $6)) (format "%.3f" (/ $4 $6)) "");N
This looks perfect.

Just one more question. ;-}
I would like to display the days between rows. I found time-date.el, but
this only works with:
        The five data representations used are the following:
        
        date
                An RFC822 (or similar) date string. For instance: "Sat
                Sep 12 12:21:54 1998 +0200". 
                
        time
                An internal Emacs time. For instance: (13818 26466). 
                
        seconds
                A floating point representation of the internal Emacs
                time. For instance: 905595714.0. 
                
        days
                An integer number representing the number of days since
                00000101. For instance: 729644. 
                
        decoded time
                A list of decoded time. For instance: (54 21 12 12 9
                1998 6 t 7200).

Is there a way to work with dates like 2007-09-11?

-- 
Cecil Westerhof <CecilWesterhof@xs4all.nl>