From mboxrd@z Thu Jan 1 00:00:00 1970 From: Eric Abrahamsen Subject: Re: table formula help... Date: Mon, 26 Jan 2015 10:48:23 +0800 Message-ID: <87oapmxnns.fsf@ericabrahamsen.net> References: <87ppbxfi5f.fsf@ericabrahamsen.net> <54838805.8090705@free.fr> <8761do6t01.fsf@ericabrahamsen.net> <54C56C67.8060409@free.fr> Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:38058) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1YFZcr-0007rB-My for emacs-orgmode@gnu.org; Sun, 25 Jan 2015 21:42:06 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1YFZco-0007Cm-Gw for emacs-orgmode@gnu.org; Sun, 25 Jan 2015 21:42:05 -0500 Received: from plane.gmane.org ([80.91.229.3]:34454) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1YFZco-0007Ca-A9 for emacs-orgmode@gnu.org; Sun, 25 Jan 2015 21:42:02 -0500 Received: from list by plane.gmane.org with local (Exim 4.69) (envelope-from ) id 1YFZcm-0006uP-0K for emacs-orgmode@gnu.org; Mon, 26 Jan 2015 03:42:00 +0100 Received: from 221.218.165.215 ([221.218.165.215]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Mon, 26 Jan 2015 03:41:59 +0100 Received: from eric by 221.218.165.215 with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Mon, 26 Jan 2015 03:41:59 +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-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org To: emacs-orgmode@gnu.org Thierry Banel writes: > Le 07/12/2014 04:25, Eric Abrahamsen a écrit : > > > Now I'd like to do more calculations based on the rows in the sum(Chars) > and sum(Lines) columns. > > > The new version of Aggregate supports adding new columns in the > aggregated table. This can be achieved in two ways: > - the :formula parameter adds a spreadsheet formula to the aggregated > table > - a #+TBLFM: line in the aggregated table survives refreshes. > > Documentation here: > https://github.com/tbanel/orgaggregate#spreadsheet-formulas > > This feature was borrowed from the "clock table" > http://orgmode.org/manual/The-clock-table.html > Thanks to Michael Brand for pointing to it. Very nice!