Nicolas Goaziou <m...@nicolasgoaziou.fr> writes: > It isn't a bug actually. > > Spreadsheet formulas are sent to Calc (unless it starts with "'(" in > which case it is treated as Elisp). Doing symbolic computations, Calc > parses "1d" as one time the symbolic variable "d". So "1d" is the same > as "d". > > Basically, the OP could use instead: > > #+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