[Orgmode] table: actualise columns with formulas. (C-num C-c=)
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 ___ 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
Re: [Orgmode] table: actualise columns with formulas. (C-num C-c=)
Uwe Brauer o...@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 ___ 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
Re: [Orgmode] table: actualise columns with formulas. (C-num C-c=)
Giovanni Ridolfi giovanni.rido...@yahoo.it writes: Uwe Brauer o...@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 ___ 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
Re: [Orgmode] table: actualise columns with formulas. (C-num C-c=)
On Mon, 14 Jun 2010 14:45:59 +0200, Giovanni Ridolfi giovanni.rido...@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 ___ 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
Re: [Orgmode] table: actualise columns with formulas. (C-num C-c=)
Uwe Brauer o...@mat.ucm.es wrote: On Mon, 14 Jun 2010 14:45:59 +0200, Giovanni Ridolfi giovanni.rido...@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 ___ 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