From mboxrd@z Thu Jan  1 00:00:00 1970
From: Nick Dokos <nicholas.dokos@hp.com>
Subject: Re: Table formula changes are not always necessary when moving rows
Date: Thu, 17 Mar 2011 10:15:47 -0400
Message-ID: <7997.1300371347@alphaville.dokosmarshall.org>
References: <loom.20110228T122543-741@post.gmane.org>
	<B3DE5F6C-F4A2-45F2-A055-C8A4C6572507@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=47912 helo=eggs.gnu.org)
	by lists.gnu.org with esmtp (Exim 4.43) id 1Q0Dzp-00027P-VZ
	for emacs-orgmode@gnu.org; Thu, 17 Mar 2011 10:16:14 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <nick@dokosmarshall.org>) id 1Q0Dzo-0007yH-Qm
	for emacs-orgmode@gnu.org; Thu, 17 Mar 2011 10:16:13 -0400
Received: from vms173017pub.verizon.net ([206.46.173.17]:42192)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <nick@dokosmarshall.org>) id 1Q0Dzo-0007y1-NP
	for emacs-orgmode@gnu.org; Thu, 17 Mar 2011 10:16:12 -0400
Received: from alphaville.dokosmarshall.org ([unknown] [173.76.32.106])
	by vms173017.mailsrvcs.net
	(Sun Java(tm) System Messaging Server 7u2-7.02 32bit (built Apr 16
	2009)) with ESMTPA id <0LI700H7CGYBMC40@vms173017.mailsrvcs.net> for
	emacs-orgmode@gnu.org; Thu, 17 Mar 2011 09:15:53 -0500 (CDT)
In-reply-to: Message from Carsten Dominik <carsten.dominik@gmail.com> of
	"Thu, 17 Mar 2011 07:03:29 BST."
	<B3DE5F6C-F4A2-45F2-A055-C8A4C6572507@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: nicholas.dokos@hp.com, emacs-orgmode@gnu.org, Tom <adatgyujto@gmail.com>

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

> 
> On 28.2.2011, at 12:43, Tom wrote:
> 
> > I have a table in which I sum the values of all rows in the last
> > row: vsum(@1..@-I-1). The problem is when move a row with M-up
> > before the first row (e.g. I press M-up on the second row) then
> > org modifies this formula to vsum(@2..@-I-1).
> 
> 
> Hi Tom,
> 
> I have thought a bit more about this issue.  I do agree that,
> in particular when specifying ranges, it may not always
> desirable to have the formulas automatically adapt when
> rows and columns are swapped.
> 
> I have just pushed a change that makes $< and @< refer in
> a stable way to the first column and row, respectively.
> You can also use @<<< to mean the second row and @>>
> the second to last row.
> 

I hope you mean @<< above: otherwise the symmetry is spoiled :-)

> I hope this will prove to be useful for such cases.
> 
> Regards
> 
> P.S. Nick (Dokos), I also added them to get the symmetry with
> the @> and $> references :)
> 
And a thing of beauty it is, too! ;-)

Much appreciated,
Nick