Hi Karl On Sat, Oct 5, 2013 at 4:49 PM, Karl Voit <devn...@karl-voit.at> wrote: > Feel free to make suggestions how to overcome my lack of knowledge
You may want to look at the example "$3 = remote(FOO, @@#$2)" in the Org manual, then it becomes quite simple. > #+NAME: Data23vert > | Descr+ | Data1+ | Data2+ | > |--------+--------+--------| > | foo | 12 | 10 | > | bar | 22 | 24 | > | baz | 16 | 17 | > |--------+--------+--------| > | sum | 50 | 51 | > > #+NAME: Calc23vert-WISH > | Descr | Data2 | Double | > |-------+-------+---------| > | foo | 10 | 20 | > | bar | 24 | 48 | > | baz | 17 | 34 | > |-------+-------+---------| > | sum | 51 | 102 | > #+TBLFM: FIXXME #+NAME: Data23vert | Descr+ | Data1+ | Data2+ | |--------+--------+--------| | foo | 12 | 10 | | bar | 22 | 24 | | baz | 16 | 17 | |--------+--------+--------| | sum | 50 | 51 | | Descr | Data2 | Double | |-------+-------+--------| | foo | 10 | 20 | | bar | 24 | 48 | | baz | 17 | 34 | |-------+-------+--------| | sum | 51 | 102 | #+TBLFM: $2 = remote(Data23vert, @@#$3) :: $3 = 2 * remote(Data23vert, @@#$3) > #+NAME: Data23horiz > | Descr+ | foo | bar | baz | sum | > |--------+-----+-----+-----+-----| > | Data1+ | 12 | 22 | 16 | 50 | > | Data2+ | 10 | 24 | 17 | 51 | > > #+NAME: Calc23horiz-WISH > | Descr | foo | bar | baz | sum | > |---------+-----+-----+-----+-----| > | Data2 | 10 | 24 | 17 | 51 | > | Double | 20 | 48 | 34 | 102 | > #+TBLFM: FIXXME #+NAME: Data23horiz | Descr+ | foo | bar | baz | sum | |--------+-----+-----+-----+-----| | Data1+ | 12 | 22 | 16 | 50 | | Data2+ | 10 | 24 | 17 | 51 | | Descr | foo | bar | baz | sum | |--------+-----+-----+-----+-----| | Data2 | 10 | 24 | 17 | 51 | | Double | 20 | 48 | 34 | 102 | #+TBLFM: @2$2..@2$5 = remote(Data23horiz, @3$$#) :: @3$2..@3$5 = 2 * remote(Data23horiz, @3$$#) Michael