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
