Hi, Quick question: I'd like to use a babel inline call to calculate something in a table based on other values in the table. Is this possible? Probably using elisp directly? If so, I cannot figure out what the magic incantation should be! I hope somebody can help. For illustration, I'd like to do something like this: --8<---------------cut here---------------start------------->8--- #+source: f #+begin_src octave :var x=[1 3 5] sin(x) #+end_src | x1 | x2 | x3 | f | |----+----+----+--------------------------| | 1 | 3 | 5 | Apply call_f($1..$3) here | --8<---------------cut here---------------end--------------->8--- Thanks, eric -- : Eric S Fraga (GnuPG: 0xC89193D8FFFCF67D) in Emacs 24.0.50.1 : using Org-mode version 7.6 (release_7.6.4.gf305a)
Hi Eric, The `sbe' macro can be used to evaluate code blocks in table formula. For Example: | 1 | | 2 | | 3 | | 4 | | 5 | | 6 | | 3.5 | #+TBLFM: @7$1='(sbe mean (lst @1..@6)) #+source: mean #+begin_src emacs-lisp :var lst=() (let ((num (car lst)) (nums (cdr lst))) (/ (float (+ num (apply #'+ nums))) (1+ (length nums)))) #+end_src See the documentation string of this macro for more information. Best -- Eric Eric S Fraga <e.fraga@ucl.ac.uk> writes: > Hi, > > Quick question: I'd like to use a babel inline call to calculate > something in a table based on other values in the table. Is this > possible? Probably using elisp directly? If so, I cannot figure out > what the magic incantation should be! I hope somebody can help. > > For illustration, I'd like to do something like this: > > #+source: f > #+begin_src octave :var x=[1 3 5] > sin(x) > #+end_src > > | x1 | x2 | x3 | f | > |----+----+----+--------------------------| > | 1 | 3 | 5 | Apply call_f($1..$3) here | > > Thanks, > eric -- Eric Schulte http://cs.unm.edu/~eschulte/
Eric Schulte <schulte.eric@gmail.com> writes:
> Hi Eric,
>
> The `sbe' macro can be used to evaluate code blocks in table formula.
Argghhhh, yes, I now remember this coming up in the list a long time
ago. Thanks for reminding me.
I wasn't able to find it using typical keywords unfortunately. I also
wasn't able to find it in the info manual. I'll look around some more.
Thanks again,
eric
--
: Eric S Fraga (GnuPG: 0xC89193D8FFFCF67D) in Emacs 24.0.50.1
: using Org-mode version 7.6 (release_7.6.35.g30182)
Hi Eric,
Eric S Fraga wrote:
> Eric Schulte <schulte.eric-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> writes:
>> The `sbe' macro can be used to evaluate code blocks in table formula.
>
> Argghhhh, yes, I now remember this coming up in the list a long time
> ago. Thanks for reminding me.
>
> I wasn't able to find it using typical keywords unfortunately. I also
> wasn't able to find it in the info manual. I'll look around some more.
I confirm it's not easy to find. Did try for 5 mins without success.
Best regards,
Seb
--
Sebastien Vauban
Hi Sébastien,
"Sebastien Vauban" <wxhgmqzgwmuf@spammotel.com> writes:
> Eric S Fraga wrote:
>> Eric Schulte <schulte.eric@gmail.com> writes:
>>> The `sbe' macro can be used to evaluate code blocks in table formula.
>>
>> Argghhhh, yes, I now remember this coming up in the list a long time
>> ago. Thanks for reminding me.
>>
>> I wasn't able to find it using typical keywords unfortunately. I also
>> wasn't able to find it in the info manual. I'll look around some more.
>
> I confirm it's not easy to find. Did try for 5 mins without success.
Patch welcome!
--
Bastien
Bastien <bzg@altern.org> writes:
> Hi Sébastien,
>
> "Sebastien Vauban" <wxhgmqzgwmuf@spammotel.com> writes:
>
>> Eric S Fraga wrote:
>>> Eric Schulte <schulte.eric@gmail.com> writes:
>>>> The `sbe' macro can be used to evaluate code blocks in table formula.
>>>
>>> Argghhhh, yes, I now remember this coming up in the list a long time
>>> ago. Thanks for reminding me.
>>>
>>> I wasn't able to find it using typical keywords unfortunately. I also
>>> wasn't able to find it in the info manual. I'll look around some more.
>>
>> I confirm it's not easy to find. Did try for 5 mins without success.
>
> Patch welcome!
On my TODO list! ;-)
--
: Eric S Fraga (GnuPG: 0xC89193D8FFFCF67D) in Emacs 24.0.50.1
: using Org-mode version 7.6 (release_7.6.35.g30182)
Eric S Fraga <e.fraga@ucl.ac.uk> writes: > Bastien <bzg@altern.org> writes: > >> Hi Sébastien, >> >> "Sebastien Vauban" <wxhgmqzgwmuf@spammotel.com> writes: >> >>> Eric S Fraga wrote: >>>> Eric Schulte <schulte.eric@gmail.com> writes: >>>>> The `sbe' macro can be used to evaluate code blocks in table formula. >>>> >>>> Argghhhh, yes, I now remember this coming up in the list a long time >>>> ago. Thanks for reminding me. >>>> >>>> I wasn't able to find it using typical keywords unfortunately. I also >>>> wasn't able to find it in the info manual. I'll look around some more. >>> >>> I confirm it's not easy to find. Did try for 5 mins without success. >> >> Patch welcome! > > On my TODO list! ;-) Fantastic, this is sorely missing from the info manual, although I think the function documentation should be useful. Thanks -- Eric -- Eric Schulte http://cs.unm.edu/~eschulte/