Re: Org functions in source blocks

[Max Nikulin <manikulin@gmail.com>]

On 10/12/2022 03:41, William Denton wrote:
> 
> #+begin_src emacs-lisp :results raw
> (org-lookup-all "x" '(remote(test_table, @I$A..@II$A)) nil)
> #+end_src

There is nothing wrong with `org-lookup-all'. It just does not receive 
arguments you expect. Try

#+begin_src emacs-lisp :results raw
(list "x" '(remote(test_table, @I$A..@II$A)) nil)
#+end_src

#+RESULTS:
(x (remote (test_table (, @I$A..@II$A))) nil)

@I$A and the "remote" function are available in table formulas only. 
Moreover you quoted remote, so this s-expression is not evaluated. In 
addition, unlike in table formulas, in elisp function arguments are 
separated by space, not by comma.

Use :var to pass test_table to a source block

#+begin_src emacs-lisp :results raw :var data=test_table
data
#+end_src

#+RESULTS:
(( A) (! A) ( x) ( ) ( x) ( x) (# 3))

Unfortunately there are no convenient shortcuts for range selectors like 
"@I$A..@II$A" (at least ready to use). You should use some functions 
instead.