From mboxrd@z Thu Jan  1 00:00:00 1970
From: Rares Vernica <rvernica@gmail.com>
Subject: bug#23890: 25.0.94; Org-mode Table does not copy time interval
 correctly
Date: Tue, 05 Jul 2016 21:44:56 -0700
Message-ID: <87zipvbcjb.fsf@gmail.com>
References: <CALQ9KxAX7+2+mBuF_v+iyutmOLsCzEGBVhM+Z=zJVqB9UVJMxw@mail.gmail.com>
	<83inwlpifj.fsf@gnu.org> <devb0lqsav.fsf@fencepost.gnu.org>
	<8360slpdny.fsf@gnu.org> <87shvnhhmg.fsf@saiph.selenimh>
Mime-Version: 1.0
Content-Type: text/plain
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([2001:4830:134:3::10]:44956)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <Debian-debbugs@debbugs.gnu.org>) id 1bKekr-0001MW-MR
	for emacs-orgmode@gnu.org; Wed, 06 Jul 2016 00:48:10 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <Debian-debbugs@debbugs.gnu.org>) id 1bKekk-0004Iz-Pa
	for emacs-orgmode@gnu.org; Wed, 06 Jul 2016 00:48:08 -0400
Received: from debbugs.gnu.org ([208.118.235.43]:54686)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <Debian-debbugs@debbugs.gnu.org>) id 1bKekk-0004Iu-MG
	for emacs-orgmode@gnu.org; Wed, 06 Jul 2016 00:48:02 -0400
Received: from Debian-debbugs by debbugs.gnu.org with local (Exim 4.84_2)
	(envelope-from <Debian-debbugs@debbugs.gnu.org>) id 1bKekk-00024j-By
	for emacs-orgmode@gnu.org; Wed, 06 Jul 2016 00:48:02 -0400
Sender: "Debbugs-submit" <debbugs-submit-bounces@debbugs.gnu.org>
Resent-Message-ID: <handler.23890.B23890.14677804397925@debbugs.gnu.org>
In-Reply-To: <87shvnhhmg.fsf@saiph.selenimh> (Nicolas Goaziou's message of
	"Tue, 05 Jul 2016 23:58:31 +0200")
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <https://lists.gnu.org/mailman/options/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/archive/html/emacs-orgmode/>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <https://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=subscribe>
Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
Sender: "Emacs-orgmode"
	<emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
To: Nicolas Goaziou <mail@nicolasgoaziou.fr>
Cc: 23890@debbugs.gnu.org

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