From unknown Tue Jun 17 01:40:16 2025 X-Loop: help-debbugs@gnu.org Subject: bug#23890: 25.0.94; Org-mode Table does not copy time interval correctly Resent-From: Rares Vernica Original-Sender: "Debbugs-submit" Resent-CC: bug-gnu-emacs@gnu.org Resent-Date: Mon, 04 Jul 2016 05:31:01 +0000 Resent-Message-ID: Resent-Sender: help-debbugs@gnu.org X-GNU-PR-Message: report 23890 X-GNU-PR-Package: emacs X-GNU-PR-Keywords: To: 23890@debbugs.gnu.org X-Debbugs-Original-To: bug-gnu-emacs@gnu.org Received: via spool by submit@debbugs.gnu.org id=B.14676102288400 (code B ref -1); Mon, 04 Jul 2016 05:31:01 +0000 Received: (at submit) by debbugs.gnu.org; 4 Jul 2016 05:30:28 +0000 Received: from localhost ([127.0.0.1]:36489 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bJwSh-0002BQ-EB for submit@debbugs.gnu.org; Mon, 04 Jul 2016 01:30:27 -0400 Received: from eggs.gnu.org ([208.118.235.92]:52040) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bJwSf-0002BC-ET for submit@debbugs.gnu.org; Mon, 04 Jul 2016 01:30:26 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1bJwSY-0007a0-3L for submit@debbugs.gnu.org; Mon, 04 Jul 2016 01:30:20 -0400 X-Spam-Checker-Version: SpamAssassin 3.3.2 (2011-06-06) on eggs.gnu.org X-Spam-Level: X-Spam-Status: No, score=0.8 required=5.0 tests=BAYES_50,FREEMAIL_FROM, HTML_MESSAGE,T_DKIM_INVALID autolearn=disabled version=3.3.2 Received: from lists.gnu.org ([2001:4830:134:3::11]:39155) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1bJwSX-0007Zu-W0 for submit@debbugs.gnu.org; Mon, 04 Jul 2016 01:30:18 -0400 Received: from eggs.gnu.org ([2001:4830:134:3::10]:43010) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1bJwSU-00034D-Sh for bug-gnu-emacs@gnu.org; Mon, 04 Jul 2016 01:30:16 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1bJwSR-0007Zg-II for bug-gnu-emacs@gnu.org; Mon, 04 Jul 2016 01:30:13 -0400 Received: from mail-qt0-x229.google.com ([2607:f8b0:400d:c0d::229]:34958) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1bJwSR-0007ZH-Bq for bug-gnu-emacs@gnu.org; Mon, 04 Jul 2016 01:30:11 -0400 Received: by mail-qt0-x229.google.com with SMTP id f89so83143925qtd.2 for ; Sun, 03 Jul 2016 22:30:09 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:from:date:message-id:subject:to; bh=BTXEEL9pb1el9TRC1+0DzwmpPxWXGwhzY1NxapvkqIU=; b=VdITSXNqoeShaNRqtEZVAUMQfKotcz2v86H4ZCLXlN03hj//1eh5JgZ1tTHs1vBKWQ kqZmCi/v9PXrk+NTG/dbY8WX2Bs3TaOYbB2lYE2eXv5/vZUtOBGHJJpfC9n9PhHMILq2 yLtzHhR6dOq7MXxqdXGfXwTQ6K/x7rVoceA/183sZ8H9IYHFTL4NYtkPDksGRkLkMf8M IGr56eJRCflVoLf+1rDa2xSf3Hbikdu/en0k76OE0S25+VQEoRyloqKn+mzXEXeeiLqS i9Kopi8Exvra1uF5ZGE6ttqlXX2mc1+7SrYNJjPINGeGrq8nbPFtOPhXZwLblYgqOx0G z/yQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=BTXEEL9pb1el9TRC1+0DzwmpPxWXGwhzY1NxapvkqIU=; b=Jmg/0tdA4Ihmk4EDBSBWFjw0nkJy7iPeLp8xHvA6loTazqjWiMQMsgJ7KfrR8AZNHL JDJu9QR0DiBXW98tYaGIMkYAkZSELrGDMIbrVYx7RM88/99PvYTgE3W8wyLGqQXq5yCX AdRJvZ78gahejXeA82Z32bDRJHAsSqsVsjgf8WtSxzTvew11U0nsNRbOycog+Bg7vW1a MbiK9ywICynBA4tTDoQQgTvpAY7CuRJU79ioclownDGDNXByp8aas2h7nRymEk0ZL1nf 6XJ4MZThAvM8dc9/yx8RiePu0TZ3wS04cnX8Nv4g+43eQmZ/6TjYBkj+2XIzzpLmutVi BsZQ== X-Gm-Message-State: ALyK8tJH0RiRJlca3NMCTxC/Z204AwiZp0GaaCgiBhyIDpw1HwHhJeabjN9GbXiAwzmwtTjcT7f7vGySg+nOPg== X-Received: by 10.200.44.78 with SMTP id e14mr15671690qta.77.1467610209174; Sun, 03 Jul 2016 22:30:09 -0700 (PDT) MIME-Version: 1.0 Received: by 10.200.44.54 with HTTP; Sun, 3 Jul 2016 22:30:08 -0700 (PDT) From: Rares Vernica Date: Sun, 3 Jul 2016 22:30:08 -0700 Message-ID: Content-Type: multipart/mixed; boundary=001a11415f502ff3a40536c8a1a5 X-detected-operating-system: by eggs.gnu.org: GNU/Linux 2.2.x-3.x [generic] X-detected-operating-system: by eggs.gnu.org: GNU/Linux 2.6.x X-Received-From: 2001:4830:134:3::11 X-Spam-Score: -4.0 (----) X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -4.0 (----) --001a11415f502ff3a40536c8a1a5 Content-Type: multipart/alternative; boundary=001a11415f502ff39f0536c8a1a3 --001a11415f502ff39f0536c8a1a3 Content-Type: text/plain; charset=UTF-8 In the following table: | [2016-07-03 Sun]--[2016-07-04 Mon] | 1d | d | | [2016-07-03 Sun]--[2016-07-05 Tue] | 2d | 2 d | #+TBLFM: $3=$2 The second column is computed by pressing C-u C-c C-y. This sequence calculates the time difference between the time-stamps in the previous column and inserts the difference in the current column. This is fine. Now, for the third column, I insert the formula listed at the bottom of the table. Once applied, the result of the formula for the fist row is just "d" instead of "1d". So, it seems that the value is not copied correctly. This seems to work fine if the time-stamp range is greater than one day. Also, for the second row, the value is copied correctly but there is an extra " " inserted between the number and the "d" letter. This might not be desirable. Appending "D" at the end of the formula, yields the same result: | [2016-07-03 Sun]--[2016-07-04 Mon] | 1d | d | | [2016-07-03 Sun]--[2016-07-05 Tue] | 2d | 2 d | #+TBLFM: $3=$2;D I also tried appending "T" at the end of the formula: | [2016-07-03 Sun]--[2016-07-04 Mon] | 1d | 00:00:01 | | [2016-07-03 Sun]--[2016-07-05 Tue] | 2d | 00:00:02 | #+TBLFM: $3=$2;T The numeric value is copied correctly but the days are now changed to seconds. I attached a dribble file which allows you to reproduce the first row in the first table. <#part type="application/octet-stream" filename="~/org-copy-bug.dribble" disposition=attachment> <#/part> In GNU Emacs 25.0.94.1 (x86_64-redhat-linux-gnu, GTK+ Version 3.20.4) of 2016-05-18 built on buildhw-10.phx2.fedoraproject.org Windowing system distributor 'Fedora Project', version 11.0.11803000 System Description: Fedora release 24 (Twenty Four) Configured using: 'configure --build=x86_64-redhat-linux-gnu --host=x86_64-redhat-linux-gnu --program-prefix= --disable-dependency-tracking --prefix=/usr --exec-prefix=/usr --bindir=/usr/bin --sbindir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --includedir=/usr/include --libdir=/usr/lib64 --libexecdir=/usr/libexec --localstatedir=/var --sharedstatedir=/var/lib --mandir=/usr/share/man --infodir=/usr/share/info --with-dbus --with-gif --with-jpeg --with-png --with-rsvg --with-tiff --with-xft --with-xpm --with-x-toolkit=gtk3 --with-gpm=no --with-xwidgets build_alias=x86_64-redhat-linux-gnu host_alias=x86_64-redhat-linux-gnu 'CFLAGS=-DMAIL_USE_LOCKF -O2 -g -pipe -Wall -Werror=format-security -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches -specs=/usr/lib/rpm/redhat/redhat-hardened-cc1 -m64 -mtune=generic' LDFLAGS=-Wl,-z,relro PKG_CONFIG_PATH=:/usr/lib64/pkgconfig:/usr/share/pkgconfig' Configured features: XPM JPEG TIFF GIF PNG RSVG IMAGEMAGICK SOUND DBUS GCONF GSETTINGS NOTIFY ACL LIBSELINUX GNUTLS LIBXML2 FREETYPE M17N_FLT LIBOTF XFT ZLIB TOOLKIT_SCROLL_BARS GTK3 X11 XWIDGETS Important settings: value of $LANG: en_US.utf8 value of $XMODIFIERS: @im=ibus locale-coding-system: utf-8-unix Major mode: Lisp Interaction Minor modes in effect: tooltip-mode: t global-eldoc-mode: t electric-indent-mode: t mouse-wheel-mode: t tool-bar-mode: t menu-bar-mode: t file-name-shadow-mode: t global-font-lock-mode: t font-lock-mode: t blink-cursor-mode: t auto-composition-mode: t auto-encryption-mode: t auto-compression-mode: t line-number-mode: t transient-mark-mode: t Recent messages: For information about GNU Emacs and the GNU system, type C-h C-a. Making completion list... Load-path shadows: None found. Features: (shadow sort mail-extr emacsbug message dired format-spec rfc822 mml mml-sec password-cache epg epg-config gnus-util mm-decode mm-bodies mm-encode mail-parse rfc2231 mailabbrev gmm-utils mailheader sendmail rfc2047 rfc2045 ietf-drums mm-util help-fns help-mode easymenu cl-loaddefs pcase cl-lib mail-prsvr mail-utils time-date mule-util tooltip eldoc electric uniquify ediff-hook vc-hooks lisp-float-type mwheel x-win term/common-win x-dnd tool-bar dnd fontset image regexp-opt fringe tabulated-list newcomment elisp-mode lisp-mode prog-mode register page menu-bar rfn-eshadow timer select scroll-bar mouse jit-lock font-lock syntax facemenu font-core frame cl-generic cham georgian utf-8-lang misc-lang vietnamese tibetan thai tai-viet lao korean japanese eucjp-ms cp51932 hebrew greek romanian slovak czech european ethiopic indian cyrillic chinese charscript case-table epa-hook jka-cmpr-hook help simple abbrev minibuffer cl-preloaded nadvice loaddefs button faces cus-face macroexp files text-properties overlay sha1 md5 base64 format env code-pages mule custom widget hashtable-print-readable backquote dbusbind inotify dynamic-setting system-font-setting font-render-setting xwidget-internal move-toolbar gtk x-toolkit x multi-tty make-network-process emacs) Memory information: ((conses 16 86524 7003) (symbols 48 19784 0) (miscs 40 39 146) (strings 32 14348 4717) (string-bytes 1 410110) (vectors 16 11716) (vector-slots 8 428442 4776) (floats 8 165 61) (intervals 56 264 0) (buffers 976 12) (heap 1024 26216 1084)) --001a11415f502ff39f0536c8a1a3 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable

