From mboxrd@z Thu Jan  1 00:00:00 1970
From: Nicolas Goaziou <mail@nicolasgoaziou.fr>
Subject: Re: Table refuses to forget cell formula which once overrode a
 column formula
Date: Wed, 15 Nov 2017 17:42:26 +0100
Message-ID: <871skzxzm5.fsf@nicolasgoaziou.fr>
References: <CAB8Wf+8N470JrGqtiP1LhPwM4jFG7MekWmLM_04mZwEycCSV+Q@mail.gmail.com>
Mime-Version: 1.0
Content-Type: text/plain
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([2001:4830:134:3::10]:53808)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <mail@nicolasgoaziou.fr>) id 1eF0ll-000716-8r
	for emacs-orgmode@gnu.org; Wed, 15 Nov 2017 11:42:34 -0500
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <mail@nicolasgoaziou.fr>) id 1eF0lh-0006WO-9r
	for emacs-orgmode@gnu.org; Wed, 15 Nov 2017 11:42:33 -0500
Received: from relay4-d.mail.gandi.net ([217.70.183.196]:53740)
	by eggs.gnu.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:32)
	(Exim 4.71) (envelope-from <mail@nicolasgoaziou.fr>)
	id 1eF0lh-0006VJ-3q
	for emacs-orgmode@gnu.org; Wed, 15 Nov 2017 11:42:29 -0500
In-Reply-To: <CAB8Wf+8N470JrGqtiP1LhPwM4jFG7MekWmLM_04mZwEycCSV+Q@mail.gmail.com>
	(Ruy Exel's message of "Tue, 14 Nov 2017 09:27:52 -0200")
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"
	<emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
To: Ruy Exel <ruyexel@gmail.com>
Cc: emacs-orgmode@gnu.org

Hello,

Ruy Exel <ruyexel@gmail.com> writes:

> The following is very simple org-mode spreadsheet in which the cells in the
> second column show the triple of the corresponding cell in the first column
> due to the "column formula" in its TBLFM row $2=3*$1;N. However the third
> row (actually row @4) is an exception because of the "cell formula"
> @4$2=string("Exception") which expectedly overrides the above column
> formula.
>
> |--------+-----------|
> | Number |    Triple |
> |--------+-----------|
> |      1 |         3 |
> |      2 |         6 |
> |      3 | Exception |
> |      4 |        12 |
> |--------+-----------|
>
> #+TBLFM: $2=3*$1::@4$2=string("Exception")
>
> So all is well. Below you will find a copy of the above table, except that,
> after copying, I have deleted the exceptional formula affecting cell @4$2.
>
> |--------+-----------|
> | Number |    Triple |
> |--------+-----------|
> |      1 |         3 |
> |      2 |         6 |
> |      3 | Exception |
> |      4 |        12 |
> |--------+-----------|
>
> #+TBLFM: $2=3*$1
>
> One would expect that, after updating this table with C-u C-c *, or C-c C-c
> in the TBLFM line, the exceptional value in cell @4$2 would revert to the
> triple of '3', but instead the string "Exception" stays put.

Fixed. Thank you.

Regards,

-- 
Nicolas Goaziou