all messages for Emacs-related lists mirrored at yhetil.org
 help / color / mirror / code / Atom feed
* table: actualise columns with formulas. (C-num C-c=)
@ 2010-06-14 11:02 Uwe Brauer
  2010-06-14 12:33 ` Giovanni Ridolfi
  2010-06-14 16:12 ` Bernt Hansen
  0 siblings, 2 replies; 6+ messages in thread
From: Uwe Brauer @ 2010-06-14 11:02 UTC (permalink / raw)
  To: emacs-orgmode

Hello

Programs like OO calc allow me to actualise automatically
all rows of a column containing a formula.

Like:

Res1| Res2| Total
3   |  4  | =$1+$2
4   |  5  |
4   |  5  |
4   |  6  |
4   |  7  |
4   |  8  |
4   |  9  |

Now the only thing I have to do is copy and paste it into
the rows below that formula in the same column.
--------------------------
The closest thing I know in org mode is to use 
C-6 C-c =
but of course I have to count the numbers of rows in
advance, so the question is:

Could C-c = also act on a marked column, so that I don't
have to specify the numbers of rows?

thanks

Uwe Brauer 

^ permalink raw reply	[flat|nested] 6+ messages in thread

* Re: table: actualise columns with formulas. (C-num C-c=)
  2010-06-14 11:02 table: actualise columns with formulas. (C-num C-c=) Uwe Brauer
@ 2010-06-14 12:33 ` Giovanni Ridolfi
  2010-06-14 12:45   ` Giovanni Ridolfi
  2010-06-14 16:12 ` Bernt Hansen
  1 sibling, 1 reply; 6+ messages in thread
From: Giovanni Ridolfi @ 2010-06-14 12:33 UTC (permalink / raw)
  To: Uwe Brauer; +Cc: emacs-orgmode

Uwe Brauer <oub@mat.ucm.es> writes:

> Hello
>
> Programs like OO calc allow me to actualise automatically
> all rows of a column containing a formula.
>
> Like:
>
> Res1| Res2| Total
> 3   |  4  | =$1+$2
> 4   |  5  |
> 4   |  5  |
> 4   |  6  |
> 4   |  7  |
> 4   |  8  |
> 4   |  9  |
> Now the only thing I have to do is copy and paste it into
> the rows below that formula in the same column.

why don't you use: 
| Res1| Res2| Total
| 3   |  4  | =$1+$2
| 4   |  5  |
#+TBLFM:$3=$1+S2

?
then with C-c in the "#+TBLFM:$3" line your table will be updated
I think also if you press TAB with the cursor in 
the third column.

cheers
Giovanni

^ permalink raw reply	[flat|nested] 6+ messages in thread

* Re: table: actualise columns with formulas. (C-num C-c=)
  2010-06-14 12:33 ` Giovanni Ridolfi
@ 2010-06-14 12:45   ` Giovanni Ridolfi
  2010-06-14 13:50     ` Uwe Brauer
  0 siblings, 1 reply; 6+ messages in thread
From: Giovanni Ridolfi @ 2010-06-14 12:45 UTC (permalink / raw)
  To: Uwe Brauer; +Cc: emacs-orgmode

Giovanni Ridolfi <giovanni.ridolfi@yahoo.it> writes:

> Uwe Brauer <oub@mat.ucm.es> writes:
>
>> Res1| Res2| Total
>> 3   |  4  | =$1+$2
>> 4   |  5  |
>> 4   |  5  |
>> 4   |  6  |
>> 4   |  7  |
>> 4   |  8  |
>> 4   |  9  |
>> Now the only thing I have to do is copy and paste it into
>> the rows below that formula in the same column.
>
> why don't you use: 

sorry I meant:  
| Res1| Res2| Total|
|-----|-----|------|
| 3   |  4  |      |
| 4   |  5  |      |
#+TBLFM:$3=$1+S2

then with C-c in the "#+TBLFM:$3" line your table will be updated
I think also if you press TAB with the cursor in 
the third column.

cheers,
 Giovanni

^ permalink raw reply	[flat|nested] 6+ messages in thread

* Re: table: actualise columns with formulas. (C-num C-c=)
  2010-06-14 12:45   ` Giovanni Ridolfi
@ 2010-06-14 13:50     ` Uwe Brauer
  2010-06-14 15:25       ` Nick Dokos
  0 siblings, 1 reply; 6+ messages in thread
From: Uwe Brauer @ 2010-06-14 13:50 UTC (permalink / raw)
  To: Giovanni Ridolfi; +Cc: emacs-orgmode

>>>>> On Mon, 14 Jun 2010 14:45:59 +0200, Giovanni Ridolfi <giovanni.ridolfi@yahoo.it> wrote:
   >> 
   >> why don't you use: 

   > sorry I meant:  
   > | Res1| Res2| Total|
   > |-----|-----|------|
   > | 3   |  4  |      |
   > | 4   |  5  |      |
   > #+TBLFM:$3=$1+S2

   > then with C-c in the "#+TBLFM:$3" line your table will be updated
   > I think also if you press TAB with the cursor in 
   > the third column.

Ok so I have to type C-c C-c in the #+TBLFM:$3 line! That worked!

Before I used C-c C-c with the cursor in the table and that
did not work. May be that should be added in the documentation?

thanks

Uwe 

^ permalink raw reply	[flat|nested] 6+ messages in thread

* Re: table: actualise columns with formulas. (C-num C-c=)
  2010-06-14 13:50     ` Uwe Brauer