In the following table:

| [2016-07-03 Sun]--[20= 16-07-04 Mon] | 1d | d=C2=A0=C2=A0 |
| [2016-07-03 Sun]--[2016-07-05 Tue= ] | 2d | 2 d |
#+TBLFM: $3=3D$2

The second column is computed by = pressing C-u C-c C-y. This sequence
calculates the time difference betwe= en the time-stamps in the previous
column and inserts the difference in = the current column. This is fine.

Now, for the third column, I inser= t the formula listed at the bottom of
the table. Once applied, the resul= t of the formula for the fist row is
just "d" instead of "= ;1d". So, it seems that the value is not copied
correctly.

T= his seems to work fine if the time-stamp range is greater than one
day. = Also, for the second row, the value is copied correctly but there
is an = extra " " inserted between the number and the "d" lette= r. This
might not be desirable.

Appending "D" at the en= d of the formula, yields the same result:

| [2016-07-03 Sun]--[2016-= 07-04 Mon] | 1d | d=C2=A0=C2=A0 |
| [2016-07-03 Sun]--[2016-07-05 Tue] |= 2d | 2 d |
#+TBLFM: $3=3D$2;D

I also tried appending "T&quo= t; at the end of the formula:

| [2016-07-03 Sun]--[2016-07-04 Mon] |= 1d | 00:00:01 |
| [2016-07-03 Sun]--[2016-07-05 Tue] | 2d | 00:00:02 |<= br>#+TBLFM: $3=3D$2;T

