From mboxrd@z Thu Jan  1 00:00:00 1970
From: Michael Brand <michael.ch.brand@gmail.com>
Subject: Re: Preserving the geometry of a table range
Date: Sun, 26 Aug 2012 20:58:01 +0200
Message-ID: <CALn3zojFiOa=4sxgz0bE6WUVV7d2qXuVv=p_e2UmxwoaAYxhfw@mail.gmail.com>
References: <87lih25ejt.fsf@syk.fi>
	<CALn3zohS_Za6w-xf7d0an1auxwzr0DhrT0e8Lffw_N1dcJ2yDQ@mail.gmail.com>
	<87harq59dt.fsf@syk.fi>
Mime-Version: 1.0
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: quoted-printable
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([208.118.235.92]:34063)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <michael.ch.brand@gmail.com>) id 1T5i27-0005n1-O9
	for emacs-orgmode@gnu.org; Sun, 26 Aug 2012 14:58:04 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <michael.ch.brand@gmail.com>) id 1T5i26-0000iD-PZ
	for emacs-orgmode@gnu.org; Sun, 26 Aug 2012 14:58:03 -0400
Received: from mail-lpp01m010-f41.google.com ([209.85.215.41]:36097)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <michael.ch.brand@gmail.com>) id 1T5i26-0000i8-I2
	for emacs-orgmode@gnu.org; Sun, 26 Aug 2012 14:58:02 -0400
Received: by lahd3 with SMTP id d3so2083249lah.0
	for <emacs-orgmode@gnu.org>; Sun, 26 Aug 2012 11:58:01 -0700 (PDT)
In-Reply-To: <87harq59dt.fsf@syk.fi>
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: Jarmo Hurri <jarmo.hurri@syk.fi>
Cc: emacs-orgmode@gnu.org

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=92t 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 =3D '(* $1..$2); N :: @>$3 =3D '(+ @2..@3); N

or with Calc formulas:

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

Michael