From mboxrd@z Thu Jan 1 00:00:00 1970 From: Michael Brand Subject: Re: Preserving the geometry of a table range Date: Sun, 26 Aug 2012 20:58:01 +0200 Message-ID: References: <87lih25ejt.fsf@syk.fi> <87harq59dt.fsf@syk.fi> Mime-Version: 1.0 Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: quoted-printable Return-path: Received: from eggs.gnu.org ([208.118.235.92]:34063) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) 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 ) 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 ) 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 ; Sun, 26 Aug 2012 11:58:01 -0700 (PDT) In-Reply-To: <87harq59dt.fsf@syk.fi> List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-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 Cc: emacs-orgmode@gnu.org Hi Jarmo On Sun, Aug 26, 2012 at 10:45 AM, Jarmo Hurri 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