|
From: | Uwe Brauer |
Subject: | org-table-transpose-table-at-point does not convert formulas |
Date: | Fri, 06 Oct 2023 14:36:56 +0200 |
User-agent: | Gnus/5.13 (Gnus v5.13) Emacs/29.0.50 (gnu/linux) |
Hi Starting with this #+begin_src | pos | rango | weight | |-----+-------+--------| | 23 | 329 | 307 | | 71 | 329 | 259 | | 77 | 333 | 257 | | 58 | 333 | 276 | | 155 | 310 | 156 | | 164 | 325 | 162 | | 203 | 330 | 128 | #+TBLFM: $3=($2+1)-$1 #+end_src org-table-transpose-table-at-point leads to #+begin_src | pos | 23 | 71 | 77 | 58 | 155 | 164 | 203 | | rango | 329 | 329 | 333 | 333 | 310 | 325 | 330 | | weight | 307 | 259 | 257 | 276 | 156 | 162 | 128 | #+TBLFM: $3=($2+1)-$1 #+end_src However the correct formula should have been #+begin_src |-------+-----+-----+-----+-----+-----+-----+-----| | pos | 23 | 71 | 77 | 58 | 155 | 164 | 203 | | rango | 329 | 329 | 333 | 333 | 310 | 325 | 330 | | peso | 307 | 259 | 257 | 276 | 156 | 162 | 128 | #+TBLFM: @4$2..@4$13=@3+1-@2 #+end_src Does there exist such a command (Scalc and I presume excel allow to transpose a table and convert the corresponding formula) Thanks and regards Uwe Brauer -- Warning: Content may be disturbing to some audiences I strongly condemn Putin's war of aggression against Ukraine. I support to deliver weapons to Ukraine's military. I support the NATO membership of Ukraine. I support the EU membership of Ukraine. https://addons.thunderbird.net/en-US/thunderbird/addon/gmail-conversation-view/
[Prev in Thread] | Current Thread | [Next in Thread] |