emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed
* bug#23890: 25.0.94; Org-mode Table does not copy time interval correctly
       [not found] ` <83inwlpifj.fsf@gnu.org>
@ 2016-07-04 16:30   ` Glenn Morris
  2016-07-04 16:32     ` Eli Zaretskii
  0 siblings, 1 reply; 7+ messages in thread
From: Glenn Morris @ 2016-07-04 16:30 UTC (permalink / raw)
  To: Eli Zaretskii; +Cc: 23890, Rares Vernica

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

^ permalink raw reply	[flat|nested] 7+ messages in thread

* bug#23890: 25.0.94; Org-mode Table does not copy time interval correctly
  2016-07-04 16:30   ` bug#23890: 25.0.94; Org-mode Table does not copy time interval correctly Glenn Morris
@ 2016-07-04 16:32     ` Eli Zaretskii
  2016-07-05 21:58       ` Nicolas Goaziou
  0 siblings, 1 reply; 7+ messages in thread
From: Eli Zaretskii @ 2016-07-04 16:32 UTC (permalink / raw)
  To: Glenn Morris; +Cc: 23890, rvernica

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

^ permalink raw reply	[flat|nested] 7+ messages in thread

* bug#23890: 25.0.94; Org-mode Table does not copy time interval correctly
  2016-07-04 16:32     ` Eli Zaretskii
@ 2016-07-05 21:58       ` Nicolas Goaziou
  2016-07-06  4:44         ` Rares Vernica
  0 siblings, 1 reply; 7+ messages in thread
From: Nicolas Goaziou @ 2016-07-05 21:58 UTC (permalink / raw)
  To: 23890; +Cc: rvernica

Hello,

Eli Zaretskii <eliz@gnu.org> writes:

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

^ permalink raw reply	[flat|nested] 7+ messages in thread

* bug#23890: 25.0.94; Org-mode Table does not copy time interval correctly
  2016-07-05 21:58       ` Nicolas Goaziou
@ 2016-07-06  4:44         ` Rares Vernica
  2016-07-06 20:34           ` Nicolas Goaziou
  0 siblings, 1 reply; 7+ messages in thread
From: Rares Vernica @ 2016-07-06  4:44 UTC (permalink / raw)
  To: Nicolas Goaziou; +Cc: 23890

Nicolas Goaziou <mail@nicolasgoaziou.fr> writes:

> It isn't a bug actually.
>
> Spreadsheet formulas are sent to Calc (unless it starts with "'(" in
> which case it is treated as Elisp). Doing symbolic computations, Calc
> parses "1d" as one time the symbolic variable "d". So "1d" is the same
> as "d".
>
> Basically, the OP could use instead:
>
> #+TBLFM: $3='(identity $2)

That did the trick, thanks!

Just to clarify, how would you fix this:

| [2016-07-05 Tue]--[2016-07-06 Wed] | 1d | vsum(d) |
| [2016-07-06 Wed]--[2016-07-07 Thu] | 1d | 2 d     |
#+TBLFM: $3=vsum(@1$-1..@0$-1)

Notice the "vsum(d)" instead of the expected "1 d". How would you add
"identity" here?

Thanks!
Rares

^ permalink raw reply	[flat|nested] 7+ messages in thread

* bug#23890: 25.0.94; Org-mode Table does not copy time interval correctly
  2016-07-06  4:44         ` Rares Vernica
@ 2016-07-06 20:34           ` Nicolas Goaziou
  2017-12-01 18:57             ` Nicolas Goaziou
  0 siblings, 1 reply; 7+ messages in thread
From: Nicolas Goaziou @ 2016-07-06 20:34 UTC (permalink / raw)
  To: Rares Vernica; +Cc: 23890

Hello,

Rares Vernica <rvernica@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

^ permalink raw reply	[flat|nested] 7+ messages in thread

* bug#23890: 25.0.94; Org-mode Table does not copy time interval correctly
  2016-07-06 20:34           ` Nicolas Goaziou
@ 2017-12-01 18:57             ` Nicolas Goaziou
  2017-12-01 20:59               ` Nicolas Goaziou
  0 siblings, 1 reply; 7+ messages in thread
From: Nicolas Goaziou @ 2017-12-01 18:57 UTC (permalink / raw)
  To: Rares Vernica; +Cc: 23890

Nicolas Goaziou <mail@nicolasgoaziou.fr> writes:

> Hello,
>
> Rares Vernica <rvernica@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,

^ permalink raw reply	[flat|nested] 7+ messages in thread

* bug#23890: 25.0.94; Org-mode Table does not copy time interval correctly
  2017-12-01 18:57             ` Nicolas Goaziou
@ 2017-12-01 20:59               ` Nicolas Goaziou
  0 siblings, 0 replies; 7+ messages in thread
From: Nicolas Goaziou @ 2017-12-01 20:59 UTC (permalink / raw)
  To: Rares Vernica; +Cc: 23890-done

Nicolas Goaziou <mail@nicolasgoaziou.fr> writes:

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

^ permalink raw reply	[flat|nested] 7+ messages in thread

end of thread, other threads:[~2017-12-01 21:00 UTC | newest]

Thread overview: 7+ messages (download: mbox.gz / follow: Atom feed)
-- links below jump to the message on this page --
     [not found] <CALQ9KxAX7+2+mBuF_v+iyutmOLsCzEGBVhM+Z=zJVqB9UVJMxw@mail.gmail.com>
     [not found] ` <83inwlpifj.fsf@gnu.org>
2016-07-04 16:30   ` bug#23890: 25.0.94; Org-mode Table does not copy time interval correctly Glenn Morris
2016-07-04 16:32     ` Eli Zaretskii
2016-07-05 21:58       ` Nicolas Goaziou
2016-07-06  4:44         ` Rares Vernica
2016-07-06 20:34           ` Nicolas Goaziou
2017-12-01 18:57             ` Nicolas Goaziou
2017-12-01 20:59               ` Nicolas Goaziou

Code repositories for project(s) associated with this public inbox

	https://git.savannah.gnu.org/cgit/emacs/org-mode.git

This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).