[O] bug#23890: 25.0.94; Org-mode Table does not copy time interval correctly
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.
[O] bug#23890: 25.0.94; Org-mode Table does not copy time interval correctly
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,
[O] bug#23890: 25.0.94; Org-mode Table does not copy time interval correctly
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
[O] bug#23890: 25.0.94; Org-mode Table does not copy time interval correctly
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
[O] bug#23890: 25.0.94; Org-mode Table does not copy time interval correctly
Hello,
Eli Zaretskii writes:
>> From: Glenn Morris
>> Cc: Rares Vernica , 23...@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
[O] bug#23890: 25.0.94; Org-mode Table does not copy time interval correctly
> From: Glenn Morris > Cc: Rares Vernica , 23...@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.
[O] bug#23890: 25.0.94; Org-mode Table does not copy time interval correctly
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?)
