[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [O] Bug: Table formula does not copy time interval correctly [8.2.10
From: |
Rares Vernica |
Subject: |
Re: [O] Bug: Table formula does not copy time interval correctly [8.2.10 (release_8.2.10 @ /usr/share/emacs/25.0.94/lisp/org/)] |
Date: |
Thu, 07 Jul 2016 21:06:58 -0700 |
User-agent: |
Gnus/5.13 (Gnus v5.13) Emacs/25.0.94 (gnu/linux) |
Michael Brand <address@hidden> writes:
> Hi Rares
>
> On Mon, Jul 4, 2016 at 6:28 PM, Rares Vernica <address@hidden> wrote:
>
>> | [2016-07-03 Sun]--[2016-07-04 Mon] | 1d | d |
>> | [2016-07-03 Sun]--[2016-07-05 Tue] | 2d | 2 d |
>> #+TBLFM: $3=$2
>
> A Calc formula interprets field values as a symbolic expressions to
> calculate with. To copy literally one needs a Lisp formula:
>
> | [2016-07-03 Sun]--[2016-07-04 Mon] | 1d | 1d |
> | [2016-07-03 Sun]--[2016-07-05 Tue] | 2d | 2d |
>
> #+TBLFM: $3 = '(identity $2)
That did the trick, thanks!
Just to clarify, how would you fix this:
| [2016-07-05 Tue]--[2016-07-06 Wed] | 1d | vsum(d) |
| [2016-07-06 Wed]--[2016-07-07 Thu] | 1d | 2 d |
#+TBLFM: $3=vsum(@address@hidden)
Notice the "vsum(d)" instead of the expected "1 d". How would you add
"identity" here?
Thanks!
Rares