The numeric value is copied correctly but the = days are now changed to seconds.

I attached a dribble file which all= ows you to reproduce the first row in
the first table.

<#part = type=3D"application/octet-stream" filename=3D"~/org-copy-bug= .dribble" disposition=3Dattachment>
<#/part>


In GNU Emacs 25.0.94.1 (x86_64-redhat-linux-gnu, GTK+ Version 3.20.4)
= =C2=A0of 2016-05-18 built on buildhw-10.phx2.fedoraproject.org
Windowing system distributo= r 'Fedora Project', version 11.0.11803000
System Description:=C2= =A0=C2=A0=C2=A0 Fedora release 24 (Twenty Four)

Configured using:=C2=A0'configure --build=3Dx86_64-redhat-linux-gnu
=C2=A0--host=3Dx= 86_64-redhat-linux-gnu --program-prefix=3D
=C2=A0--disable-dependency-tr= acking --prefix=3D/usr --exec-prefix=3D/usr
=C2=A0--bindir=3D/usr/bin --= sbindir=3D/usr/sbin --sysconfdir=3D/etc
=C2=A0--datadir=3D/usr/share --i= ncludedir=3D/usr/include --libdir=3D/usr/lib64
=C2=A0--libexecdir=3D/usr= /libexec --localstatedir=3D/var
=C2=A0--sharedstatedir=3D/var/lib --mand= ir=3D/usr/share/man
=C2=A0--infodir=3D/usr/share/info --with-dbus --with= -gif --with-jpeg --with-png
=C2=A0--with-rsvg --with-tiff --with-xft --w= ith-xpm --with-x-toolkit=3Dgtk3
=C2=A0--with-gpm=3Dno --with-xwidgets bu= ild_alias=3Dx86_64-redhat-linux-gnu
=C2=A0host_alias=3Dx86_64-redhat-lin= ux-gnu 'CFLAGS=3D-DMAIL_USE_LOCKF -O2 -g
=C2=A0-pipe -Wall -Werror= =3Dformat-security -Wp,-D_FORTIFY_SOURCE=3D2
=C2=A0-fexceptions -fstack-= protector-strong --param=3Dssp-buffer-size=3D4
=C2=A0-grecord-gcc-switch= es -specs=3D/usr/lib/rpm/redhat/redhat-hardened-cc1
=C2=A0-m64 -mtune=3D= generic' LDFLAGS=3D-Wl,-z,relro
=C2=A0PKG_CONFIG_PATH=3D:/usr/lib64/= pkgconfig:/usr/share/pkgconfig'

Configured features:
XPM JPEG= TIFF GIF PNG RSVG IMAGEMAGICK SOUND DBUS GCONF GSETTINGS NOTIFY
ACL LIB= SELINUX GNUTLS LIBXML2 FREETYPE M17N_FLT LIBOTF XFT ZLIB
TOOLKIT_SCROLL_= BARS GTK3 X11 XWIDGETS

Important settings:
=C2=A0 value of $LANG:= en_US.utf8
=C2=A0 value of $XMODIFIERS: @im=3Dibus
=C2=A0 locale-cod= ing-system: utf-8-unix

Major mode: Lisp Interaction

Minor mod= es in effect:
=C2=A0 tooltip-mode: t
=C2=A0 global-eldoc-mode: t
= =C2=A0 electric-indent-mode: t
=C2=A0 mouse-wheel-mode: t
=C2=A0 tool= -bar-mode: t
=C2=A0 menu-bar-mode: t
=C2=A0 file-name-shadow-mode: t<= br>=C2=A0 global-font-lock-mode: t
=C2=A0 font-lock-mode: t
=C2=A0 bl= ink-cursor-mode: t
=C2=A0 auto-composition-mode: t
=C2=A0 auto-encryp= tion-mode: t
=C2=A0 auto-compression-mode: t
=C2=A0 line-number-mode:= t
=C2=A0 transient-mark-mode: t

Recent messages:
For informat= ion about GNU Emacs and the GNU system, type C-h C-a.
Making completion = list...

Load-path shadows:
None found.

Features:
(shado= w sort mail-extr emacsbug message dired format-spec rfc822 mml
mml-sec p= assword-cache epg epg-config gnus-util mm-decode mm-bodies
mm-encode mai= l-parse rfc2231 mailabbrev gmm-utils mailheader sendmail
rfc2047 rfc2045= ietf-drums mm-util help-fns help-mode easymenu
cl-loaddefs pcase cl-lib= mail-prsvr mail-utils time-date mule-util
tooltip eldoc electric uniqui= fy ediff-hook vc-hooks lisp-float-type
mwheel x-win term/common-win x-dn= d tool-bar dnd fontset image regexp-opt
fringe tabulated-list newcomment= elisp-mode lisp-mode prog-mode register
page menu-bar rfn-eshadow timer= select scroll-bar mouse jit-lock
font-lock syntax facemenu font-core fr= ame cl-generic cham georgian
utf-8-lang misc-lang vietnamese tibetan tha= i tai-viet lao korean
japanese eucjp-ms cp51932 hebrew greek romanian sl= ovak czech european
ethiopic indian cyrillic chinese charscript case-tab= le epa-hook
jka-cmpr-hook help simple abbrev minibuffer cl-preloaded nad= vice
loaddefs button faces cus-face macroexp files text-properties overl= ay
sha1 md5 base64 format env code-pages mule custom widget
hashtable= -print-readable backquote dbusbind inotify dynamic-setting
system-font-s= etting font-render-setting xwidget-internal move-toolbar
gtk x-toolkit x= multi-tty make-network-process emacs)

Memory information:
((cons= es 16 86524 7003)
=C2=A0(symbols 48 19784 0)
=C2=A0(miscs 40 39 146)<= br>=C2=A0(strings 32 14348 4717)
=C2=A0(string-bytes 1 410110)
=C2=A0= (vectors 16 11716)
=C2=A0(vector-slots 8 428442 4776)
=C2=A0(floats 8= 165 61)
=C2=A0(intervals 56 264 0)
=C2=A0(buffers 976 12)
=C2=A0(= heap 1024 26216 1084))

