TABLES: Remove/add cell

TABLES: Remove/add cell

[Gustav Wikström]

[-- Attachment #1: Type: text/plain, Size: 450 bytes --]

Hello!

How do I add or remove a single cell in a table?

Example:
I have the following table:
|        1 |        1 |
|        2 |        3 |
|        3 |        4 |
|        4 |          |

Now I want to add an empty cell in @2$2 (below the heading) and thus move
the following cells in column 2 down one step.

After:
|        1 |        1 |
|        2 |          |
|        3 |        3 |
|        4 |        4 |

Is this doable?

Regards
Gustav

[-- Attachment #2: Type: text/html, Size: 1654 bytes --]

Re: TABLES: Remove/add cell

[Michael Brand]

Hi Gustav

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.

Michael

2011/9/30 Gustav Wikström <gustav.erik@gmail.com>:
> How do I add or remove a single cell in a table?
> Example:
> I have the following table:
> |        1 |        1 |
> |        2 |        3 |
> |        3 |        4 |
> |        4 |          |
> Now I want to add an empty cell in @2$2 (below the heading) and thus move
> the following cells in column 2 down one step.
> After:
> |        1 |        1 |
> |        2 |          |
> |        3 |        3 |
> |        4 |        4 |
> Is this doable?

Re: TABLES: Remove/add cell

[brian powell]

* May want to turn org-mode/table off temporarily (or maybe it will
just make it easier) then you can do the "rectangle edits" michael was
referring to:
** Go to the point just to the right of the 4.
** C@ ---marks the point.
** Go to the 3.
** Cxrk
** Go to "@2$2"--i.e. where the "4" used to be.
** Cxry
* Emacs OrgMode makes all of this easier since it lines everything up
for you by "covering down" the columns (org-table-align)---making all
the cells easily edited by the usual "rectangle-killing" and
"rectangle-yanking" methods.
** The method above can be generalized for editing OrgMode tables
regardless of the number of symbols in the cells--since OrgMode aligns
them for you; and, EMACS is restricted only by the amount of RAM in
your computer.
*** Also, if you want to edit gygabyte size files, using similar
methods, I highly recommend QEMACS.

Re: TABLES: Remove/add cell

[Michael Brand]

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 <michael.ch.brand@gmail.com>:
> 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.

Re: TABLES: Remove/add cell

[Gustav Wikström]

[-- Attachment #1: Type: text/plain, Size: 1321 bytes --]

This is similar to the way I've done it before. It makes it cumbersome if
there are many lines below the cell that is to be inserted though..

It would be nice to have as a function that inserts or deletes a cell in the
same way as one can insert and delete rows and columns. Maybe as a prefix
to M-S-<left/right> and M-S-<up/down> ?

/Gustav

On Fri, Sep 30, 2011 at 8:50 PM, brian powell <briangpowellms@gmail.com>wrote:

> * May want to turn org-mode/table off temporarily (or maybe it will
> just make it easier) then you can do the "rectangle edits" michael was
> referring to:
> ** Go to the point just to the right of the 4.
> ** C@ ---marks the point.
> ** Go to the 3.
> ** Cxrk
> ** Go to "@2$2"--i.e. where the "4" used to be.
> ** Cxry
> * Emacs OrgMode makes all of this easier since it lines everything up
> for you by "covering down" the columns (org-table-align)---making all
> the cells easily edited by the usual "rectangle-killing" and
> "rectangle-yanking" methods.
> ** The method above can be generalized for editing OrgMode tables
> regardless of the number of symbols in the cells--since OrgMode aligns
> them for you; and, EMACS is restricted only by the amount of RAM in
> your computer.
> *** Also, if you want to edit gygabyte size files, using similar
> methods, I highly recommend QEMACS.
>

[-- Attachment #2: Type: text/html, Size: 1748 bytes --]

Re: TABLES: Remove/add cell

[suvayu ali]

2011/9/30 Michael Brand <michael.ch.brand@gmail.com>:
> 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.

There are some org-table specific rectangle edit commands that should
make it easier. Cut the cells with org-table-cut-region, and paste by
org-table-paste-rectangle.

Hope this helps.

-- 
Suvayu

Open source is the future. It sets us free.

Re: TABLES: Remove/add cell

[Michael Brand]

Hi Gustav and Daniel

2011/9/30 Gustav Wikström <gustav.erik@gmail.com>:
> How do I add or remove a single cell in a table?
> Example:
> I have the following table:
> |        1 |        1 |
> |        2 |        3 |
> |        3 |        4 |
> |        4 |          |
> Now I want to add an empty cell in @2$2 (below the heading) and thus move
> the following cells in column 2 down one step.
> After:
> |        1 |        1 |
> |        2 |          |
> |        3 |        3 |
> |        4 |        4 |

2011/9/30 Michael Brand <michael.ch.brand@gmail.com>:
> [...] transpose [...]
> 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,

to move the empty field in front of "3"

| a | b | c | d |

| 1 |  | 3 | 4 |

| e | f | g | h |

> join the parts together

| a | b | c | d |
| 1 |   | 3 | 4 |
| e | f | g | h |

> and transpose again.

By coincidence just today I had the same need to move or rotate
columns left/right, without affecting the other rows above and below.
Because I need this repeatedly I wrote two in-row functions derived
from org-table-move-column, without the need anymore of splitting and
joining the table like above.

It supports only the direction left/right. The direction up/down
Gustav asked for would be harder to implement but as a workaround you
can still transpose
http://orgmode.org/worg/org-hacks.html#transpose-table
and use the in-row left/right.

from another thread:
On Mon, Nov 21, 2011 at 14:31, Daniel Martins <danielemc@gmail.com> wrote:
> The feature of remove/add cell is quite important. Should be a feature
> request.

If I understand right and only for left/right, the in-row functions
cover that too:
- remove: first blank the field with "C-c Space"
  (org-table-blank-field) and then rotate in-row left
- add: rotate in-row right and replace the field content, before this
  step append new columns if required

For more see
"Change the column sequence in one row only" on Worg hacks:
http://orgmode.org/worg/org-hacks.html#column-sequence-in-row

Michael

Re: TABLES: Remove/add cell

[Daniel Martins]

Great Michael!!!

One vote for being part of the core of org-mode!!! (with org-table
rtanspose as well)

Daniel

2011/11/23 Michael Brand <michael.ch.brand@gmail.com>:
> Hi Gustav and Daniel
>
> 2011/9/30 Gustav Wikström <gustav.erik@gmail.com>:
>> How do I add or remove a single cell in a table?
>> Example:
>> I have the following table:
>> |        1 |        1 |
>> |        2 |        3 |
>> |        3 |        4 |
>> |        4 |          |
>> Now I want to add an empty cell in @2$2 (below the heading) and thus move
>> the following cells in column 2 down one step.
>> After:
>> |        1 |        1 |
>> |        2 |          |
>> |        3 |        3 |
>> |        4 |        4 |
>
> 2011/9/30 Michael Brand <michael.ch.brand@gmail.com>:
>> [...] transpose [...]
>> 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,
>
> to move the empty field in front of "3"
>
> | a | b | c | d |
>
> | 1 |  | 3 | 4 |
>
> | e | f | g | h |
>
>> join the parts together
>
> | a | b | c | d |
> | 1 |   | 3 | 4 |
> | e | f | g | h |
>
>> and transpose again.
>
> By coincidence just today I had the same need to move or rotate
> columns left/right, without affecting the other rows above and below.
> Because I need this repeatedly I wrote two in-row functions derived
> from org-table-move-column, without the need anymore of splitting and
> joining the table like above.
>
> It supports only the direction left/right. The direction up/down
> Gustav asked for would be harder to implement but as a workaround you
> can still transpose
> http://orgmode.org/worg/org-hacks.html#transpose-table
> and use the in-row left/right.
>
> from another thread:
> On Mon, Nov 21, 2011 at 14:31, Daniel Martins <danielemc@gmail.com> wrote:
>> The feature of remove/add cell is quite important. Should be a feature
>> request.
>
> If I understand right and only for left/right, the in-row functions
> cover that too:
> - remove: first blank the field with "C-c Space"
>  (org-table-blank-field) and then rotate in-row left
> - add: rotate in-row right and replace the field content, before this
>  step append new columns if required
>
> For more see
> "Change the column sequence in one row only" on Worg hacks:
> http://orgmode.org/worg/org-hacks.html#column-sequence-in-row
>
> Michael
>

Re: TABLES: Remove/add cell

[Bastien]

Hi Michael and Daniel,

Daniel Martins <danielemc@gmail.com> writes:

> One vote for being part of the core of org-mode!!! (with org-table
> rtanspose as well)

Yes.  `org-table-transpose-table-at-point' is now part of Org's core.

-- 
 Bastien

Re: TABLES: Remove/add cell

[Bastien]

Hi Michael,

Michael Brand <michael.ch.brand@gmail.com> writes:

> If I understand right and only for left/right, the in-row functions
> cover that too:
> - remove: first blank the field with "C-c Space"
>   (org-table-blank-field) and then rotate in-row left
> - add: rotate in-row right and replace the field content, before this
>   step append new columns if required
>
> For more see
> "Change the column sequence in one row only" on Worg hacks:
> http://orgmode.org/worg/org-hacks.html#column-sequence-in-row

This is great -- would you like to prepare a patch to org-table.el 
adding these feature?  If you can come up with compatible keybindings,
that would be even better.

Thanks a lot in advance!

-- 
 Bastien

Re: TABLES: Remove/add cell

[Achim Gratz]

Bastien <bzg@altern.org> writes:
> Yes.  `org-table-transpose-table-at-point' is now part of Org's core.

There's one thing to take care of, though:

In org-table-transpose-table-at-point:
org-table.el:1774:33:Warning: function `remove-if-not' from cl package called
    at runtime


Regards,
Achim.
-- 
+<[Q+ Matrix-12 WAVE#46+305 Neuron microQkb Andromeda XTk Blofeld]>+

SD adaptations for Waldorf Q V3.00R3 and Q+ V3.54R2:
http://Synth.Stromeko.net/Downloads.html#WaldorfSDada

Re: TABLES: Remove/add cell

[Bastien]

Achim Gratz <Stromeko@nexgo.de> writes:

> There's one thing to take care of, though:
>
> In org-table-transpose-table-at-point:
> org-table.el:1774:33:Warning: function `remove-if-not' from cl package called
>     at runtime

Done.  Thanks for spotting this!

-- 
 Bastien

Re: TABLES: Remove/add cell

[Michael Brand]

Hi Bastien

On Sun, Dec 11, 2011 at 17:42, Bastien <bzg@altern.org> wrote:
> This is great -- would you like to prepare a patch to org-table.el
> adding these feature?  If you can come up with compatible keybindings,
> that would be even better.

Lack of repetitive key binding possibilities was only one of several
reasons (now all listed at the end of the article on Worg) why I
decided to put this only to Worg hacks and not into the Org core.

Michael