Hi Thierry On Sun, Dec 7, 2014 at 10:20 AM, Thierry Banel <tbanelweb...@free.fr> 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:
