Hi Karl You need additionally $# from "Field coordinates in formulas" described here: http://orgmode.org/manual/References.html#References and Calc vector subscript: #+TBLFM: @2 = subscr(remote(orgtblA, @2$2..@2$7), $#)
Michael On Tue, Jun 7, 2011 at 17:55, Karl Voit <devn...@karl-voit.at> wrote: > I want to define "orgtblB line 2 (row 1 to 6)" should contain the > values "from orgtblA, last line, row 2 to 7". > > I tried > > #+TBLFM: @2=remote(orgtblA,@2$2..@2$7) > > and > > #+TBLFM: @2$1..@2$6=remote(orgtblA,@2$2..@2$7) > > but that results in a list of 6x 5 values in each field in row 2. > > Here is an example of my org-tbl-reference-problem: > http://paste.grml.org/462/