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. Is this a bug or am I doing something wrong?
I noticed that if I save the file, close it (kill-buffer) and then reopen it, the strange behaviour disapears, namely, updating the table with C-u C-c *
causes cell @4$2 to turn to '9', as expected.
I am using GNU Emacs 24.3.1 and the latest version of org-mode.