On 12/12/2022 10:23, William Denton wrote:
On 10 December 2022, Max Nikulin wrote:
@I$A and the "remote" function are available in table formulas only.
...
I'll be back with more questions eventually,
Using source blocks you may define new functions that you may call from
table formulas.
On 10 December 2022, Max Nikulin wrote:
@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.
Thanks for
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"
I ran org-lookup-all in a source block, but it didn't give any output. I think
I don't know something basic about Org or Lisp (likely both) and I hope someone
can point out what's going on.
For example, I have this table, and I can count how many times x appears:
#+name: test_table
| | A |