Re: [O] table formula help...

[Michael Brand]

Hi Thierry

On Sun, Dec 7, 2014 at 10:20 AM, Thierry Banel <address@hidden> wrote:
> Le 07/12/2014 04:25, Eric Abrahamsen a écrit :
>> [...]
>> (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 = $2 * 0.7 + $3 * 10; %.2f
#+END: