From mboxrd@z Thu Jan  1 00:00:00 1970
From: Michael Brand <michael.ch.brand@gmail.com>
Subject: Re: table formula help...
Date: Sun, 7 Dec 2014 10:40:49 +0100
Message-ID: <CALn3zoipB5zSV5wKvtf05ZMmpujQQjBbUuORniyqVvuUpvjATQ@mail.gmail.com>
References: <87ppbxfi5f.fsf@ericabrahamsen.net>
	<CALn3zogy-J5cSHUgOHmxpN2UH=g54QcU2=pqyAMGgMf1Pcd6Jg@mail.gmail.com>
	<54838805.8090705@free.fr> <8761do6t01.fsf@ericabrahamsen.net>
	<54841BDA.1030801@free.fr>
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]:48162)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <michael.ch.brand@gmail.com>) id 1XxYKg-0005OZ-LV
	for emacs-orgmode@gnu.org; Sun, 07 Dec 2014 04:40:51 -0500
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <michael.ch.brand@gmail.com>) id 1XxYKf-0005mL-Nb
	for emacs-orgmode@gnu.org; Sun, 07 Dec 2014 04:40:50 -0500
Received: from mail-qc0-x234.google.com ([2607:f8b0:400d:c01::234]:64835)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <michael.ch.brand@gmail.com>) id 1XxYKf-0005mF-Ix
	for emacs-orgmode@gnu.org; Sun, 07 Dec 2014 04:40:49 -0500
Received: by mail-qc0-f180.google.com with SMTP id i8so2320321qcq.25
	for <emacs-orgmode@gnu.org>; Sun, 07 Dec 2014 01:40:49 -0800 (PST)
In-Reply-To: <54841BDA.1030801@free.fr>
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: Thierry Banel <tbanelwebmin@free.fr>
Cc: Org Mode <emacs-orgmode@gnu.org>

Hi Thierry

On Sun, Dec 7, 2014 at 10:20 AM, Thierry Banel <tbanelwebmin@free.fr> wrote=
:
> Le 07/12/2014 04:25, Eric Abrahamsen a =C3=A9crit :
>> [...]
>> (sum(prod($2 0.7) prod($3 10))
>>
>> Where $2 and $3 refer to cells in the aggregated table.
>
> It would be great of course. However I don't know how to do that
> cleanly. If we want total flexibility for the formulas, we will end up
> duplicating the native features of Org spreadsheet.

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: