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.
You may create an intermediate table to evaluate expressions heavily
relied on cell ranges and feed this table to another source block as a
variable.
By the way, a range may be specified when passing a table as a source
block variable, but it uses another syntax, see
(info "(org)Environment of a Code Block")
https://orgmode.org/manual/Environment-of-a-Code-Block.html
So it is possible to mix table formulas and source code blocks.