--001a11415f502ff39f0536c8a1a3-- --001a11415f502ff3a40536c8a1a5 Content-Type: application/octet-stream; name="org-copy-bug.dribble" Content-Disposition: attachment; filename="org-copy-bug.dribble" Content-Transfer-Encoding: base64 X-Attachment-Id: f_iq7l80v30 IDB4ODAwMDA3OG9yZy1tb2RlPHJldHVybj58IAMhPHJldHVybj4tLQMhWzIwMTYtMDctMDRdPHJl dHVybj4gfCAVAxk8cmlnaHQ+PHJpZ2h0PjxyaWdodD48cmlnaHQ+ID0kMjx0YWI+GAM= --001a11415f502ff3a40536c8a1a5-- From unknown Tue Jun 17 01:40:16 2025 X-Loop: help-debbugs@gnu.org Subject: bug#23890: 25.0.94; Org-mode Table does not copy time interval correctly Resent-From: Eli Zaretskii Original-Sender: "Debbugs-submit" Resent-CC: bug-gnu-emacs@gnu.org Resent-Date: Mon, 04 Jul 2016 14:50:01 +0000 Resent-Message-ID: Resent-Sender: help-debbugs@gnu.org X-GNU-PR-Message: followup 23890 X-GNU-PR-Package: emacs X-GNU-PR-Keywords: To: Rares Vernica Cc: 23890@debbugs.gnu.org Reply-To: Eli Zaretskii Received: via spool by 23890-submit@debbugs.gnu.org id=B23890.1467643791838 (code B ref 23890); Mon, 04 Jul 2016 14:50:01 +0000 Received: (at 23890) by debbugs.gnu.org; 4 Jul 2016 14:49:51 +0000 Received: from localhost ([127.0.0.1]:37220 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bK5C3-0000DR-LZ for submit@debbugs.gnu.org; Mon, 04 Jul 2016 10:49:51 -0400 Received: from eggs.gnu.org ([208.118.235.92]:39866) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bK5C1-0000DF-A8 for 23890@debbugs.gnu.org; Mon, 04 Jul 2016 10:49:49 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1bK5Bs-0004Zj-0U for 23890@debbugs.gnu.org; Mon, 04 Jul 2016 10:49:43 -0400 X-Spam-Checker-Version: SpamAssassin 3.3.2 (2011-06-06) on eggs.gnu.org X-Spam-Level: X-Spam-Status: No, score=-0.5 required=5.0 tests=BAYES_50,RP_MATCHES_RCVD autolearn=disabled version=3.3.2 Received: from fencepost.gnu.org ([2001:4830:134:3::e]:56404) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1bK5Br-0004Zf-TL; Mon, 04 Jul 2016 10:49:39 -0400 Received: from 84.94.185.246.cable.012.net.il ([84.94.185.246]:1838 helo=home-c4e4a596f7) by fencepost.gnu.org with esmtpsa (TLS1.2:RSA_AES_128_CBC_SHA1:128) (Exim 4.82) (envelope-from ) id 1bK5Br-0007i2-1h; Mon, 04 Jul 2016 10:49:39 -0400 Date: Mon, 04 Jul 2016 17:49:20 +0300 Message-Id: <83inwlpifj.fsf@gnu.org> From: Eli Zaretskii In-reply-to: (message from Rares Vernica on Sun, 3 Jul 2016 22:30:08 -0700) References: X-detected-operating-system: by eggs.gnu.org: GNU/Linux 2.2.x-3.x [generic] X-Received-From: 2001:4830:134:3::e X-Spam-Score: -6.3 (------) X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -6.3 (------) > From: Rares Vernica > Date: Sun, 3 Jul 2016 22:30:08 -0700 > > In the following table: > > | [2016-07-03 Sun]--[2016-07-04 Mon] | 1d | d | > | [2016-07-03 Sun]--[2016-07-05 Tue] | 2d | 2 d | > #+TBLFM: $3=$2 > > The second column is computed by pressing C-u C-c C-y. This sequence > calculates the time difference between the time-stamps in the previous > column and inserts the difference in the current column. This is fine. > > Now, for the third column, I insert the formula listed at the bottom of > the table. Once applied, the result of the formula for the fist row is > just "d" instead of "1d". So, it seems that the value is not copied > correctly. > > This seems to work fine if the time-stamp range is greater than one > day. Also, for the second row, the value is copied correctly but there > is an extra " " inserted between the number and the "d" letter. This > might not be desirable. > > Appending "D" at the end of the formula, yields the same result: > > | [2016-07-03 Sun]--[2016-07-04 Mon] | 1d | d | > | [2016-07-03 Sun]--[2016-07-05 Tue] | 2d | 2 d | > #+TBLFM: $3=$2;D > > I also tried appending "T" at the end of the formula: > > | [2016-07-03 Sun]--[2016-07-04 Mon] | 1d | 00:00:01 | > | [2016-07-03 Sun]--[2016-07-05 Tue] | 2d | 00:00:02 | > #+TBLFM: $3=$2;T > > The numeric value is copied correctly but the days are now changed to seconds. Thanks, but I think you should first report this to the Org developers. Come back here if they say this is a problem in core Emacs, not in Org code. From debbugs-submit-bounces@debbugs.gnu.org Mon Jul 04 12:20:45 2016 Received: (at control) by debbugs.gnu.org; 4 Jul 2016 16:20:45 +0000 Received: from localhost ([127.0.0.1]:37288 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bK6c1-0002Or-IQ for submit@debbugs.gnu.org; Mon, 04 Jul 2016 12:20:45 -0400 Received: from eggs.gnu.org ([208.118.235.92]:42402) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bK6c0-0002Oc-GY for control@debbugs.gnu.org; Mon, 04 Jul 2016 12:20:44 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1bK6bu-00052K-LJ for control@debbugs.gnu.org; Mon, 04 Jul 2016 12:20:39 -0400 X-Spam-Checker-Version: SpamAssassin 3.3.2 (2011-06-06) on eggs.gnu.org X-Spam-Level: X-Spam-Status: No, score=-3.2 required=5.0 tests=BAYES_00,RP_MATCHES_RCVD autolearn=disabled version=3.3.2 Received: from fencepost.gnu.org ([2001:4830:134:3::e]:57944) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1bK6bu-00052G-BA for control@debbugs.gnu.org; Mon, 04 Jul 2016 12:20:38 -0400 Received: from rgm by fencepost.gnu.org with local (Exim 4.82) (envelope-from ) id 1bK6bs-00024z-OF for control@debbugs.gnu.org; Mon, 04 Jul 2016 12:20:37 -0400 Subject: control message for bug 23890 To: X-Mailer: mail (GNU Mailutils 2.99.98) Message-Id: From: Glenn Morris Date: Mon, 04 Jul 2016 12:20:36 -0400 X-detected-operating-system: by eggs.gnu.org: GNU/Linux 2.2.x-3.x [generic] X-Received-From: 2001:4830:134:3::e X-Spam-Score: -6.3 (------) X-Debbugs-Envelope-To: control X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -6.3 (------) reassign 23890 org-mode From unknown Tue Jun 17 01:40:16 2025 X-Loop: help-debbugs@gnu.org Subject: bug#23890: 25.0.94; Org-mode Table does not copy time interval correctly Resent-From: Glenn Morris Original-Sender: "Debbugs-submit" Resent-CC: emacs-orgmode@gnu.org Resent-Date: Mon, 04 Jul 2016 16:31:01 +0000 Resent-Message-ID: Resent-Sender: help-debbugs@gnu.org X-GNU-PR-Message: followup 23890 X-GNU-PR-Package: org-mode X-GNU-PR-Keywords: To: Eli Zaretskii Cc: 23890@debbugs.gnu.org, Rares Vernica Received: via spool by 23890-submit@debbugs.gnu.org id=B23890.146764986016051 (code B ref 23890); Mon, 04 Jul 2016 16:31:01 +0000 Received: (at 23890) by debbugs.gnu.org; 4 Jul 2016 16:31:00 +0000 Received: from localhost ([127.0.0.1]:37303 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bK6lv-0004Ab-PD for submit@debbugs.gnu.org; Mon, 04 Jul 2016 12:30:59 -0400 Received: from eggs.gnu.org ([208.118.235.92]:44697) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bK6lu-00045L-Pd for 23890@debbugs.gnu.org; Mon, 04 Jul 2016 12:30:58 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1bK6lo-0007YE-Tw for 23890@debbugs.gnu.org; Mon, 04 Jul 2016 12:30:53 -0400 X-Spam-Checker-Version: SpamAssassin 3.3.2 (2011-06-06) on eggs.gnu.org X-Spam-Level: X-Spam-Status: No, score=-3.2 required=5.0 tests=BAYES_00,RP_MATCHES_RCVD autolearn=disabled version=3.3.2 Received: from fencepost.gnu.org ([2001:4830:134:3::e]:58062) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1bK6ln-0007Xm-AX; Mon, 04 Jul 2016 12:30:51 -0400 Received: from rgm by fencepost.gnu.org with local (Exim 4.82) (envelope-from ) id 1bK6ll-0006YH-1K; Mon, 04 Jul 2016 12:30:49 -0400 From: Glenn Morris References: <83inwlpifj.fsf@gnu.org> X-Spook: Irish Republican Army cracking Failure Federal Bureau of X-Ran: j{Vc|Ov,Z*yPU[>VU0dG+g^/Xc/1=7w.oW-&<;}IZQ3^K}cc!0j=koWX`%H!n;V}'aktFb X-Hue: white X-Attribution: GM Date: Mon, 04 Jul 2016 12:30:48 -0400 In-Reply-To: <83inwlpifj.fsf@gnu.org> (Eli Zaretskii's message of "Mon, 04 Jul 2016 17:49:20 +0300") Message-ID: User-Agent: Gnus (www.gnus.org), GNU Emacs (www.gnu.org/software/emacs/) MIME-Version: 1.0 Content-Type: text/plain X-detected-operating-system: by eggs.gnu.org: GNU/Linux 2.2.x-3.x [generic] X-Received-From: 2001:4830:134:3::e X-Spam-Score: -6.3 (------) X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -6.3 (------) Eli Zaretskii wrote: > Thanks, but I think you should first report this to the Org > developers. Come back here if they say this is a problem in core > Emacs, not in Org code. You can just reassign the bug to org-mode, as I did. (Isn't it weird to have a component of Emacs for which we effectively don't accept bug reports?) From unknown Tue Jun 17 01:40:16 2025 X-Loop: help-debbugs@gnu.org Subject: bug#23890: 25.0.94; Org-mode Table does not copy time interval correctly Resent-From: Eli Zaretskii Original-Sender: "Debbugs-submit" Resent-CC: emacs-orgmode@gnu.org Resent-Date: Mon, 04 Jul 2016 16:33:02 +0000 Resent-Message-ID: Resent-Sender: help-debbugs@gnu.org X-GNU-PR-Message: followup 23890 X-GNU-PR-Package: org-mode X-GNU-PR-Keywords: To: Glenn Morris Cc: 23890@debbugs.gnu.org, rvernica@gmail.com Reply-To: Eli Zaretskii Received: via spool by 23890-submit@debbugs.gnu.org id=B23890.146764996919168 (code B ref 23890); Mon, 04 Jul 2016 16:33:02 +0000 Received: (at 23890) by debbugs.gnu.org; 4 Jul 2016 16:32:49 +0000 Received: from localhost ([127.0.0.1]:37309 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bK6nh-0004z6-3p for submit@debbugs.gnu.org; Mon, 04 Jul 2016 12:32:49 -0400 Received: from eggs.gnu.org ([208.118.235.92]:45111) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bK6nf-0004ys-KU for 23890@debbugs.gnu.org; Mon, 04 Jul 2016 12:32:47 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1bK6nW-0007lS-K3 for 23890@debbugs.gnu.org; Mon, 04 Jul 2016 12:32:42 -0400 X-Spam-Checker-Version: SpamAssassin 3.3.2 (2011-06-06) on eggs.gnu.org X-Spam-Level: X-Spam-Status: No, score=-1.3 required=5.0 tests=BAYES_20,RP_MATCHES_RCVD autolearn=disabled version=3.3.2 Received: from fencepost.gnu.org ([2001:4830:134:3::e]:58095) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1bK6nW-0007lH-H7; Mon, 04 Jul 2016 12:32:38 -0400 Received: from 84.94.185.246.cable.012.net.il ([84.94.185.246]:2206 helo=home-c4e4a596f7) by fencepost.gnu.org with esmtpsa (TLS1.2:RSA_AES_128_CBC_SHA1:128) (Exim 4.82) (envelope-from ) id 1bK6nU-0008AV-QJ; Mon, 04 Jul 2016 12:32:37 -0400 Date: Mon, 04 Jul 2016 19:32:17 +0300 Message-Id: <8360slpdny.fsf@gnu.org> From: Eli Zaretskii In-reply-to: (message from Glenn Morris on Mon, 04 Jul 2016 12:30:48 -0400) References: <83inwlpifj.fsf@gnu.org> X-detected-operating-system: by eggs.gnu.org: GNU/Linux 2.2.x-3.x [generic] X-Received-From: 2001:4830:134:3::e X-Spam-Score: -6.3 (------) X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -6.3 (------) > From: Glenn Morris > Cc: Rares Vernica , 23890@debbugs.gnu.org > Date: Mon, 04 Jul 2016 12:30:48 -0400 > > (Isn't it weird to have a component of Emacs for which we effectively > don't accept bug reports?) It is. But as long as the Org maintainers are rare guests here, I see no other way. From unknown Tue Jun 17 01:40:16 2025 X-Loop: help-debbugs@gnu.org Subject: bug#23890: 25.0.94; Org-mode Table does not copy time interval correctly Resent-From: Nicolas Goaziou Original-Sender: "Debbugs-submit" Resent-CC: emacs-orgmode@gnu.org Resent-Date: Tue, 05 Jul 2016 21:59:02 +0000 Resent-Message-ID: Resent-Sender: help-debbugs@gnu.org X-GNU-PR-Message: followup 23890 X-GNU-PR-Package: org-mode X-GNU-PR-Keywords: To: 23890@debbugs.gnu.org Cc: rvernica@gmail.com Received: via spool by 23890-submit@debbugs.gnu.org id=B23890.14677559213771 (code B ref 23890); Tue, 05 Jul 2016 21:59:02 +0000 Received: (at 23890) by debbugs.gnu.org; 5 Jul 2016 21:58:41 +0000 Received: from localhost ([127.0.0.1]:38659 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bKYMb-0000yk-HI for submit@debbugs.gnu.org; Tue, 05 Jul 2016 17:58:41 -0400 Received: from relay4-d.mail.gandi.net ([217.70.183.196]:52943) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bKYMZ-0000yc-Cq for 23890@debbugs.gnu.org; Tue, 05 Jul 2016 17:58:40 -0400 Received: from saiph.selenimh (unknown [IPv6:2a03:a0a0:0:4301::b3c]) (Authenticated sender: mail@nicolasgoaziou.fr) by relay4-d.mail.gandi.net (Postfix) with ESMTPSA id 0372E17209D; Tue, 5 Jul 2016 23:58:36 +0200 (CEST) From: Nicolas Goaziou In-Reply-To: <8360slpdny.fsf@gnu.org> (Eli Zaretskii's message of "Mon, 04 Jul 2016 19:32:17 +0300") References: <83inwlpifj.fsf@gnu.org> <8360slpdny.fsf@gnu.org> Date: Tue, 05 Jul 2016 23:58:31 +0200 Message-ID: <87shvnhhmg.fsf@saiph.selenimh> MIME-Version: 1.0 Content-Type: text/plain X-Spam-Score: -0.7 (/) X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -0.7 (/) Hello, Eli Zaretskii writes: >> From: Glenn Morris >> Cc: Rares Vernica , 23890@debbugs.gnu.org >> Date: Mon, 04 Jul 2016 12:30:48 -0400 >> >> (Isn't it weird to have a component of Emacs for which we effectively >> don't accept bug reports?) > > It is. But as long as the Org maintainers are rare guests here, I see > no other way. 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) I guess we could add a "raw" mode string, e.g., ;R, but that's out of the scope of this bug report. Regards, -- Nicolas Goaziou From unknown Tue Jun 17 01:40:16 2025 X-Loop: help-debbugs@gnu.org Subject: bug#23890: 25.0.94; Org-mode Table does not copy time interval correctly Resent-From: Rares Vernica Original-Sender: "Debbugs-submit" Resent-CC: emacs-orgmode@gnu.org Resent-Date: Wed, 06 Jul 2016 04:48:02 +0000 Resent-Message-ID: Resent-Sender: help-debbugs@gnu.org X-GNU-PR-Message: followup 23890 X-GNU-PR-Package: org-mode X-GNU-PR-Keywords: To: Nicolas Goaziou Cc: 23890@debbugs.gnu.org Received: via spool by 23890-submit@debbugs.gnu.org id=B23890.14677804397925 (code B ref 23890); Wed, 06 Jul 2016 04:48:02 +0000 Received: (at 23890) by debbugs.gnu.org; 6 Jul 2016 04:47:19 +0000 Received: from localhost ([127.0.0.1]:38790 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bKek2-00023l-TA for submit@debbugs.gnu.org; Wed, 06 Jul 2016 00:47:19 -0400 Received: from mail-pf0-f177.google.com ([209.85.192.177]:35880) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bKek1-00023Z-Pb for 23890@debbugs.gnu.org; Wed, 06 Jul 2016 00:47:18 -0400 Received: by mail-pf0-f177.google.com with SMTP id t190so76400282pfb.3 for <23890@debbugs.gnu.org>; Tue, 05 Jul 2016 21:47:17 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=from:to:cc:subject:in-reply-to:references:user-agent:date :message-id:mime-version; bh=j0+EUJZpPKZuAOLMYTd9H/AaUqMQ+/Cqv+UvqNO0tY4=; b=epIzor2kSLS2pvEKCTibqeLvPMfuogmhpPqp9gf7GkXS6zw9E2piluren5ea7ZoKIJ sOz06o9QnjXbR29eoLpXTRIQjoG8WEsXBP26xiBwF9imoLMAjK6kYtse6tsKP4wZmlRN CwS/dYoR2XpbXQzGb16X33+jLMZQcxbmWXHQE4xN9hIlY6X4LIfcz4tys/CILYEiw+rZ PtW7R9q4De3AHdWk1dqs06H37welf8EMLu7YYpl9Kydj4i67ctRrjdPSmThFIILpIGWd Xt5vNiZ2+kq66senugA8Z0c774btQqDnqsp96gTer4iW2e+11bwVtDX04GKHsWxuQ+sS qHmw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:from:to:cc:subject:in-reply-to:references :user-agent:date:message-id:mime-version; bh=j0+EUJZpPKZuAOLMYTd9H/AaUqMQ+/Cqv+UvqNO0tY4=; b=beiCVowR9UED9sr1Clnx6WuhCjTG3KVX+RXmLslSGXVte1VQT2xEYZ2QeUTRYUrdUD 4KG7FQLG9l/MXeCLUPNWv56wd5uWLXodMyfQ/zS084zAZeNXLfxbQyRrQVTVVOeLzIpG 8xHYM8xIJpeRW1yHPwjC0p5bpxapa2O4yrLR2iDmRRVE0mkR9NWWjUGxg7tzYTUmcIDF AhwCxz7Ye8EV8/I0OsgPK7BZ9qUqwFk1IwSDyhTKISx5U1zPSYiveNmDlprWP/QJvIUY Jdt1WWJ+bl94/Sn4vuNzP5WCHmb+luy3FDGJ84DmtpHScCJYSssgMvoNcL5B3hJYgPGJ FeoA== X-Gm-Message-State: ALyK8tINSZRvALYtDwE3std+nouOSf26oipKlZP0smetPR03MfDfLcwn1BXeZG4N4JNFxg== X-Received: by 10.98.40.4 with SMTP id o4mr38320650pfo.165.1467780431682; Tue, 05 Jul 2016 21:47:11 -0700 (PDT) Received: from android (108-217-161-41.lightspeed.sntcca.sbcglobal.net. [108.217.161.41]) by smtp.gmail.com with ESMTPSA id i187sm721336pfc.62.2016.07.05.21.47.10 (version=TLS1_2 cipher=ECDHE-RSA-CHACHA20-POLY1305 bits=256/256); Tue, 05 Jul 2016 21:47:11 -0700 (PDT) From: Rares Vernica In-Reply-To: <87shvnhhmg.fsf@saiph.selenimh> (Nicolas Goaziou's message of "Tue, 05 Jul 2016 23:58:31 +0200") References: <83inwlpifj.fsf@gnu.org> <8360slpdny.fsf@gnu.org> <87shvnhhmg.fsf@saiph.selenimh> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/25.0.94 (gnu/linux) Date: Tue, 05 Jul 2016 21:44:56 -0700 Message-ID: <87zipvbcjb.fsf@gmail.com> MIME-Version: 1.0 Content-Type: text/plain X-Spam-Score: -0.7 (/) X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -0.7 (/) Nicolas Goaziou 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 From unknown Tue Jun 17 01:40:16 2025 X-Loop: help-debbugs@gnu.org Subject: bug#23890: 25.0.94; Org-mode Table does not copy time interval correctly Resent-From: Nicolas Goaziou Original-Sender: "Debbugs-submit" Resent-CC: emacs-orgmode@gnu.org Resent-Date: Wed, 06 Jul 2016 20:35:02 +0000 Resent-Message-ID: Resent-Sender: help-debbugs@gnu.org X-GNU-PR-Message: followup 23890 X-GNU-PR-Package: org-mode X-GNU-PR-Keywords: To: Rares Vernica Cc: 23890@debbugs.gnu.org Received: via spool by 23890-submit@debbugs.gnu.org id=B23890.146783728816576 (code B ref 23890); Wed, 06 Jul 2016 20:35:02 +0000 Received: (at 23890) by debbugs.gnu.org; 6 Jul 2016 20:34:48 +0000 Received: from localhost ([127.0.0.1]:39911 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bKtWy-0004JH-3P for submit@debbugs.gnu.org; Wed, 06 Jul 2016 16:34:48 -0400 Received: from relay4-d.mail.gandi.net ([217.70.183.196]:35005) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bKtWv-0004J9-To for 23890@debbugs.gnu.org; Wed, 06 Jul 2016 16:34:46 -0400 Received: from saiph.selenimh (unknown [IPv6:2a03:a0a0:0:4301::b3c]) (Authenticated sender: mail@nicolasgoaziou.fr) by relay4-d.mail.gandi.net (Postfix) with ESMTPSA id AAFF5172095; Wed, 6 Jul 2016 22:34:43 +0200 (CEST) From: Nicolas Goaziou In-Reply-To: <87zipvbcjb.fsf@gmail.com> (Rares Vernica's message of "Tue, 05 Jul 2016 21:44:56 -0700") References: <83inwlpifj.fsf@gnu.org> <8360slpdny.fsf@gnu.org> <87shvnhhmg.fsf@saiph.selenimh> <87zipvbcjb.fsf@gmail.com> Date: Wed, 06 Jul 2016 22:34:38 +0200 Message-ID: <87a8huh5ep.fsf@saiph.selenimh> MIME-Version: 1.0 Content-Type: text/plain X-Spam-Score: -0.7 (/) X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -0.7 (/) Hello, Rares Vernica writes: > 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? You probably need to use Lisp formulas instead of Calc, i.e, wrap the formula within '(...). I'm no specialist about table formulas; I suggest to ask on Org mailing list. Regards, -- Nicolas Goaziou From unknown Tue Jun 17 01:40:16 2025 X-Loop: help-debbugs@gnu.org Subject: bug#23890: 25.0.94; Org-mode Table does not copy time interval correctly Resent-From: Nicolas Goaziou Original-Sender: "Debbugs-submit" Resent-CC: emacs-orgmode@gnu.org Resent-Date: Fri, 01 Dec 2017 18:58:02 +0000 Resent-Message-ID: Resent-Sender: help-debbugs@gnu.org X-GNU-PR-Message: followup 23890 X-GNU-PR-Package: org-mode X-GNU-PR-Keywords: To: Rares Vernica Cc: 23890@debbugs.gnu.org Received: via spool by 23890-submit@debbugs.gnu.org id=B23890.151215465424619 (code B ref 23890); Fri, 01 Dec 2017 18:58:02 +0000 Received: (at 23890) by debbugs.gnu.org; 1 Dec 2017 18:57:34 +0000 Received: from localhost ([127.0.0.1]:40446 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eKqVC-0006P1-78 for submit@debbugs.gnu.org; Fri, 01 Dec 2017 13:57:34 -0500 Received: from relay4-d.mail.gandi.net ([217.70.183.196]:46167) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eKqVA-0006Or-3D for 23890@debbugs.gnu.org; Fri, 01 Dec 2017 13:57:32 -0500 Received: from saiph.selenimh (000043010000000000000469.ipv6.commingeshautdebit.fr [IPv6:2a03:a0a0:0:4301::469]) (Authenticated sender: mail@nicolasgoaziou.fr) by relay4-d.mail.gandi.net (Postfix) with ESMTPSA id 3E1BF17209B; Fri, 1 Dec 2017 19:57:30 +0100 (CET) Received: from ngz by saiph.selenimh with local (Exim 4.89) (envelope-from ) id 1eKqV7-0000Ld-GI; Fri, 01 Dec 2017 19:57:29 +0100 From: Nicolas Goaziou In-Reply-To: <87a8huh5ep.fsf@saiph.selenimh> (Nicolas Goaziou's message of "Wed, 06 Jul 2016 22:34:38 +0200") References: <83inwlpifj.fsf@gnu.org> <8360slpdny.fsf@gnu.org> <87shvnhhmg.fsf@saiph.selenimh> <87zipvbcjb.fsf@gmail.com> <87a8huh5ep.fsf@saiph.selenimh> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/25.3 (gnu/linux) Date: Fri, 01 Dec 2017 19:57:29 +0100 Message-ID: <87vahqff8m.fsf@nicolasgoaziou.fr> MIME-Version: 1.0 Content-Type: text/plain X-Spam-Score: -0.7 (/) X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -0.7 (/) Nicolas Goaziou writes: > Hello, > > Rares Vernica writes: > >> 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? > > You probably need to use Lisp formulas instead of Calc, i.e, wrap the > formula within '(...). > > I'm no specialist about table formulas; I suggest to ask on Org mailing > list. Could this bug be closed? Thank you. Regards, From debbugs-submit-bounces@debbugs.gnu.org Fri Dec 01 14:09:04 2017 Received: (at control) by debbugs.gnu.org; 1 Dec 2017 19:09:04 +0000 Received: from localhost ([127.0.0.1]:40481 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eKqgK-0000CY-Ax for submit@debbugs.gnu.org; Fri, 01 Dec 2017 14:09:04 -0500 Received: from eggs.gnu.org ([208.118.235.92]:45113) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eKqgH-0000C2-SW for control@debbugs.gnu.org; Fri, 01 Dec 2017 14:09:02 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1eKqgB-0005du-Ts for control@debbugs.gnu.org; Fri, 01 Dec 2017 14:08:56 -0500 X-Spam-Checker-Version: SpamAssassin 3.3.2 (2011-06-06) on eggs.gnu.org X-Spam-Level: X-Spam-Status: No, score=-1.9 required=5.0 tests=BAYES_00,T_RP_MATCHES_RCVD autolearn=disabled version=3.3.2 Received: from fencepost.gnu.org ([2001:4830:134:3::e]:33539) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1eKqgB-0005di-QE for control@debbugs.gnu.org; Fri, 01 Dec 2017 14:08:55 -0500 Received: from rgm by fencepost.gnu.org with local (Exim 4.82) (envelope-from ) id 1eKqgB-0006PO-KK for control@debbugs.gnu.org; Fri, 01 Dec 2017 14:08:55 -0500 Subject: control message for bug 23890 To: X-Mailer: mail (GNU Mailutils 2.99.98) Message-Id: From: Glenn Morris Date: Fri, 01 Dec 2017 14:08:55 -0500 X-detected-operating-system: by eggs.gnu.org: GNU/Linux 2.2.x-3.x [generic] X-Received-From: 2001:4830:134:3::e X-Spam-Score: -5.0 (-----) X-Debbugs-Envelope-To: control X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -5.0 (-----) close 23890 From unknown Tue Jun 17 01:40:16 2025 X-Loop: help-debbugs@gnu.org Subject: bug#23890: 25.0.94; Org-mode Table does not copy time interval correctly Resent-From: Nicolas Goaziou Original-Sender: "Debbugs-submit" Resent-CC: emacs-orgmode@gnu.org Resent-Date: Fri, 01 Dec 2017 21:00:02 +0000 Resent-Message-ID: Resent-Sender: help-debbugs@gnu.org X-GNU-PR-Message: followup 23890 X-GNU-PR-Package: org-mode X-GNU-PR-Keywords: To: Rares Vernica Cc: 23890-done@debbugs.gnu.org Received: via spool by 23890-done@debbugs.gnu.org id=D23890.151216199518261 (code D ref 23890); Fri, 01 Dec 2017 21:00:02 +0000 Received: (at 23890-done) by debbugs.gnu.org; 1 Dec 2017 20:59:55 +0000 Received: from localhost ([127.0.0.1]:40595 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eKsPa-0004kT-TK for submit@debbugs.gnu.org; Fri, 01 Dec 2017 15:59:55 -0500 Received: from relay3-d.mail.gandi.net ([217.70.183.195]:59882) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eKsPZ-0004kL-Tk for 23890-done@debbugs.gnu.org; Fri, 01 Dec 2017 15:59:54 -0500 Received: from saiph.selenimh (000043010000000000000469.ipv6.commingeshautdebit.fr [IPv6:2a03:a0a0:0:4301::469]) (Authenticated sender: mail@nicolasgoaziou.fr) by relay3-d.mail.gandi.net (Postfix) with ESMTPSA id C6B77A80C4; Fri, 1 Dec 2017 21:59:51 +0100 (CET) Received: from ngz by saiph.selenimh with local (Exim 4.89) (envelope-from ) id 1eKsPW-0000V2-LK; Fri, 01 Dec 2017 21:59:50 +0100 From: Nicolas Goaziou In-Reply-To: <87vahqff8m.fsf@nicolasgoaziou.fr> (Nicolas Goaziou's message of "Fri, 01 Dec 2017 19:57:29 +0100") References: <83inwlpifj.fsf@gnu.org> <8360slpdny.fsf@gnu.org> <87shvnhhmg.fsf@saiph.selenimh> <87zipvbcjb.fsf@gmail.com> <87a8huh5ep.fsf@saiph.selenimh> <87vahqff8m.fsf@nicolasgoaziou.fr> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/25.3 (gnu/linux) Date: Fri, 01 Dec 2017 21:59:50 +0100 Message-ID: <87y3mmdv09.fsf@nicolasgoaziou.fr> MIME-Version: 1.0 Content-Type: text/plain X-Spam-Score: -0.7 (/) X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -0.7 (/) Nicolas Goaziou writes: > Nicolas Goaziou writes: > >> Hello, >> >> Rares Vernica writes: >> >>> 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? >> >> You probably need to use Lisp formulas instead of Calc, i.e, wrap the >> formula within '(...). >> >> I'm no specialist about table formulas; I suggest to ask on Org mailing >> list. > > Could this bug be closed? Nevermind. Closing it.