[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Solved sort of ] (was: org table how to «convert» column formula into r
From: |
Uwe Brauer |
Subject: |
[Solved sort of ] (was: org table how to «convert» column formula into row formula) |
Date: |
Sat, 30 Sep 2023 14:26:44 +0200 |
User-agent: |
Gnus/5.13 (Gnus v5.13) Emacs/29.0.50 (gnu/linux) |
>>> "UB" == Uwe Brauer <oub@mat.ucm.es> writes:
> Hi
> I have the following table
> | name | pos | rango | weight |
> |------+-----+-------+--------|
> | | 23 | 329 | 307 |
> | | 71 | 329 | 259 |
> | | 77 | 333 | 257 |
> | | 58 | 333 | 276 |
> | | 45 | 329 | 285 |
> | | 47 | 330 | 284 |
> | | 71 | 329 | 259 |
> | | 77 | 333 | 257 |
> | | 77 | 333 | 257 |
> | | 155 | 310 | 156 |
> | | 164 | 325 | 162 |
> | | 203 | 330 | 128 |
> #+TBLFM: $4=($3+1)-$2
> I might be forced to add quite a bit of additional columns to that table
> making it difficult to read. So I thought to transpose the table as
> this, but how can I calculate the last row, using a calc operation.
> | Name | | | | | | | | | | | |
> |
> |--------+-----+-----+-----+-----+-----+-----+-----+-----+-----+-----+-----+-----|
> | pos | 23 | 71 | 77 | 58 | 45 | 47 | 71 | 77 | 77 | 155 | 164 |
> 203 |
> | rango | 329 | 329 | 333 | 333 | 329 | 330 | 329 | 333 | 333 | 310 | 325 |
> 330 |
> | weight | | | | | | | | | | | |
> |
> I tried
It seems that
#+Name: row
| Name | | | | | | | | | | | |
|
|-------+-----+-----+-----+-----+-----+-----+-----+-----+-----+-----+-----+-----|
| pos | 23 | 71 | 77 | 58 | 45 | 47 | 71 | 77 | 77 | 155 | 164 | 203
|
| rango | 329 | 329 | 333 | 333 | 329 | 330 | 329 | 333 | 333 | 310 | 325 | 330
|
| peso | 307 | 259 | 257 | 276 | 285 | 284 | 259 | 257 | 257 | 156 | 162 | 128
|
#+TBLFM: @4$2..@4$13=@3+1-@2
Gives the correct result
--
Warning: Content may be disturbing to some audiences
I strongly condemn Putin's war of aggression against the Ukraine.
I support to deliver weapons to Ukraine's military.
I support the NATO membership of the Ukraine.
I support the EU membership of the Ukraine.
https://addons.thunderbird.net/en-US/thunderbird/addon/gmail-conversation-view/
smime.p7s
Description: S/MIME cryptographic signature