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 21:30:25 -0200 Message-ID: References: <871skzxzm5.fsf@nicolasgoaziou.fr> <87inebw6md.fsf@nicolasgoaziou.fr> Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="001a11407ffa6b5894055e0de37d" Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:55087) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1eF78X-00085h-Sg for emacs-orgmode@gnu.org; Wed, 15 Nov 2017 18:30:30 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1eF78W-0007w8-IY for emacs-orgmode@gnu.org; Wed, 15 Nov 2017 18:30:29 -0500 Received: from mail-lf0-x229.google.com ([2a00:1450:4010:c07::229]:45016) by eggs.gnu.org with esmtps (TLS1.0:RSA_AES_128_CBC_SHA1:16) (Exim 4.71) (envelope-from ) id 1eF78W-0007uX-3U for emacs-orgmode@gnu.org; Wed, 15 Nov 2017 18:30:28 -0500 Received: by mail-lf0-x229.google.com with SMTP id i14so205033lfc.1 for ; Wed, 15 Nov 2017 15:30:27 -0800 (PST) In-Reply-To: <87inebw6md.fsf@nicolasgoaziou.fr> 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 --001a11407ffa6b5894055e0de37d Content-Type: text/plain; charset="UTF-8" Thanks for your reply. I now understand and I also agree it is a good solution. Best, Ruy On Nov 15, 2017 19:54, "Nicolas Goaziou" wrote: > Ruy Exel writes: > > > 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. > > The property is here to prevent evaluation of a column formula on > a given field. It doesn't override anything. > > > 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. > > This is what happens already. The property prevents useless > computations. > > Regards, > --001a11407ffa6b5894055e0de37d Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Thanks for your reply.=C2=A0 I now understand and I also = agree it is a good solution.

B= est,
Ruy

<= div class=3D"gmail_quote">On Nov 15, 2017 19:54, "Nicolas Goaziou"= ; <mail@nicolasgoaziou.fr&= gt; wrote:
Ruy Exel= <ruyexel@gmail.com> writes:=

> Thanks very much.=C2=A0 Just out of curiosity I'd be interested in= understanding
> how did you do it.=C2=A0 My (non expert) impression is that using prop= erties to
> override column formulas isn't a good idea.

The property is here to prevent evaluation of a column formula on
a given field. It doesn't override anything.

> 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.

This is what happens already. The property prevents useless
computations.

Regards,
--001a11407ffa6b5894055e0de37d--