From mboxrd@z Thu Jan 1 00:00:00 1970 From: Nick Dokos Subject: Re: Table refuses to forget cell formula which once overrode a column formula Date: Wed, 15 Nov 2017 16:07:20 -0500 Message-ID: <87o9o3w8s7.fsf@alphaville.usersys.redhat.com> References: <871skzxzm5.fsf@nicolasgoaziou.fr> Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:48140) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1eF4uI-0001fq-Dp for emacs-orgmode@gnu.org; Wed, 15 Nov 2017 16:07:39 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1eF4uF-0003mx-25 for emacs-orgmode@gnu.org; Wed, 15 Nov 2017 16:07:38 -0500 Received: from [195.159.176.226] (port=56126 helo=blaine.gmane.org) by eggs.gnu.org with esmtps (TLS1.0:RSA_AES_128_CBC_SHA1:16) (Exim 4.71) (envelope-from ) id 1eF4uE-0003m1-R0 for emacs-orgmode@gnu.org; Wed, 15 Nov 2017 16:07:34 -0500 Received: from list by blaine.gmane.org with local (Exim 4.84_2) (envelope-from ) id 1eF4u2-0007J7-B9 for emacs-orgmode@gnu.org; Wed, 15 Nov 2017 22:07:22 +0100 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: emacs-orgmode@gnu.org Ruy Exel writes: > 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. > Here's what I do in such cases (I'm assuming that the change exists in master, either because it was applied there in the first place, or after a merge with maint): - update my git repo: git checkout master; git remote update; git rebase - check recent history: git log -20 --oneline - find the commit of interest - in this case 6059c3a05 org-table: Clean left-over `:org-untouchable' property - show the commit: git show 6059c3a05 HTH. > > 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 > -- Nick