GNU bug report logs - #23890
25.0.94; Org-mode Table does not copy time interval correctly

Previous Next

Full log

Message #24 received at 23890 <at> debbugs.gnu.org (full text, mbox):

From: Rares Vernica <rvernica <at> gmail.com>
To: Nicolas Goaziou <mail <at> nicolasgoaziou.fr>
Cc: 23890 <at> debbugs.gnu.org
Subject: Re: bug#23890: 25.0.94;
 Org-mode Table does not copy time interval correctly
Date: Tue, 05 Jul 2016 21:44:56 -0700

Nicolas Goaziou <mail <at> 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

Previous Next

GNU bug tracking system
Copyright (C) 1999 Darren O. Benham, 1997,2003 nCipher Corporation Ltd, 1994-97 Ian Jackson.