From unknown Tue Jun 17 20:21:38 2025 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-Mailer: MIME-tools 5.509 (Entity 5.509) Content-Type: text/plain; charset=utf-8 From: bug#23890 <23890@debbugs.gnu.org> To: bug#23890 <23890@debbugs.gnu.org> Subject: Status: 25.0.94; Org-mode Table does not copy time interval correctly Reply-To: bug#23890 <23890@debbugs.gnu.org> Date: Wed, 18 Jun 2025 03:21:38 +0000 retitle 23890 25.0.94; Org-mode Table does not copy time interval correctly reassign 23890 org-mode submitter 23890 Rares Vernica severity 23890 normal thanks From debbugs-submit-bounces@debbugs.gnu.org Mon Jul 04 01:30:27 2016 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: Subject: 25.0.94; Org-mode Table does not copy time interval correctly To: bug-gnu-emacs@gnu.org 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-Debbugs-Envelope-To: submit 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 debbugs-submit-bounces@debbugs.gnu.org Mon Jul 04 10:49:51 2016 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 To: Rares Vernica In-reply-to: (message from Rares Vernica on Sun, 3 Jul 2016 22:30:08 -0700) Subject: Re: bug#23890: 25.0.94; Org-mode Table does not copy time interval correctly 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-Debbugs-Envelope-To: 23890 Cc: 23890@debbugs.gnu.org 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: , Reply-To: Eli Zaretskii 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 debbugs-submit-bounces@debbugs.gnu.org Mon Jul 04 12:30:59 2016 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 To: Eli Zaretskii Subject: Re: bug#23890: 25.0.94; Org-mode Table does not copy time interval correctly 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-Debbugs-No-Ack: yes 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-Debbugs-Envelope-To: 23890 Cc: 23890@debbugs.gnu.org, Rares Vernica 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 debbugs-submit-bounces@debbugs.gnu.org Mon Jul 04 12:32:49 2016 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 To: Glenn Morris In-reply-to: (message from Glenn Morris on Mon, 04 Jul 2016 12:30:48 -0400) Subject: Re: bug#23890: 25.0.94; Org-mode Table does not copy time interval correctly 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-Debbugs-Envelope-To: 23890 Cc: 23890@debbugs.gnu.org, rvernica@gmail.com 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: , Reply-To: Eli Zaretskii 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 debbugs-submit-bounces@debbugs.gnu.org Tue Jul 05 17:58:41 2016 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 To: 23890@debbugs.gnu.org Subject: Re: bug#23890: 25.0.94; Org-mode Table does not copy time interval correctly 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-Debbugs-Envelope-To: 23890 Cc: rvernica@gmail.com 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 debbugs-submit-bounces@debbugs.gnu.org Wed Jul 06 00:47:19 2016 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 To: Nicolas Goaziou Subject: Re: bug#23890: 25.0.94; Org-mode Table does not copy time interval correctly 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-Debbugs-Envelope-To: 23890 Cc: 23890@debbugs.gnu.org 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 debbugs-submit-bounces@debbugs.gnu.org Wed Jul 06 16:34:48 2016 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 To: Rares Vernica Subject: Re: bug#23890: 25.0.94; Org-mode Table does not copy time interval correctly 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-Debbugs-Envelope-To: 23890 Cc: 23890@debbugs.gnu.org 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 debbugs-submit-bounces@debbugs.gnu.org Fri Dec 01 13:57:34 2017 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 To: Rares Vernica Subject: Re: bug#23890: 25.0.94; Org-mode Table does not copy time interval correctly 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-Debbugs-Envelope-To: 23890 Cc: 23890@debbugs.gnu.org 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 debbugs-submit-bounces@debbugs.gnu.org Fri Dec 01 15:59:55 2017 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 To: Rares Vernica Subject: Re: bug#23890: 25.0.94; Org-mode Table does not copy time interval correctly 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-Debbugs-Envelope-To: 23890-done Cc: 23890-done@debbugs.gnu.org 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. From unknown Tue Jun 17 20:21:38 2025 Received: (at fakecontrol) by fakecontrolmessage; To: internal_control@debbugs.gnu.org From: Debbugs Internal Request Subject: Internal Control Message-Id: bug archived. Date: Sat, 30 Dec 2017 12:24:08 +0000 User-Agent: Fakemail v42.6.9 # This is a fake control message. # # The action: # bug archived. thanks # This fakemail brought to you by your local debbugs # administrator