* 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 public 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).