Re: how to add a range of columns

[Uwe Brauer <oub@mat.ucm.es>]

[-- Attachment #1: Type: text/plain, Size: 2868 bytes --]

>>> "ESF" == Eric S Fraga <e.fraga@ucl.ac.uk> writes:

> 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

Thanks, I thought of that 

#+begin_src elisp
#+Name: check3
  |   | User1 | User2 | Result |
  |---+-------+-------+--------|
  |   |     1 |     3 | 4      |
  |   |     4 |     8 | 12     |
  |   |    10 |     3 | 13     |
  |---+-------+-------+--------|
  | / |     7 |     9 |        |
#+TBLFM: $4=$2+$3
#+end_src
which is a bit the antipode of your approach.

It just occurred to me that this approach has its limitations, let's go
step further 

#+begin_src elisp
#+Name: check2
  | ! | User1 | User2 | Result | New | Actual |
  |---+-------+-------+--------+-----+--------|
  | # |     1 |     3 |      4 |   6 |        |
  | # |     4 |     8 |     12 |   9 |        |
  | # |    10 |     3 |     13 |  10 |        |
  |---+-------+-------+--------+-----+--------|
  |   |     7 |     9 |        |     |        |
#+TBLFM: $4=$User1+$User2
#+end_src


Now I want to add also result and new, but only the first two rows, the
only way to do it seems to be your original approach.


#+begin_src elisp

#+Name: check2
  | ! | User1 | User2 | Result | New | Actual |
  |---+-------+-------+--------+-----+--------|
  | # |     1 |     3 |      4 |   6 |     10 |
  | # |     4 |     8 |     12 |   9 |     21 |
  | # |    10 |     3 |     13 |  10 |        |
  |---+-------+-------+--------+-----+--------|
  |   |     7 |     9 |        |     |        |
#+TBLFM: $4=$User1+$User2::@<<$6..@>>>$6=$4+$5
#+end_src

Regards

Uwe 

[-- Attachment #2: smime.p7s --]
[-- Type: application/pkcs7-signature, Size: 5673 bytes --]