org-table-eval-formula for rows?

org-table-eval-formula for rows?

[Uwe Brauer]

Hi

I know it is perfectly possible to have org-table-eval-formula for
columns, however sometimes I have tables with very many columns that are
difficult to read and even org-table-toggle-column-width does not help.


That is why I would like to transpose the table but then there seems no
equivalent of org-table-eval-formula for rows?

I can only perform such operation of a cell as in the following example

| result1 | result2 |
|---------+---------|
|      14 |       5 |
|       3 |       5 |
|       4 |      19 |
|       6 |       3 |
|---------+---------|
|      27 |         |
#+TBLFM: @6$1=vsum(@I$1..@II$1)

But I would like to get the elements of the second column
*automatically* summed up as in the case of columns.

Any idea how to achieve that?

Thanks and regards

Uwe Brauer 

[SOLVED] (was: org-table-eval-formula for rows?)

[Uwe Brauer]

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

>>> "UB" == Uwe Brauer <oub@mat.ucm.es> writes:

> Hi

> I know it is perfectly possible to have org-table-eval-formula for
> columns, however sometimes I have tables with very many columns that are
> difficult to read and even org-table-toggle-column-width does not help.


> That is why I would like to transpose the table but then there seems no
> equivalent of org-table-eval-formula for rows?

> I can only perform such operation of a cell as in the following example

> | result1 | result2 |
> |---------+---------|
> |      14 |       5 |
> |       3 |       5 |
> |       4 |      19 |
> |       6 |       3 |
> |---------+---------|
> |      27 |         |

> #+TBLFM: @6$1=vsum(@I$1..@II$1)

I did not think when I wrote this

| result1 | result2 | result3 |
|---------+---------+---------|
|      14 |       5 |       1 |
|       3 |       5 |       3 |
|       4 |      19 |       4 |
|       6 |       3 |       8 |
|---------+---------+---------|
|      27 |      32 |      16 |
#+TBLFM: @6=vsum(@I..@II)

Is the solution, of course

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

insert @6=vsum(@I..@II) interactively HOWTO?

[Uwe Brauer]

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

>>> "UB" == Uwe Brauer <oub@mat.ucm.es> writes:

>>> "UB" == Uwe Brauer <oub@mat.ucm.es> writes:
>> Hi



> | result1 | result2 | result3 |
> |---------+---------+---------|
> |      14 |       5 |       1 |
> |       3 |       5 |       3 |
> |       4 |      19 |       4 |
> |       6 |       3 |       8 |
> |---------+---------+---------|
> |      27 |      32 |      16 |

> #+TBLFM: @6=vsum(@I..@II)

Why can't I insert this interactively?


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