@ 2010-06-14 15:25       ` Nick Dokos
  0 siblings, 0 replies; 6+ messages in thread
From: Nick Dokos @ 2010-06-14 15:25 UTC (permalink / raw)
  To: Uwe Brauer; +Cc: nicholas.dokos, emacs-orgmode

Uwe Brauer <oub@mat.ucm.es> wrote:

> >>>>> On Mon, 14 Jun 2010 14:45:59 +0200, Giovanni Ridolfi <giovanni.ridolfi@yahoo.it> wrote:
>    >> 
>    >> why don't you use: 
> 
>    > sorry I meant:  
>    > | Res1| Res2| Total|
>    > |-----|-----|------|
>    > | 3   |  4  |      |
>    > | 4   |  5  |      |
>    > #+TBLFM:$3=$1+S2
> 
>    > then with C-c in the "#+TBLFM:$3" line your table will be updated
>    > I think also if you press TAB with the cursor in 
>    > the third column.
> 
> Ok so I have to type C-c C-c in the #+TBLFM:$3 line! That worked!
> 
> Before I used C-c C-c with the cursor in the table and that
> did not work. May be that should be added in the documentation?
> 

See section 14.5, "The very busy C-c C-c key" in the Org manual.

Nick

^ permalink raw reply	[flat|nested] 6+ messages in thread

* Re: table: actualise columns with formulas. (C-num C-c=)
  2010-06-14 11:02 table: actualise columns with formulas. (C-num C-c=) Uwe Brauer
  2010-06-14 12:33 ` Giovanni Ridolfi
@ 2010-06-14 16:12 ` Bernt Hansen
  1 sibling, 0 replies; 6+ messages in thread
From: Bernt Hansen @ 2010-06-14 16:12 UTC (permalink / raw)
  To: Uwe Brauer; +Cc: emacs-orgmode

Uwe Brauer <oub@mat.ucm.es> writes:

> Hello
>
> Programs like OO calc allow me to actualise automatically
> all rows of a column containing a formula.
>
> Like:
>
> Res1| Res2| Total
> 3   |  4  | =$1+$2
> 4   |  5  |
> 4   |  5  |
> 4   |  6  |
> 4   |  7  |
> 4   |  8  |
> 4   |  9  |

If you prefix the first column of the table so that it is a valid
org-mode table like this:

|Res1| Res2| Total
|3   |  4  | =$1+$2
|4   |  5  |
|4   |  5  |
|4   |  6  |
|4   |  7  |
|4   |  8  |
|4   |  9  |


Then you can just hit C-u C-u C-c C-c on the formula line and it moves
to the bottom and updates the entire table giving you this:

| Res1 | Res2 | Res1 + Res2 |
|    3 |    4 |           7 |
|    4 |    5 |           9 |
|    4 |    5 |           9 |
|    4 |    6 |          10 |
|    4 |    7 |          11 |
|    4 |    8 |          12 |
|    4 |    9 |          13 |
#+TBLFM: $3=$1+$2

HTH,
Bernt


>
> Now the only thing I have to do is copy and paste it into
> the rows below that formula in the same column.
> --------------------------
> The closest thing I know in org mode is to use 
> C-6 C-c =
> but of course I have to count the numbers of rows in
> advance, so the question is:
>
> Could C-c = also act on a marked column, so that I don't
> have to specify the numbers of rows?
>
> thanks
>
> Uwe Brauer 
>
>
> _______________________________________________
> Emacs-orgmode mailing list
> Please use `Reply All' to send replies to the list.
> Emacs-orgmode@gnu.org
> http://lists.gnu.org/mailman/listinfo/emacs-orgmode

^ permalink raw reply	[flat|nested] 6+ messages in thread

end of thread, other threads:[~2010-06-14 20:04 UTC | newest]

Thread overview: 6+ messages (download: mbox.gz follow: Atom feed
-- links below jump to the message on this page --
2010-06-14 11:02 table: actualise columns with formulas. (C-num C-c=) Uwe Brauer
2010-06-14 12:33 ` Giovanni Ridolfi
2010-06-14 12:45   ` Giovanni Ridolfi
2010-06-14 13:50     ` Uwe Brauer
2010-06-14 15:25       ` Nick Dokos
2010-06-14 16:12 ` Bernt Hansen

Code repositories for project(s) associated with this external index

	https://git.savannah.gnu.org/cgit/emacs.git
	https://git.savannah.gnu.org/cgit/emacs/org-mode.git

This is an external index of several public inboxes,
see mirroring instructions on how to clone and mirror
all data and code used by this external index.