Re: how to add a range of columns

[Eric S Fraga <e.fraga@ucl.ac.uk>]

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