Re: [O] Relative Remote Reference (column->row)

[Michael Brand]

Hi Volker

On Fri, Mar 21, 2014 at 1:31 AM, Volker Strobel
<address@hidden> wrote:
> My problem is, that this remote reference starts in row 3 (because of @$#),
> however, I'd like to start in row 2 (that means @$#-1). However, this
> relative reference does not seem to work here.

Calculation within the field reference of Org is not supported but
subscr of Calc can be used to pick calculated references from a range:

#+NAME: my-table
| Header1 | Header2 |
|---------+---------|
| a       |      23 |
| b       |       7 |
| c       |      13 |
| d       |      66 |
| e       |       5 |
|---------+---------|
| Result  |      42 |

| x | y | 23 | 7 | 13 | 66 | 5 |
#+TBLFM: @address@hidden = subscr(remote(my-table, @2$2..6$2), $# - 2)

(To show the intermediade step:
| x | y | [23, 7, 13, 66, 5] | [23, 7, 13, 66, 5] |
#+TBLFM: @address@hidden = remote(my-table, @2$2..6$2)
)

Michael