From mboxrd@z Thu Jan  1 00:00:00 1970
From: Carsten Dominik <dominik@uva.nl>
Subject: Re: [bug] removing last column with a column formula
Date: Thu, 25 Aug 2011 08:20:38 +0200
Message-ID: <7C3F1A96-494F-4B20-9A7B-A0DE03FE6E5E@uva.nl>
References: <87zkjilpej.fsf@gmail.com> <8762lmk6j7.fsf@gnu.org>
Mime-Version: 1.0 (Apple Message framework v1084)
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 eggs.gnu.org ([140.186.70.92]:37433)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <dominik@uva.nl>) id 1QwTtZ-0007fY-3n
	for emacs-orgmode@gnu.org; Thu, 25 Aug 2011 02:58:33 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <dominik@uva.nl>) id 1QwTtY-0006HZ-3s
	for emacs-orgmode@gnu.org; Thu, 25 Aug 2011 02:58:33 -0400
Received: from pony.ic.uva.nl ([145.18.40.181]:46194)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <dominik@uva.nl>) id 1QwTtX-0006HI-Oh
	for emacs-orgmode@gnu.org; Thu, 25 Aug 2011 02:58:31 -0400
In-Reply-To: <8762lmk6j7.fsf@gnu.org>
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: </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: Bastien <bzg@altern.org>
Cc: Org Mode List <emacs-orgmode@gnu.org>, Michael Brand <michael.ch.brand@gmail.com>, Nicolas Goaziou <n.goaziou@gmail.com>, Carsten Dominik <dominik@science.uva.nl>


On 24.8.2011, at 20:29, Bastien wrote:

> Hi Carsten,
> 
> Nicolas Goaziou <n.goaziou@gmail.com> writes:
> 
>> Let's consider the following table:
>> 
>> #+begin_src org
>> | 1 | 2 | 3 |
>> | 1 | 2 | 3 |
>> #+TBLFM: @2$1..@2$3=@1
>> #+end_src
>> 
>> If I remove the second column (M-S-Left), the formula is correctly
>> updated. But when I remove the last column, the formula gets partly
>> deleted and becomes:
>> 
>>                            #+TBLFM: @2$1..
>> 
>> Also, if this times, the first column is removed, that line becomes:
>> 
>>                      #+TBLFM: @2$INVALID..@2$2=@1
>> 
>> This is with latest Org and no user configuration.
> 
> Is this something that we can (easily) fix?  


Not easily.  I have made it throw an error now, but there may be
other situations like this which are not yet captured.

Michael Brand has pointed out correctly that if you want to use
ranges the go to the border of the table, you should use
$< and $>

Cheers

- Carsten