[O] Concatenation of cells using 'remote'

[Loris Bennett]

Hi,

I can create a concatenation of the element in column like this:

#+NAME: addresses
| able    | a...@example.org                                         |
| baker   | ba...@example.org                                        |
| charlie | char...@example.org                                      |
|         | a...@example.org, ba...@example.org, char...@example.org |
#+TBLFM: $2='(concat $1 "@example.org")
#+TBLFM: @4$2='(mapconcat 'identity (list @1$2..@3$2) ", ")

I tried the following to create the concatenation in a
separate table:

| #ERROR |
#+TBLFM: $1='(mapconcat 'identity '(list remote(addresses,@1$2..@3$2) ", ")

but this doesn't work.  Presumably the expansion of the range happens at
the wrong time.

Does anyone know how to do this properly?

Cheers,

Loris

-- 
This signature is currently under construction.