auto incremental columns in table of org-mode?

auto incremental columns in table of org-mode?

[poppyer]

Hi, guys,


I am using orgtbl-mode minor mode, basically as following:

| k |   n | f(n,k) |
|---+-----+--------|
| 1 | 100 |        |
| 2 |     |        |
| 3 |     |        |
|   |     |        |
|   |     |        |
|   |     |        |

My question is how can I fill the k column when I add rows?

cheers,
poppyer

-- 

Re: auto incremental columns in table of org-mode?

[Stefan Reichör]

Hi poppyer!

> Hi, guys,
>
>
> I am using orgtbl-mode minor mode, basically as following:
>
> | k |   n | f(n,k) |
> |---+-----+--------|
> | 1 | 100 |        |
> | 2 |     |        |
> | 3 |     |        |
> |   |     |        |
> |   |     |        |
> |   |     |        |
>
> My question is how can I fill the k column when I add rows?

I would do it via cua rectangles:

C-RET               : start a rectangle
down, down,...      : extend the rectangle selection
M-n                 : run cua-sequence-rectangle
4 RET               : start with 4
RET                 : increment by 1 (default)
RET                 : use default format (%d)

done :-)


Stefan.

-- 
Posted via a free Usenet account from http://www.teranews.com

Re: auto incremental columns in table of org-mode?

[Bastien]

poppyer <poppyer@gmail.com> writes:

> I am using orgtbl-mode minor mode, basically as following:
>
> | k |   n | f(n,k) |
> |---+-----+--------|
> | 1 | 100 |        |
> | 2 |     |        |
> | 3 |     |        |
> |   |     |        |
> |   |     |        |
> |   |     |        |
>
> My question is how can I fill the k column when I add rows?

I would define a formula for this table.

#+TBLFM: $1='(1+ @-1);N

This basically says: for the each cell in the first column, compute the
value of the cell by adding 1 to the value of the cell above.

Use C-c * or C-u C-c to re-compute the values in this column.

-- 
Bastien

Re: auto incremental columns in table of org-mode?

[poppyer]

Bastien <bzg@altern.org> writes:

> poppyer <poppyer@gmail.com> writes:
>
>> I am using orgtbl-mode minor mode, basically as following:
>>
>> | k |   n | f(n,k) |
>> |---+-----+--------|
>> | 1 | 100 |        |
>> | 2 |     |        |
>> | 3 |     |        |
>> |   |     |        |
>> |   |     |        |
>> |   |     |        |
>>
>> My question is how can I fill the k column when I add rows?
>
> I would define a formula for this table.
>
> #+TBLFM: $1='(1+ @-1);N
>
> This basically says: for the each cell in the first column, compute the
> value of the cell by adding 1 to the value of the cell above.

I am using similar $1=@-1+1;N
The problem is, it works at the first time. But every time you use C-u
C-c C-c to update the whole table. The whole $1 column increase by 1.
i.e. "1 2 3 ... " ===> "2 3 4 ..."
Any idea to exclude the first "1" without being updated?

Thanks,
poppyer

>
> Use C-c * or C-u C-c to re-compute the values in this column.

-- 

Re: auto incremental columns in table of org-mode?

[Bastien]

poppyer <poppyer@gmail.com> writes:

>> This basically says: for the each cell in the first column, compute the
>> value of the cell by adding 1 to the value of the cell above.
>
> I am using similar $1=@-1+1;N
                             ^^

(The ;N is not required here, this is for Calc formulas only.)

> The problem is, it works at the first time. But every time you use C-u
> C-c C-c to update the whole table. The whole $1 column increase by 1.
> i.e. "1 2 3 ... " ===> "2 3 4 ..."

Yes, that's a problem.  This is because when looking for a relative
reference, if Org encounters a non-number row, it falls back on the next
row in the same column...  I'll send a bug report to Carsten for this.

> Any idea to exclude the first "1" without being updated?

If you don't really need to compute the first column you can always 
use a dummy macro like this one:

C-a f3 | C-xC-kC-i | | C-j f4

Then use it with C-x e e e e as many times as you want rows...  

HTH,

-- 
Bastien

Re: auto incremental columns in table of org-mode?

[drostekirsten]

