From mboxrd@z Thu Jan 1 00:00:00 1970 From: Michael Brand Subject: Re: Help on spreadsheet/calc references and improvements Date: Sat, 5 Oct 2013 17:16:27 +0200 Message-ID: References: <2013-10-05T16-39-57@devnull.Karl-Voit.at> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:58842) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1VSTar-00015q-B8 for emacs-orgmode@gnu.org; Sat, 05 Oct 2013 11:16:37 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1VSTam-0002Fu-K3 for emacs-orgmode@gnu.org; Sat, 05 Oct 2013 11:16:33 -0400 Received: from mail-la0-x230.google.com ([2a00:1450:4010:c03::230]:54444) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1VSTam-0002Fd-Bc for emacs-orgmode@gnu.org; Sat, 05 Oct 2013 11:16:28 -0400 Received: by mail-la0-f48.google.com with SMTP id er20so4142667lab.21 for ; Sat, 05 Oct 2013 08:16:27 -0700 (PDT) In-Reply-To: <2013-10-05T16-39-57@devnull.Karl-Voit.at> List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org To: news1142@karl-voit.at Cc: Org Mode Hi Karl On Sat, Oct 5, 2013 at 4:49 PM, Karl Voit 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