From mboxrd@z Thu Jan  1 00:00:00 1970
From: Nick Dokos <nicholas.dokos@hp.com>
Subject: Re: Table rows and ranges as LHS of formulas
Date: Wed, 02 Mar 2011 13:54:09 -0500
Message-ID: <24402.1299092049@alphaville.dokosmarshall.org>
References: <5A22097F-A1F9-480E-B2E5-030CD6493B2F@gmail.com>
	<878vwx5tgl.fsf@gnu.org>
	<907667C9-5D38-4DF4-B0CE-BEFEFE40A192@gmail.com>
Reply-To: nicholas.dokos@hp.com
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from [140.186.70.92] (port=47697 helo=eggs.gnu.org)
	by lists.gnu.org with esmtp (Exim 4.43) id 1PurBu-0005fD-BA
	for emacs-orgmode@gnu.org; Wed, 02 Mar 2011 13:54:31 -0500
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <nick@dokosmarshall.org>) id 1PurBs-0005PY-Q1
	for emacs-orgmode@gnu.org; Wed, 02 Mar 2011 13:54:30 -0500
Received: from vms173007pub.verizon.net ([206.46.173.7]:43050)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <nick@dokosmarshall.org>) id 1PurBs-0005Nt-Mz
	for emacs-orgmode@gnu.org; Wed, 02 Mar 2011 13:54:28 -0500
Received: from alphaville.dokosmarshall.org ([unknown] [173.76.32.106])
	by vms173007.mailsrvcs.net
	(Sun Java(tm) System Messaging Server 7u2-7.02 32bit (built Apr 16
	2009)) with ESMTPA id <0LHG007J11U95WA0@vms173007.mailsrvcs.net> for
	emacs-orgmode@gnu.org; Wed, 02 Mar 2011 12:54:16 -0600 (CST)
In-reply-to: Message from Carsten Dominik <carsten.dominik@gmail.com> of
	"Wed, 02 Mar 2011 18:35:40 +0100."
	<907667C9-5D38-4DF4-B0CE-BEFEFE40A192@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: Bastien <bzg@altern.org>, nicholas.dokos@hp.com, emacs-orgmode List <emacs-orgmode@gnu.org>

Carsten Dominik <carsten.dominik@gmail.com> wrote:

> 
> On 2.3.2011, at 18:21, Bastien wrote:
> 
> > Hi Carsten,
> > 
> > Carsten Dominik <carsten.dominik@gmail.com> writes:
> > 
> >> Bastien, please let me know if you want to have this integrated
> >> before the release, then I will do so.
> > 
> > Please go ahead!  This looks like a nice addition, thanks for that.
> 
> I just pushed it.  The patch I pushed contains another small thing:
> you can use @L to mean the last row.  So
> 
>     @L=vsum(@I..II)
> 
> is now a great way to sum columns in the last row. 
> To skip the First column (in case it contains unsummable
> labels or so, use
> 
>    @L$2..@L@8=vsum(@I..II)
> 

Both of these and Christian's multiplication table are great
examples. Thanks!

One nit: symmetry dictates that $L should be the last column, but it
isn't.  Trying @2$2..@L$11 in Christian's example works fine, but
@2$2..@L$L changes the first column to all zeroes (not sure why).

Thanks,
Nick

-- 
Emacs-orgmode mailing list
Please use `Reply All' to send replies to the list.
Emacs-orgmode@gnu.org
http://lists.gnu.org/mailman/listinfo/emacs-orgmode