Re: [O] Table refuses to forget cell formula which once overrode a column formula

[Nick Dokos]

Ruy Exel <address@hidden> 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" <address@hidden> wrote:
>
>     Hello,
>    
>     Ruy Exel <address@hidden> 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