insert cell inside an org-mode table?

insert cell inside an org-mode table?

[Sharon Kimble]

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


I maintain my 'DrugFacts' website in mediawiki. I write my article in
org-mode, export to mediawiki, correct the citations, then cut and paste
into my mediawiki page. And it all works very well.

But the front-page is a right swine! Here is the first two rows of my mediawiki front-page -

--8<---------------cut here---------------start------------->8---
{| <!-- class="wikitable" -->
| '''Illegal'''
| '''Category's'''
| '''Legal'''
| '''Prescription only'''
| '''Substitute'''
| '''Others'''
|-
|* [[Amphetamines]]
|* [[:Category:Anaesthetics|Anaesthetics]]
|* [[Alcohol]]
|* [[Alprazolam]]
|* [[Buprenorphine]]
|* [[Flumazenil]]
|-
--8<---------------cut here---------------end--------------->8---

And because writing mediawiki tables leads to brain damage, and a desire
to consume 6 pints of beer as the world is going to end in ten minutes,
according to Douglas Adams and Ford Prefect, I'm intending to create the
table in org-mode and then export to mediawiki, correct as necessary,
and upload. Which brings me to my question.

Is it possible to insert a cell *inside* an org-mode table please, and
auto-shuffle other rows/columns about to fit? According to the 'Table'
menu in emacs, there isn't a way of doing it, and neither does the
org-mode manual say that it can be done. But perhaps other people have
found a way of doing it please?

Hopefully thanks
Sharon.
-- 
A taste of linux = http://www.sharons.org.uk
TGmeds = http://www.tgmeds.org.uk
DrugFacts = https://www.drugfacts.org.uk  
Debian 9.0, fluxbox 1.3.5-2, emacs 25.1.1, org-mode 9.0.7

[-- Attachment #2: signature.asc --]
[-- Type: application/pgp-signature, Size: 832 bytes --]

Re: insert cell inside an org-mode table?

[John Kitchin]

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

I don't totally understand what you want to do. You can insert a row or
column into a table.

    org-table-insert-column
    org-table-insert-row

Are you trying to do something different than that?

John

-----------------------------------
Professor John Kitchin
Doherty Hall A207F
Department of Chemical Engineering
Carnegie Mellon University
Pittsburgh, PA 15213
412-268-7803
@johnkitchin
http://kitchingroup.cheme.cmu.edu


On Wed, Jun 7, 2017 at 6:31 AM, Sharon Kimble <boudiccas@skimble.plus.com>
wrote:

>
> I maintain my 'DrugFacts' website in mediawiki. I write my article in
> org-mode, export to mediawiki, correct the citations, then cut and paste
> into my mediawiki page. And it all works very well.
>
> But the front-page is a right swine! Here is the first two rows of my
> mediawiki front-page -
>
> --8<---------------cut here---------------start------------->8---
> {| <!-- class="wikitable" -->
> | '''Illegal'''
> | '''Category's'''
> | '''Legal'''
> | '''Prescription only'''
> | '''Substitute'''
> | '''Others'''
> |-
> |* [[Amphetamines]]
> |* [[:Category:Anaesthetics|Anaesthetics]]
> |* [[Alcohol]]
> |* [[Alprazolam]]
> |* [[Buprenorphine]]
> |* [[Flumazenil]]
> |-
> --8<---------------cut here---------------end--------------->8---
>
> And because writing mediawiki tables leads to brain damage, and a desire
> to consume 6 pints of beer as the world is going to end in ten minutes,
> according to Douglas Adams and Ford Prefect, I'm intending to create the
> table in org-mode and then export to mediawiki, correct as necessary,
> and upload. Which brings me to my question.
>
> Is it possible to insert a cell *inside* an org-mode table please, and
> auto-shuffle other rows/columns about to fit? According to the 'Table'
> menu in emacs, there isn't a way of doing it, and neither does the
> org-mode manual say that it can be done. But perhaps other people have
> found a way of doing it please?
>
> Hopefully thanks
> Sharon.
> --
> A taste of linux = http://www.sharons.org.uk
> TGmeds = http://www.tgmeds.org.uk
> DrugFacts = https://www.drugfacts.org.uk
> Debian 9.0, fluxbox 1.3.5-2, emacs 25.1.1, org-mode 9.0.7
>

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

Re: insert cell inside an org-mode table?

[Sharon Kimble]

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

John Kitchin <jkitchin@andrew.cmu.edu> writes:

> I don't totally understand what you want to do. You can insert a row or column into a table.
>
>     org-table-insert-column
>     org-table-insert-row
>
> Are you trying to do something different than that?

Yes, I would like to just insert a single cell into a place within the
table, and then be able to adjust all other rows and cells around it, so
that it appears no different from any of the original cells. So that its
assimilated into the table as a whole.

Does this help explain what I want to do?

Thanks
Sharon.

>
> John
>
> -----------------------------------
> Professor John Kitchin 
> Doherty Hall A207F
> Department of Chemical Engineering
> Carnegie Mellon University
> Pittsburgh, PA 15213
> 412-268-7803
> @johnkitchin
> http://kitchingroup.cheme.cmu.edu
>
> On Wed, Jun 7, 2017 at 6:31 AM, Sharon Kimble <boudiccas@skimble.plus.com> wrote:
>
>     I maintain my 'DrugFacts' website in mediawiki. I write my article in
>     org-mode, export to mediawiki, correct the citations, then cut and paste
>     into my mediawiki page. And it all works very well.
>    
>     But the front-page is a right swine! Here is the first two rows of my mediawiki front-page -
>    
>     --8<---------------cut here---------------start------------->8---
>     {| <!-- class="wikitable" -->
>     | '''Illegal'''
>     | '''Category's'''
>     | '''Legal'''
>     | '''Prescription only'''
>     | '''Substitute'''
>     | '''Others'''
>     |-
>     |* [[Amphetamines]]
>     |* [[:Category:Anaesthetics|Anaesthetics]]
>     |* [[Alcohol]]
>     |* [[Alprazolam]]
>     |* [[Buprenorphine]]
>     |* [[Flumazenil]]
>     |-
>     --8<---------------cut here---------------end--------------->8---
>    
>     And because writing mediawiki tables leads to brain damage, and a desire
>     to consume 6 pints of beer as the world is going to end in ten minutes,
>     according to Douglas Adams and Ford Prefect, I'm intending to create the
>     table in org-mode and then export to mediawiki, correct as necessary,
>     and upload. Which brings me to my question.
>    
>     Is it possible to insert a cell *inside* an org-mode table please, and
>     auto-shuffle other rows/columns about to fit? According to the 'Table'
>     menu in emacs, there isn't a way of doing it, and neither does the
>     org-mode manual say that it can be done. But perhaps other people have
>     found a way of doing it please?
>    
>     Hopefully thanks
>     Sharon.
>     --
>     A taste of linux = http://www.sharons.org.uk
>     TGmeds = http://www.tgmeds.org.uk
>     DrugFacts = https://www.drugfacts.org.uk
>     Debian 9.0, fluxbox 1.3.5-2, emacs 25.1.1, org-mode 9.0.7
>

-- 
A taste of linux = http://www.sharons.org.uk
TGmeds = http://www.tgmeds.org.uk
DrugFacts = https://www.drugfacts.org.uk  
Debian 9.0, fluxbox 1.3.5-2, emacs 25.1.1, org-mode 9.0.7

[-- Attachment #2: signature.asc --]
[-- Type: application/pgp-signature, Size: 832 bytes --]

Re: insert cell inside an org-mode table?

[John Kitchin]

Not really. Could you give an example of before and after?

For example if you are in the middle of a row and want to insert a cell
in that row, what should happen? Should the just that row get longer? Or
should you just add a new column? How should the cells around it shift?



Sharon Kimble writes:

> John Kitchin <jkitchin@andrew.cmu.edu> writes:
>
>> I don't totally understand what you want to do. You can insert a row or column into a table.
>>
>>   org-table-insert-column
>>   org-table-insert-row
>>
>> Are you trying to do something different than that?
>
> Yes, I would like to just insert a single cell into a place within the
> table, and then be able to adjust all other rows and cells around it, so
> that it appears no different from any of the original cells. So that its
> assimilated into the table as a whole.
>
> Does this help explain what I want to do?
>
> Thanks
> Sharon.
>
>>
>> John
>>
>> -----------------------------------
>> Professor John Kitchin
>> Doherty Hall A207F
>> Department of Chemical Engineering
>> Carnegie Mellon University
>> Pittsburgh, PA 15213
>> 412-268-7803
>> @johnkitchin
>> http://kitchingroup.cheme.cmu.edu
>>
>> On Wed, Jun 7, 2017 at 6:31 AM, Sharon Kimble <boudiccas@skimble.plus.com> wrote:
>>
>>     I maintain my 'DrugFacts' website in mediawiki. I write my article in
>>     org-mode, export to mediawiki, correct the citations, then cut and paste
>>     into my mediawiki page. And it all works very well.
>>
>>     But the front-page is a right swine! Here is the first two rows of my mediawiki front-page -
>>
>>     --8<---------------cut here---------------start------------->8---
>>     {| <!-- class="wikitable" -->
>>     | '''Illegal'''
>>     | '''Category's'''
>>     | '''Legal'''
>>     | '''Prescription only'''
>>     | '''Substitute'''
>>     | '''Others'''
>>     |-
>>     |* [[Amphetamines]]
>>     |* [[:Category:Anaesthetics|Anaesthetics]]
>>     |* [[Alcohol]]
>>     |* [[Alprazolam]]
>>     |* [[Buprenorphine]]
>>     |* [[Flumazenil]]
>>     |-
>>     --8<---------------cut here---------------end--------------->8---
>>
>>     And because writing mediawiki tables leads to brain damage, and a desire
>>     to consume 6 pints of beer as the world is going to end in ten minutes,
>>     according to Douglas Adams and Ford Prefect, I'm intending to create the
>>     table in org-mode and then export to mediawiki, correct as necessary,
>>     and upload. Which brings me to my question.
>>
>>     Is it possible to insert a cell *inside* an org-mode table please, and
>>     auto-shuffle other rows/columns about to fit? According to the 'Table'
>>     menu in emacs, there isn't a way of doing it, and neither does the
>>     org-mode manual say that it can be done. But perhaps other people have
>>     found a way of doing it please?
>>
>>     Hopefully thanks
>>     Sharon.
>>     --
>>     A taste of linux = http://www.sharons.org.uk
>>     TGmeds = http://www.tgmeds.org.uk
>>     DrugFacts = https://www.drugfacts.org.uk
>>     Debian 9.0, fluxbox 1.3.5-2, emacs 25.1.1, org-mode 9.0.7
>>


--
Professor John Kitchin
Doherty Hall A207F
Department of Chemical Engineering
Carnegie Mellon University
Pittsburgh, PA 15213
412-268-7803
@johnkitchin
http://kitchingroup.cheme.cmu.edu

Re: insert cell inside an org-mode table?

[Sharon Kimble]

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

John Kitchin <jkitchin@andrew.cmu.edu> writes:

> Not really. Could you give an example of before and after?
>
> For example if you are in the middle of a row and want to insert a cell
> in that row, what should happen? Should the just that row get longer? Or
> should you just add a new column? How should the cells around it shift?

Okay, imagine that you have this table -

| fruit  | one        | two        |
|--------+------------+------------|
| pear   | orange     | grape      |
| banana | grapefruit | satsuma    |
| tomato | potato     | clementine |

And you discover that you've missed out apples and you want to put them
where 'grapefruit' currently is, I would like the following to happen -

| fruit  | one        | two        |
|--------+------------+------------|
| pear   | orange     | grape      |
| banana | apple      | satsuma    |
| tomato | grapefruit | clementine |
|        | potato     |            |

Where the rest of the column gets shifted downwards by one cell.

Now that is a very simplistic table, the one that I'm hoping to build
will be 6 columns by about 60 rows, so having the ability to shift rows
downwards from inserting a cell would be vital to its successful usage.

Thanks
Sharon.

>
> Sharon Kimble writes:
>
>> John Kitchin <jkitchin@andrew.cmu.edu> writes:
>>
>>> I don't totally understand what you want to do. You can insert a row or column into a table.
>>>
>>>   org-table-insert-column
>>>   org-table-insert-row
>>>
>>> Are you trying to do something different than that?
>>
>> Yes, I would like to just insert a single cell into a place within the
>> table, and then be able to adjust all other rows and cells around it, so
>> that it appears no different from any of the original cells. So that its
>> assimilated into the table as a whole.
>>
>> Does this help explain what I want to do?
>>
>> Thanks
>> Sharon.
>>
>>>
>>> John
>>>
>>> -----------------------------------
>>> Professor John Kitchin
>>> Doherty Hall A207F
>>> Department of Chemical Engineering
>>> Carnegie Mellon University
>>> Pittsburgh, PA 15213
>>> 412-268-7803
>>> @johnkitchin
>>> http://kitchingroup.cheme.cmu.edu
>>>
>>> On Wed, Jun 7, 2017 at 6:31 AM, Sharon Kimble <boudiccas@skimble.plus.com> wrote:
>>>
>>>     I maintain my 'DrugFacts' website in mediawiki. I write my article in
>>>     org-mode, export to mediawiki, correct the citations, then cut and paste
>>>     into my mediawiki page. And it all works very well.
>>>
>>>     But the front-page is a right swine! Here is the first two rows of my mediawiki front-page -
>>>
>>>     --8<---------------cut here---------------start------------->8---
>>>     {| <!-- class="wikitable" -->
>>>     | '''Illegal'''
>>>     | '''Category's'''
>>>     | '''Legal'''
>>>     | '''Prescription only'''
>>>     | '''Substitute'''
>>>     | '''Others'''
>>>     |-
>>>     |* [[Amphetamines]]
>>>     |* [[:Category:Anaesthetics|Anaesthetics]]
>>>     |* [[Alcohol]]
>>>     |* [[Alprazolam]]
>>>     |* [[Buprenorphine]]
>>>     |* [[Flumazenil]]
>>>     |-
>>>     --8<---------------cut here---------------end--------------->8---
>>>
>>>     And because writing mediawiki tables leads to brain damage, and a desire
>>>     to consume 6 pints of beer as the world is going to end in ten minutes,
>>>     according to Douglas Adams and Ford Prefect, I'm intending to create the
>>>     table in org-mode and then export to mediawiki, correct as necessary,
>>>     and upload. Which brings me to my question.
>>>
>>>     Is it possible to insert a cell *inside* an org-mode table please, and
>>>     auto-shuffle other rows/columns about to fit? According to the 'Table'
>>>     menu in emacs, there isn't a way of doing it, and neither does the
>>>     org-mode manual say that it can be done. But perhaps other people have
>>>     found a way of doing it please?
>>>
>>>     Hopefully thanks
>>>     Sharon.
>>>     --
>>>     A taste of linux = http://www.sharons.org.uk
>>>     TGmeds = http://www.tgmeds.org.uk
>>>     DrugFacts = https://www.drugfacts.org.uk
>>>     Debian 9.0, fluxbox 1.3.5-2, emacs 25.1.1, org-mode 9.0.7
>>>
>
>
> --
> Professor John Kitchin
> Doherty Hall A207F
> Department of Chemical Engineering
> Carnegie Mellon University
> Pittsburgh, PA 15213
> 412-268-7803
> @johnkitchin
> http://kitchingroup.cheme.cmu.edu

-- 
A taste of linux = http://www.sharons.org.uk
TGmeds = http://www.tgmeds.org.uk
DrugFacts = https://www.drugfacts.org.uk  
Debian 9.0, fluxbox 1.3.5-2, emacs 25.1.1, org-mode 9.0.7

[-- Attachment #2: signature.asc --]
[-- Type: application/pgp-signature, Size: 832 bytes --]

Re: insert cell inside an org-mode table?

[Michael Brand]

Hi Sharon

On Thu, Jun 8, 2017 at 4:21 PM, Sharon Kimble
<boudiccas@skimble.plus.com> wrote:

> Okay, imagine that you have this table -
>
> | fruit  | one        | two        |
> |--------+------------+------------|
> | pear   | orange     | grape      |
> | banana | grapefruit | satsuma    |
> | tomato | potato     | clementine |
>
> And you discover that you've missed out apples and you want to put them
> where 'grapefruit' currently is, I would like the following to happen -
>
> | fruit  | one        | two        |
> |--------+------------+------------|
> | pear   | orange     | grape      |
> | banana | apple      | satsuma    |
> | tomato | grapefruit | clementine |
> |        | potato     |            |
>
> Where the rest of the column gets shifted downwards by one cell.
>
> Now that is a very simplistic table, the one that I'm hoping to build
> will be 6 columns by about 60 rows, so having the ability to shift rows
> downwards from inserting a cell would be vital to its successful usage.

This is not built-in but you can look here at the last example:
"Rearrange one or more field within the same row or column"
http://orgmode.org/worg/org-hacks.html#field-same-row-or-column

Michael

Re: insert cell inside an org-mode table?

[John Kitchin]

This looks like exactly the solution Sharon is looking for! What a great
community we have that it even already exists! Thanks for pointing to it.

Michael Brand writes:

> Hi Sharon
>
> On Thu, Jun 8, 2017 at 4:21 PM, Sharon Kimble
> <boudiccas@skimble.plus.com> wrote:
>
>> Okay, imagine that you have this table -
>>
>> | fruit  | one        | two        |
>> |--------+------------+------------|
>> | pear   | orange     | grape      |
>> | banana | grapefruit | satsuma    |
>> | tomato | potato     | clementine |
>>
>> And you discover that you've missed out apples and you want to put them
>> where 'grapefruit' currently is, I would like the following to happen -
>>
>> | fruit  | one        | two        |
>> |--------+------------+------------|
>> | pear   | orange     | grape      |
>> | banana | apple      | satsuma    |
>> | tomato | grapefruit | clementine |
>> |        | potato     |            |
>>
>> Where the rest of the column gets shifted downwards by one cell.
>>
>> Now that is a very simplistic table, the one that I'm hoping to build
>> will be 6 columns by about 60 rows, so having the ability to shift rows
>> downwards from inserting a cell would be vital to its successful usage.
>
> This is not built-in but you can look here at the last example:
> "Rearrange one or more field within the same row or column"
> http://orgmode.org/worg/org-hacks.html#field-same-row-or-column
>
> Michael


--
Professor John Kitchin
Doherty Hall A207F
Department of Chemical Engineering
Carnegie Mellon University
Pittsburgh, PA 15213
412-268-7803
@johnkitchin
http://kitchingroup.cheme.cmu.edu