On Friday, 2 Jul 2021 at 16:07, Uwe Brauer wrote: > The problem is the target @<<$3..@>>$3 > > There seems no option to specify such a range.
Sorry, I didn't explain myself properly. You can specify which rows should be calculated automatically so that you can then use a simple column formula without it extending to the full column: #+begin_src org ,#+Name: check | | User1 | User2 | Result | |---+-------+-------+--------| | # | 1 | 3 | 4 | | # | 4 | 8 | 12 | | # | 10 | 3 | 13 | |---+-------+-------+--------| | | 7 | 9 | | ,#+TBLFM: $4=$2+$3 #+end_src If you type "C-u C-c *" to re-calculate the table, the last entry in the 4th column is not updated even though the expression says that column 4 is the sum of columns 2 and 3. Once you start using some of these advanced features, you can make your formulas easier to read, e.g.: #+begin_src org ,#+Name: check2 | ! | User1 | User2 | Result | |---+-------+-------+--------| | # | 1 | 3 | 4 | | # | 4 | 8 | 12 | | # | 10 | 3 | 13 | |---+-------+-------+--------| | | 7 | 9 | | ,#+TBLFM: $4=$User1+$User2 #+end_src HTH, eric -- : Eric S Fraga via Emacs 28.0.50, Org release_9.4.6-577-gf76d4d : Latest paper written in org: https://arxiv.org/abs/2106.05096
