From mboxrd@z Thu Jan  1 00:00:00 1970
From: Daniel Gerber <daniel.g.gerber@gmail.com>
Subject: Not all table formulas are updated when swapping columns
Date: Mon, 16 Dec 2013 14:33:02 +0100
Message-ID: <52AF010E.2030505@gmail.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([2001:4830:134:3::10]:34804)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <daniel.g.gerber@gmail.com>) id 1VsYIO-0000Rl-6Z
	for emacs-orgmode@gnu.org; Mon, 16 Dec 2013 08:33:24 -0500
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <daniel.g.gerber@gmail.com>) id 1VsYIF-0006hn-Ql
	for emacs-orgmode@gnu.org; Mon, 16 Dec 2013 08:33:16 -0500
Received: from mail-ee0-x230.google.com ([2a00:1450:4013:c00::230]:51711)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <daniel.g.gerber@gmail.com>) id 1VsYIF-0006hY-KR
	for emacs-orgmode@gnu.org; Mon, 16 Dec 2013 08:33:07 -0500
Received: by mail-ee0-f48.google.com with SMTP id e49so2202916eek.35
	for <emacs-orgmode@gnu.org>; Mon, 16 Dec 2013 05:33:06 -0800 (PST)
Received: from [192.168.0.12] (217-162-42-42.dynamic.hispeed.ch.
	[217.162.42.42]) by mx.google.com with ESMTPSA id
	g47sm42300153eeo.19.2013.12.16.05.33.03 for <emacs-orgmode@gnu.org>
	(version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128);
	Mon, 16 Dec 2013 05:33:05 -0800 (PST)
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <https://lists.gnu.org/mailman/options/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: <https://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=subscribe>
Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
To: emacs-orgmode@gnu.org

Hi,

A minor bug with spreadsheets: when swapping two columns in a table 
(alt+left), column formulas are updated only when defined in the first 
#+TBLFM: line.

That is, this table

|   |   |
#+TBLFM: $1=1::$2=2

after swapping becomes (correctly)

|   |   |
#+TBLFM: $2=1::$1=2

but with this one

|   |   |
#+TBLFM: $1=1
#+TBLFM: $2=2

the second formula will lag behind

|   |   |
#+TBLFM: $2=1
#+TBLFM: $2=2

Incidentally, this would not be a problem if named fields were accepted 
on the left-hand side.

Regards,