Ruy Exel <ruye...@gmail.com> 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" <m...@nicolasgoaziou.fr> wrote:
>
> Hello,
>
> Ruy Exel <ruye...@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
>
--
Nick
