From mboxrd@z Thu Jan  1 00:00:00 1970
From: Rares Vernica <rares@ics.uci.edu>
Subject: another bug in remote references in spreadsheet
Date: Sun, 12 Apr 2009 14:28:43 -0700
Message-ID: <y1rab6ltvck.fsf@ics.uci.edu>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43)
	id 1Lt7Ei-0004BI-5v
	for emacs-orgmode@gnu.org; Sun, 12 Apr 2009 17:29:08 -0400
Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43)
	id 1Lt7Ed-00044K-F3
	for emacs-orgmode@gnu.org; Sun, 12 Apr 2009 17:29:07 -0400
Received: from [199.232.76.173] (port=58842 helo=monty-python.gnu.org)
	by lists.gnu.org with esmtp (Exim 4.43) id 1Lt7Ed-00044B-8g
	for emacs-orgmode@gnu.org; Sun, 12 Apr 2009 17:29:03 -0400
Received: from main.gmane.org ([80.91.229.2]:48645 helo=ciao.gmane.org)
	by monty-python.gnu.org with esmtps (TLS-1.0:RSA_AES_256_CBC_SHA1:32)
	(Exim 4.60) (envelope-from <geo-emacs-orgmode@m.gmane.org>)
	id 1Lt7Ec-0001HU-OR
	for emacs-orgmode@gnu.org; Sun, 12 Apr 2009 17:29:03 -0400
Received: from list by ciao.gmane.org with local (Exim 4.43)
	id 1Lt7Ea-0005z9-5I
	for emacs-orgmode@gnu.org; Sun, 12 Apr 2009 21:29:00 +0000
Received: from igor.ics.uci.edu ([128.195.10.104])
	by main.gmane.org with esmtp (Gmexim 0.1 (Debian))
	id 1AlnuQ-0007hv-00
	for <emacs-orgmode@gnu.org>; Sun, 12 Apr 2009 21:29:00 +0000
Received: from rares by igor.ics.uci.edu with local (Gmexim 0.1 (Debian))
	id 1AlnuQ-0007hv-00
	for <emacs-orgmode@gnu.org>; Sun, 12 Apr 2009 21:29:00 +0000
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/pipermail/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

Hi,

I think I found another bug related to remote references. When I
insert/remove a row/column using the table commands, the remote
references to other tables are also updated. I think org treats "remote"
as a regular function and updates the references inside it.

Here is an example:

#+TBLNAME: TableA
| 101 |
#+TBLFM: @1$1=remote(TableB,@1$1)

#+TBLNAME: TableB
| 101 |

If I go in the cell of TableA and do M-S-down arrow, I get the
following:

#+TBLNAME: TableA
|     |
| 101 |
#+TBLFM: @2$1=remote(TableB,@2$1)
                            ^^^^

As you can see the remote reference has been updated. I similar update
happens when I remove a row or insert/remove a column.

Here is version info (I updated both emacs and org-mode from repository
on April 6th):

emacs-version is a variable defined in `version.el'.
Its value is "23.0.92.2"

org-version is a variable defined in `org.el'.
Its value is "6.25d"

Thanks,
Rares