From mboxrd@z Thu Jan  1 00:00:00 1970
From: Thierry Banel <tbanelwebmin@free.fr>
Subject: Re: table formula help...
Date: Sun, 07 Dec 2014 11:02:29 +0100
Message-ID: <548425B5.20304@free.fr>
References: <87ppbxfi5f.fsf@ericabrahamsen.net>	<CALn3zogy-J5cSHUgOHmxpN2UH=g54QcU2=pqyAMGgMf1Pcd6Jg@mail.gmail.com>	<54838805.8090705@free.fr>	<8761do6t01.fsf@ericabrahamsen.net>	<54841BDA.1030801@free.fr>
	<CALn3zoipB5zSV5wKvtf05ZMmpujQQjBbUuORniyqVvuUpvjATQ@mail.gmail.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([2001:4830:134:3::10]:50487)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <tbanelwebmin@free.fr>) id 1XxYfh-0001LM-Ke
	for emacs-orgmode@gnu.org; Sun, 07 Dec 2014 05:02:34 -0500
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <tbanelwebmin@free.fr>) id 1XxYfg-0004XN-KS
	for emacs-orgmode@gnu.org; Sun, 07 Dec 2014 05:02:33 -0500
Received: from smtp4-g21.free.fr ([2a01:e0c:1:1599::13]:16278)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <tbanelwebmin@free.fr>) id 1XxYfg-0004Wz-EC
	for emacs-orgmode@gnu.org; Sun, 07 Dec 2014 05:02:32 -0500
Received: from [IPv6:2a01:e35:2e21:def0:945c:654d:e692:22ed] (unknown
	[IPv6:2a01:e35:2e21:def0:945c:654d:e692:22ed])
	by smtp4-g21.free.fr (Postfix) with ESMTP id 4377D4C80A5
	for <emacs-orgmode@gnu.org>; Sun,  7 Dec 2014 11:02:08 +0100 (CET)
In-Reply-To: <CALn3zoipB5zSV5wKvtf05ZMmpujQQjBbUuORniyqVvuUpvjATQ@mail.gmail.com>
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <https://lists.gnu.org/mailman/options/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/archive/html/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <https://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=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: Org Mode <emacs-orgmode@gnu.org>

Le 07/12/2014 10:40, Michael Brand a =C3=A9crit :
>
> 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 =3D $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