From mboxrd@z Thu Jan  1 00:00:00 1970
From: Carsten Dominik <carsten.dominik@gmail.com>
Subject: Re: Table rows and ranges as LHS of formulas
Date: Tue, 1 Mar 2011 16:10:05 +0100
Message-ID: <3FF87D1E-5B69-4D8B-BC49-65C5B545FD85@gmail.com>
References: <5A22097F-A1F9-480E-B2E5-030CD6493B2F@gmail.com>
Mime-Version: 1.0 (Apple Message framework v1082)
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from [140.186.70.92] (port=39544 helo=eggs.gnu.org)
	by lists.gnu.org with esmtp (Exim 4.43) id 1PuRDH-0005L0-4Z
	for emacs-orgmode@gnu.org; Tue, 01 Mar 2011 10:10:13 -0500
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <carsten.dominik@gmail.com>) id 1PuRDF-0000Ll-Qj
	for emacs-orgmode@gnu.org; Tue, 01 Mar 2011 10:10:11 -0500
Received: from mail-ww0-f41.google.com ([74.125.82.41]:37750)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <carsten.dominik@gmail.com>) id 1PuRDF-0000Lg-EW
	for emacs-orgmode@gnu.org; Tue, 01 Mar 2011 10:10:09 -0500
Received: by wwb29 with SMTP id 29so2931350wwb.0
	for <emacs-orgmode@gnu.org>; Tue, 01 Mar 2011 07:10:08 -0800 (PST)
In-Reply-To: <5A22097F-A1F9-480E-B2E5-030CD6493B2F@gmail.com>
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <http://lists.gnu.org/mailman/listinfo/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: <http://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=subscribe>
Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
To: Carsten Dominik <carsten.dominik@gmail.com>
Cc: emacs-orgmode List <emacs-orgmode@gnu.org>


On Mar 1, 2011, at 3:28 PM, Carsten Dominik wrote:

> Hi everyone,
> 
> A frequently requested feature for tables has been to
> be able to define row formulas in a way similar to column
> formulas.  The patch below allows things like 
> 
>   @3=
>   @2$2..@5$7=
>   @I$2..@II$4=
> 
> as the left hand side for table formulas in order to
> write a formula that is valid for an entire column or

s/column/row/

> for a rectangular section in a table.
> 
> Note that in contrast to column formulas, @3= will not
> automatically skip a "header column" or field formulas in the
> same row.  In fact, making both a range formula and a field
> point to the same field is forbidden and throws an error.
> So to have a formula apply to all but the first column, use
> something like this:
> 
>    @3$2..@3$8=....
> 
> Testing is welcome, but I am confident that this works
> pretty well.
> 
> Bastien, please let me know if you want to have this integrated
> before the release, then I will do so.
> 
> <0001-Implement-table-formulas-that-apply-to-field-ranges.patch>

- Carsten