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

Previous Next

To add a comment to this bug, you must first unarchive it, by sending
a message to control AT debbugs.gnu.org, with unarchive 23890 in the body.
You can then email your comments to 23890 AT debbugs.gnu.org in the normal way.

Toggle the display of automated, internal messages from the tracker.

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

From: Rares Vernica <rvernica <at> gmail.com>
To: bug-gnu-emacs <at> gnu.org
Subject: 25.0.94; Org-mode Table does not copy time interval correctly
Date: Sun, 3 Jul 2016 22:30:08 -0700

[Message part 1 (text/plain, inline)]

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))

[Message part 2 (text/html, inline)]

[org-copy-bug.dribble (application/octet-stream, attachment)]

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

From: Eli Zaretskii <eliz <at> gnu.org>
To: Rares Vernica <rvernica <at> gmail.com>
Cc: 23890 <at> debbugs.gnu.org
Subject: Re: bug#23890: 25.0.94;
 Org-mode Table does not copy time interval correctly
Date: Mon, 04 Jul 2016 17:49:20 +0300

> From: Rares Vernica <rvernica <at> gmail.com>
> 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.

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

From: Glenn Morris <rgm <at> gnu.org>
To: Eli Zaretskii <eliz <at> gnu.org>
Cc: 23890 <at> debbugs.gnu.org, Rares Vernica <rvernica <at> gmail.com>
Subject: Re: bug#23890: 25.0.94;
 Org-mode Table does not copy time interval correctly
Date: Mon, 04 Jul 2016 12:30:48 -0400

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?)

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

From: Eli Zaretskii <eliz <at> gnu.org>
To: Glenn Morris <rgm <at> gnu.org>
Cc: 23890 <at> debbugs.gnu.org, rvernica <at> gmail.com
Subject: Re: bug#23890: 25.0.94;
 Org-mode Table does not copy time interval correctly
Date: Mon, 04 Jul 2016 19:32:17 +0300

> From: Glenn Morris <rgm <at> gnu.org>
> Cc: Rares Vernica <rvernica <at> gmail.com>,  23890 <at> 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.

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

From: Nicolas Goaziou <mail <at> nicolasgoaziou.fr>
To: 23890 <at> debbugs.gnu.org
Cc: rvernica <at> gmail.com
Subject: Re: bug#23890: 25.0.94;
 Org-mode Table does not copy time interval correctly
Date: Tue, 05 Jul 2016 23:58:31 +0200

Hello,

Eli Zaretskii <eliz <at> gnu.org> writes:

>> From: Glenn Morris <rgm <at> gnu.org>
>> Cc: Rares Vernica <rvernica <at> gmail.com>,  23890 <at> 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

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

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

From: Nicolas Goaziou <mail <at> nicolasgoaziou.fr>
To: Rares Vernica <rvernica <at> gmail.com>
Cc: 23890 <at> debbugs.gnu.org
Subject: Re: bug#23890: 25.0.94;
 Org-mode Table does not copy time interval correctly
Date: Wed, 06 Jul 2016 22:34:38 +0200

Hello,

Rares Vernica <rvernica <at> gmail.com> 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

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

From: Nicolas Goaziou <mail <at> nicolasgoaziou.fr>
To: Rares Vernica <rvernica <at> gmail.com>
Cc: 23890 <at> debbugs.gnu.org
Subject: Re: bug#23890: 25.0.94;
 Org-mode Table does not copy time interval correctly
Date: Fri, 01 Dec 2017 19:57:29 +0100

Nicolas Goaziou <mail <at> nicolasgoaziou.fr> writes:

> Hello,
>
> Rares Vernica <rvernica <at> gmail.com> 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,

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

From: Nicolas Goaziou <mail <at> nicolasgoaziou.fr>
To: Rares Vernica <rvernica <at> gmail.com>
Cc: 23890-done <at> debbugs.gnu.org
Subject: Re: bug#23890: 25.0.94;
 Org-mode Table does not copy time interval correctly
Date: Fri, 01 Dec 2017 21:59:50 +0100

Nicolas Goaziou <mail <at> nicolasgoaziou.fr> writes:

> Nicolas Goaziou <mail <at> nicolasgoaziou.fr> writes:
>
>> Hello,
>>
>> Rares Vernica <rvernica <at> gmail.com> 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.

Previous Next

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