[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [O] TABLES: Remove/add cell
From: |
Michael Brand |
Subject: |
Re: [O] TABLES: Remove/add cell |
Date: |
Fri, 30 Sep 2011 21:06:32 +0200 |
Oh, and there is a much easier solution, probably the easiest:
Transpose the table with this
http://orgmode.org/worg/org-hacks.html#sec-1-3-1
If the section numbering changed in the meantime: look for "Transpose
tables (Juan Pechiar)"
and split it into two (or three) tables:
| a | b | c | d |
| 1 | 3 | 4 | |
(| e | f | g | h |)
Then you can use the very convenient editing functions of Org table on
the second part of the table, join the parts together and transpose
again.
Michael
2011/9/30 Michael Brand <address@hidden>:
> Ehm - it is doable, but not by editing commands from Org table. Only
> with several rectangular edits or an Org table formula with a few
> tricks and a temporary column to be removed afterward. Probably not as
> comfortable as you have expected:
>
> - insert row in only one column
> start with:
> | a | 1 | |
> | b | 3 | |
> | c | 4 | |
> | d | | |
>
> | a | 1 | 1 |
> | b | 3 | |
> | c | 4 | 3 |
> | d | | 4 |
> #+TBLFM: @1$3=$-1::@3$3..@>$3=subscr(@2$2..@>>$2, @# - 2)
>
> - remove again
> start with:
> | a | 1 | |
> | b | | |
> | c | 3 | |
> | d | 4 | |
>
> | a | 1 | 1 |
> | b | | 3 |
> | c | 3 | 4 |
> | d | 4 | |
> #+TBLFM: @1$3=$-1::@2$3..@>>$3=subscr(@3$2..@>$2, @# - 1)
>
> See the Calc manual for "subscr" and the Org manual for "@#" and the rest.
>
> If it does not work (e. g. org-version 6.33) then upgrade.