* 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 public inbox
https://git.savannah.gnu.org/cgit/emacs/org-mode.git
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).