>>> "UB" == Uwe Brauer 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/