Re: Preserving the geometry of a table range

[Michael Brand <michael.ch.brand@gmail.com>]

Hi Jarmo

On Sun, Aug 26, 2012 at 10:45 AM, Jarmo Hurri <jarmo.hurri@syk.fi> wrote:

> Does this help?

Yes.

>   but now it naturally gives an error, since the argument to
>   sum-row-prods is a list, not a list of lists (rows).

AFAIK there is no way to get the list of lists.

But if you didn’t already you may consider to separate the calculation
of rows and columns into two steps which I think should be possible in
most cases and use something like this:

| a | b | prod |
|---+---+------|
| 2 | 3 |    6 |
| 4 | 5 |   20 |
|   |   |   26 |
#+TBLFM: $3 = '(* $1..$2); N :: @>$3 = '(+ @2..@3); N

or with Calc formulas:

#+TBLFM: $3 = vprod($1..$2) :: @>$3 = vsum(@2..@3)

Michael