[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: how to add a range of columns
From: |
Eric S Fraga |
Subject: |
Re: how to add a range of columns |
Date: |
Fri, 02 Jul 2021 16:10:15 +0100 |
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
- how to add a range of columns, Uwe Brauer, 2021/07/02
- Re: how to add a range of columns, Eric S Fraga, 2021/07/02
- Re: how to add a range of columns, Uwe Brauer, 2021/07/02
- Re: how to add a range of columns, Eric S Fraga, 2021/07/02
- Re: how to add a range of columns, Uwe Brauer, 2021/07/02
- Re: how to add a range of columns, Eric S Fraga, 2021/07/02
- Re: how to add a range of columns, Uwe Brauer, 2021/07/02
- Re: how to add a range of columns,
Eric S Fraga <=
- Re: how to add a range of columns, Uwe Brauer, 2021/07/02
- Re: how to add a range of columns, Eric S Fraga, 2021/07/03
- Re: how to add a range of columns, Uwe Brauer, 2021/07/04