On Mar 18, 9:57 pm, poppyer <popp...@gmail.com> wrote:
> Bastien <b...@altern.org> writes:
> > poppyer <popp...@gmail.com> writes:
>
> >> I am using orgtbl-mode minor mode, basically as following:
>
> >> | k |   n | f(n,k) |
> >> |---+-----+--------|
> >> | 1 | 100 |        |
> >> | 2 |     |        |
> >> | 3 |     |        |
> >> |   |     |        |
> >> |   |     |        |
> >> |   |     |        |
>
> >> My question is how can I fill the k column when I add rows?
>
> > I would define a formula for this table.
>
> > #+TBLFM: $1='(1+ @-1);N
>
> > This basically says: for the each cell in the first column, compute the
> > value of the cell by adding 1 to the value of the cell above.
>
> I am using similar $1=@-1+1;N
> The problem is, it works at the first time. But every time you use C-u
> C-c C-c to update the whole table. The whole $1 column increase by 1.
> i.e. "1 2 3 ... " ===> "2 3 4 ..."
> Any idea to exclude the first "1" without being updated?
>

Yes, by defining a field formula for just this field:

#+TBLFM: $1=@-1+1::@2$1=1

Field formulas overrule column formulas.

- Carsten

Re: auto incremental columns in table of org-mode?

[poppyer]

Bastien <bzg@altern.org> writes:

>> The problem is, it works at the first time. But every time you use C-u
>> C-c C-c to update the whole table. The whole $1 column increase by 1.
>> i.e. "1 2 3 ... " ===> "2 3 4 ..."
>
> Yes, that's a problem.  This is because when looking for a relative
> reference, if Org encounters a non-number row, it falls back on the next
> row in the same column...  I'll send a bug report to Carsten for this.
>

I see. Another related question is: can I set a "partial" column/row
formula? such as @2$1..$1=@-1+1 ? It is not working here.

cheers,
poppyer



-- 

Re: auto incremental columns in table of org-mode?

[Bastien]

poppyer <poppyer@gmail.com> writes:

> I see. Another related question is: can I set a "partial" column/row
> formula? such as @2$1..$1=@-1+1 ? It is not working here.

What is this supposed to do?

-- 
Bastien

Re: auto incremental columns in table of org-mode?

[poppyer]

Bastien <bzg@altern.org> writes:

> poppyer <poppyer@gmail.com> writes:
>
>> I see. Another related question is: can I set a "partial" column/row
>> formula? such as @2$1..$1=@-1+1 ? It is not working here.
>
> What is this supposed to do?

basically what i want is to set a formula for a "range" of cells,
say @2$1..@END$1, rather than for an entire column or row.

poppyer

-- 

Re: auto incremental columns in table of org-mode?

[drostekirsten]

On Mar 18, 11:24 pm, Bastien <b...@altern.org> wrote:
> poppyer <popp...@gmail.com> writes:
> >> This basically says: for the each cell in the first column, compute the
> >> value of the cell by adding 1 to the value of the cell above.
>
> > I am using similar $1=@-1+1;N
>
>                              ^^
>
> (The ;N is not required here, this is for Calc formulas only.)
>
> > The problem is, it works at the first time. But every time you use C-u
> > C-c C-c to update the whole table. The whole $1 column increase by 1.
> > i.e. "1 2 3 ... " ===> "2 3 4 ..."
>
> Yes, that's a problem.  This is because when looking for a relative
> reference, if Org encounters a non-number row, it falls back on the next
> row in the same column...  I'll send a bug report to Carsten for this.
>
> > Any idea to exclude the first "1" without being updated?
>
> If you don't really need to compute the first column you can always
> use a dummy macro like this one:
>
> C-a f3 | C-xC-kC-i | | C-j f4
>
> Then use it with C-x e e e e as many times as you want rows...

Even easier is this:

Put a 1 into the first field, and press S-RET to fill the column with
increasing numbers.
As Bastien says, this will not recompute when you add or remove lines.

- Carsten

Re: auto incremental columns in table of org-mode?

[poppyer]

>> If you don't really need to compute the first column you can always
>> use a dummy macro like this one:
>>
>> C-a f3 | C-xC-kC-i | | C-j f4
>>
>> Then use it with C-x e e e e as many times as you want rows...
>
> Even easier is this:
>
> Put a 1 into the first field, and press S-RET to fill the column with
> increasing numbers.
> As Bastien says, this will not recompute when you add or remove lines.
>
> - Carsten

Wah! this is so COOL!
Definitely should add it to the documentation.

poppyer
--