Michael Brand <michael.ch.br...@gmail.com> writes: > Hi Rares > > On Mon, Jul 4, 2016 at 6:28 PM, Rares Vernica <rvern...@gmail.com> 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(@1$-1..@0$-1) Notice the "vsum(d)" instead of the expected "1 d". How would you add "identity" here? Thanks! Rares
