From mboxrd@z Thu Jan 1 00:00:00 1970 From: Eric Abrahamsen Subject: Re: table formula help... Date: Mon, 08 Dec 2014 11:52:47 +0800 Message-ID: <87a92y4x2o.fsf@ericabrahamsen.net> References: <87ppbxfi5f.fsf@ericabrahamsen.net> <54838805.8090705@free.fr> <8761do6t01.fsf@ericabrahamsen.net> <54841BDA.1030801@free.fr> <548425B5.20304@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]:35707) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1XxpIE-0003R9-Oq for emacs-orgmode@gnu.org; Sun, 07 Dec 2014 22:47:34 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1XxpI5-0005Og-Pz for emacs-orgmode@gnu.org; Sun, 07 Dec 2014 22:47:26 -0500 Received: from plane.gmane.org ([80.91.229.3]:46497) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1XxpI5-0005OE-Im for emacs-orgmode@gnu.org; Sun, 07 Dec 2014 22:47:17 -0500 Received: from list by plane.gmane.org with local (Exim 4.69) (envelope-from ) id 1XxpI4-0003iB-GM for emacs-orgmode@gnu.org; Mon, 08 Dec 2014 04:47:16 +0100 Received: from 61.149.185.27 ([61.149.185.27]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Mon, 08 Dec 2014 04:47:16 +0100 Received: from eric by 61.149.185.27 with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Mon, 08 Dec 2014 04:47:16 +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 10:40, Michael Brand a écrit : >> >> I suggest that orgaggregate lets the user specify a TBLFM to be >> inserted and updated. Missing target columns are added automatically, >> it would result in >> >> #+BEGIN: aggregate :table "work" :cols "Translator sum(Chars) sum(Lines)" >> | Translator | sum(Chars) | sum(Lines) | | >> |-----------------+------------+------------+----------| >> | Austin Woerner | | 84 | 840.00 | >> | Eric Abrahamsen | 6633 | | 4643.10 | >> | Canaan Morse | 16984 | | 11888.80 | >> | Lucas Klein | | 34 | 340.00 | >> #+TBLFM: $4 = $2 * 0.7 + $3 * 10; %.2f >> #+END: >> > > I do agree, Michael, this is probably the way to go. > Maybe the TBLFM should be taken care of for any kind of dynamic blocks, > not only aggregate (columnview, clocktable, propview, invoice, > transpose, and any future dynamic block). > > Regards > Thierry I thought of the same thing when I first started playing, but my plans to provide a "quick patch" foundered when I looked at the code. Who knew that, when I got up in the morning, it would all be implemented and waiting in Melpa! Thanks so much to you both! I think this really improves the usefulness of this package. Eric