emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed
* org-table-eval-formula for rows?
@ 2021-06-16  7:12 Uwe Brauer
  2021-06-16  9:35 ` [SOLVED] (was: org-table-eval-formula for rows?) Uwe Brauer
  0 siblings, 1 reply; 3+ messages in thread
From: Uwe Brauer @ 2021-06-16  7:12 UTC (permalink / raw)
  To: emacs-orgmode



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 



^ permalink raw reply	[flat|nested] 3+ messages in thread

* [SOLVED] (was: org-table-eval-formula for rows?)
  2021-06-16  7:12 org-table-eval-formula for rows? Uwe Brauer
@ 2021-06-16  9:35 ` Uwe Brauer
  2021-06-16 11:40   ` insert @6=vsum(@I..@II) interactively HOWTO? Uwe Brauer
  0 siblings, 1 reply; 3+ messages in thread
From: Uwe Brauer @ 2021-06-16  9:35 UTC (permalink / raw)
  To: emacs-orgmode

[-- 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 --]

^ permalink raw reply	[flat|nested] 3+ messages in thread

* insert @6=vsum(@I..@II) interactively HOWTO?
  2021-06-16  9:35 ` [SOLVED] (was: org-table-eval-formula for rows?) Uwe Brauer
@ 2021-06-16 11:40   ` Uwe Brauer
  0 siblings, 0 replies; 3+ messages in thread
From: Uwe Brauer @ 2021-06-16 11:40 UTC (permalink / raw)
  To: emacs-orgmode

[-- 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 --]

^ permalink raw reply	[flat|nested] 3+ messages in thread

end of thread, other threads:[~2021-06-16 11:45 UTC | newest]

Thread overview: 3+ messages (download: mbox.gz / follow: Atom feed)
-- links below jump to the message on this page --
2021-06-16  7:12 org-table-eval-formula for rows? Uwe Brauer
2021-06-16  9:35 ` [SOLVED] (was: org-table-eval-formula for rows?) Uwe Brauer
2021-06-16 11:40   ` insert @6=vsum(@I..@II) interactively HOWTO? Uwe Brauer

Code repositories for project(s) associated with this inbox:

	https://git.savannah.gnu.org/cgit/emacs/org-mode.git

This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).