From mboxrd@z Thu Jan 1 00:00:00 1970 From: Michael Welle Subject: Re: remote ref in spreadsheets Date: Sun, 22 Jan 2017 12:42:40 +0100 Message-ID: <87pojffhhr.fsf@luisa.c0t0d0s0.de> References: <9ae5pbxf26.ln2@news.c0t0d0s0.de> Mime-Version: 1.0 Content-Type: text/plain Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:42248) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1cVGXv-0006E7-QJ for emacs-orgmode@gnu.org; Sun, 22 Jan 2017 06:42:56 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1cVGXq-0001sO-U6 for emacs-orgmode@gnu.org; Sun, 22 Jan 2017 06:42:55 -0500 Received: from mout.gmx.net ([212.227.17.20]:52059) by eggs.gnu.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:32) (Exim 4.71) (envelope-from ) id 1cVGXq-0001rT-JH for emacs-orgmode@gnu.org; Sun, 22 Jan 2017 06:42:50 -0500 Received: from stella.c0t0d0s0.de ([89.15.236.235]) by mail.gmx.com (mrgmx102 [212.227.17.168]) with ESMTPSA (Nemesis) id 0MKKaI-1cUiZs3D3m-001jDF for ; Sun, 22 Jan 2017 12:42:47 +0100 Received: from Stella (stella.c0t0d0s0.de [192.168.42.1]) by stella.c0t0d0s0.de (Postfix) with ESMTP id AA0F7C45FC for ; Sun, 22 Jan 2017 12:42:40 +0100 (CET) In-Reply-To: <9ae5pbxf26.ln2@news.c0t0d0s0.de> (Michael Welle's message of "Wed, 21 Jan 2015 21:20:57 +0100") 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" To: emacs-orgmode@gnu.org Hello, so, two years and two yearly tables later I solved the problem. I couldn't see how to get that to work with orgaggregate, so I tried a different approach. My tables look like follows: * Tables #+NAME: overview | Year | Sum | |------+--------| | 2017 | 107.90 | | 2016 | 42.00 | |------+--------| #+TBLFM: $2='(org-table-get-remote-range (concat "BC_" $1) (string ?@ ?I ?I ?$ ?3));%.2f ** 2017 #+NAME: BC_2017 |--------+-------+--------| | 13.01. | foo | 38.90 | | 13.01. | bar | 69.00 | |--------+-------+--------| | | Summe | 107.90 | #+TBLFM: $3=vsum(@I..@II);%.2f For every year I have a table named BC_yyyy that sums up some stuff. What I want is a table that gives an overview about all the sums of every year. My first approach was to add a new formula to the overview table every year. That worked for the first couple of years. But I had to change the cell addresses of every existing formula when adding a new row and after a few years that became clumsy. With the above approach I only had to insert a new row into the overview table and fill in the year into the first column. I could automate that further and let Org find all tables named BC_yyyy. Maybe next year ;). Regards hmw