From mboxrd@z Thu Jan  1 00:00:00 1970
From: Tom <adatgyujto@gmail.com>
Subject: Table formula changes are not always necessary when moving rows
Date: Mon, 28 Feb 2011 11:43:17 +0000 (UTC)
Message-ID: <loom.20110228T122543-741@post.gmane.org>
Mime-Version: 1.0
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=57842 helo=eggs.gnu.org)
	by lists.gnu.org with esmtp (Exim 4.43) id 1Pu1Vn-0006hv-EQ
	for emacs-orgmode@gnu.org; Mon, 28 Feb 2011 06:43:40 -0500
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <geo-emacs-orgmode@m.gmane.org>) id 1Pu1Vm-0003sc-7k
	for emacs-orgmode@gnu.org; Mon, 28 Feb 2011 06:43:35 -0500
Received: from lo.gmane.org ([80.91.229.12]:56988)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <geo-emacs-orgmode@m.gmane.org>) id 1Pu1Vl-0003sA-V4
	for emacs-orgmode@gnu.org; Mon, 28 Feb 2011 06:43:34 -0500
Received: from list by lo.gmane.org with local (Exim 4.69)
	(envelope-from <geo-emacs-orgmode@m.gmane.org>) id 1Pu1Vk-0007mk-F4
	for emacs-orgmode@gnu.org; Mon, 28 Feb 2011 12:43:32 +0100
Received: from 94-21-222-80.pool.digikabel.hu ([94.21.222.80])
	by main.gmane.org with esmtp (Gmexim 0.1 (Debian))
	id 1AlnuQ-0007hv-00
	for <emacs-orgmode@gnu.org>; Mon, 28 Feb 2011 12:43:32 +0100
Received: from adatgyujto by 94-21-222-80.pool.digikabel.hu with local (Gmexim
	0.1 (Debian)) id 1AlnuQ-0007hv-00
	for <emacs-orgmode@gnu.org>; Mon, 28 Feb 2011 12:43:32 +0100
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: emacs-orgmode@gnu.org

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).

This is not always the expected behavior, because in this case I
just want to move the data in the rows, but still want to sum the
values of all the rows from the first to the last. A similar case
is when I want to insert a row before the first row of such a
table. In that case too the formulas should be left alone,
because I still want to sum all the rows, including the newly
inserted first row.

In such cases when the formula is modified Org should either
print warning to the echo area, so the user notices when the
formulas are changing because of the move, or it should ask the
user what to do ("do you want to modify the formulas?").