From mboxrd@z Thu Jan 1 00:00:00 1970 From: Ruy Exel Subject: Re: Table refuses to forget cell formula which once overrode a column formula Date: Wed, 15 Nov 2017 17:17:34 -0200 Message-ID: References: <871skzxzm5.fsf@nicolasgoaziou.fr> Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="94eb2c1953a81e12f9055e0a5b50" Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:54364) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1eF3Bp-0005dg-Lz for emacs-orgmode@gnu.org; Wed, 15 Nov 2017 14:17:39 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1eF3Bo-0001kU-JI for emacs-orgmode@gnu.org; Wed, 15 Nov 2017 14:17:37 -0500 Received: from mail-wm0-x229.google.com ([2a00:1450:400c:c09::229]:42646) by eggs.gnu.org with esmtps (TLS1.0:RSA_AES_128_CBC_SHA1:16) (Exim 4.71) (envelope-from ) id 1eF3Bo-0001jL-9g for emacs-orgmode@gnu.org; Wed, 15 Nov 2017 14:17:36 -0500 Received: by mail-wm0-x229.google.com with SMTP id t139so5142110wmt.1 for ; Wed, 15 Nov 2017 11:17:36 -0800 (PST) In-Reply-To: List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Sender: "Emacs-orgmode" To: Nicolas Goaziou Cc: emacs-orgmode@gnu.org --94eb2c1953a81e12f9055e0a5b50 Content-Type: text/plain; charset="UTF-8" Hi Nicolas, Thanks very much. Just out of curiosity I'd be interested in understanding how did you do it. My (non expert) impression is that using properties to override column formulas isn't a good idea. It seems to me it would be more natural to apply cell formulas AFTER all column formulas were applied, so that each cell would be simply the output of the formula defining it. Best, Ruy On Nov 15, 2017 14:42, "Nicolas Goaziou" wrote: Hello, Ruy Exel 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 --94eb2c1953a81e12f9055e0a5b50 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi Nicolas,

= Thanks very much.=C2=A0 Just out of curiosity I'd be interested in unde= rstanding how did you do it.=C2=A0 My (non expert) impression is that using= properties to override column formulas isn't a good idea.=C2=A0 It see= ms to me it would be more natural to apply cell formulas AFTER all column f= ormulas were applied, so that each cell would be simply the output of the f= ormula defining it.

Best= ,
Ruy

On Nov 15, 2017 14:42, "Nicolas Goaziou" &= lt;mail@nicolasgoaziou.fr>= wrote:
Hello,

Ruy Exel <ruyexel@gmail.com>= writes:

> The following is very simple org-mode spreadsheet in which the cells i= n the
> second column show the triple of the corresponding cell in the first c= olumn
> due to the "column formula" in its TBLFM row $2=3D3*$1;N. Ho= wever the third
> row (actually row @4) is an exception because of the "cell formul= a"
> @4$2=3Dstring("Exception") which expectedly overrides the ab= ove column
> formula.
>
> |--------+-----------|
> | Number |=C2=A0 =C2=A0 Triple |
> |--------+-----------|
> |=C2=A0 =C2=A0 =C2=A0 1 |=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A03 |
> |=C2=A0 =C2=A0 =C2=A0 2 |=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A06 |
> |=C2=A0 =C2=A0 =C2=A0 3 | Exception |
> |=C2=A0 =C2=A0 =C2=A0 4 |=C2=A0 =C2=A0 =C2=A0 =C2=A0 12 |
> |--------+-----------|
>
> #+TBLFM: $2=3D3*$1::@4$2=3Dstring("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 |=C2=A0 =C2=A0 Triple |
> |--------+-----------|
> |=C2=A0 =C2=A0 =C2=A0 1 |=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A03 |
> |=C2=A0 =C2=A0 =C2=A0 2 |=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A06 |
> |=C2=A0 =C2=A0 =C2=A0 3 | Exception |
> |=C2=A0 =C2=A0 =C2=A0 4 |=C2=A0 =C2=A0 =C2=A0 =C2=A0 12 |
> |--------+-----------|
>
> #+TBLFM: $2=3D3*$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" st= ays put.

Fixed. Thank you.

Regards,

--
Nicolas Goaziou

--94eb2c1953a81e12f9055e0a5b50--