Sure, sorry, that's what text is for :) | in | out | balance | |-----+-----+---------| | | | | | 30 | | 30 | | | 25 | 5 | | 100 | | 105 | | 500 | | | | | 400 | | | | | | #+TBLFM: $3=@-1$3 + @+0$1 - @+0$2 That's how the table looks like after - creating the table - filling columns 1 and 2 with numbers - creating the column formula in column 3, and - typing C-c * in @3$3 , @4$3 and @5$3 The complete filling of the $3 column doesn't take place by issuing the commands in http://orgmode.org/org.html#Updating-the-table. If I go to @6$3 , @7$3 and @8$3 and type C-c * I obtain what I want, being: | in | out | balance | |-----+-----+---------| | | | | | 30 | | 30 | | | 25 | 5 | | 100 | | 105 | | 500 | | 605 | | | 400 | 205 | | | | 205 | #+TBLFM: $3=@-1$3 + @+0$1 - @+0$2 I know that what I'm asking should be of easy achievement on my own, but I got somewhat frustrated when I use the commands and the filling doesn't happen. Thanks for helping me. best, haroldo 2009/8/4 Carsten Dominik > > Hi Haroldo, > > instead of keeping us guessing what your table might look like, > maybe you can just post it.... > > - Carsten > > On Aug 4, 2009, at 1:53 AM, Haroldo Stenger wrote: > >> Dear Carsten , >> >> Thanks ! That's exactly what I was in need of: a combination of a column-formula and relative references in the formula. So far, so good. Now, I have the formula line like this >> >> #+TBLFM: $5=@-1$5 + @-0$3 - @-0$4 >> >> and the very line I typed the formula gets calculated fine. If I want another line into the bus, I go to the empty field in the same column in another line, and go to the Calculate menu, and choose recalculate line, and the fine result appears there , as expected. But if I approach Calculate / Recalculate all , in fact , nothing happens. I tried many times, without result. Recalc line works perfectly, but that does not seem what I'm looking for, which would be a recalculation of all the fields in the column that holds my column-formula. I'll continue reading until I find out, but if you come up with an answer earlier I'd be grateful in advance ! :-) >> >> best , >> >> haroldo >> >> 2009/8/3 Carsten Dominik >> Hi Haroldo, >> >> >> You cannot copy a formula easily from one field t the next with >> shifting the reference like you would do in a normal spreadsheet. >> However, you can use relative references (see the manual) in >> order to write formulas in an invariant way, and then use basic >> editing commands in the C-c ' buffer to define the formula for >> many fields. Even better, use a column formula which allows >> you to write a single formula for an entire column. >> >> - Carsten >> >> >> On Aug 3, 2009, at 12:58 AM, Haroldo Stenger wrote: >> >> hi , I wonder how can a formula in a table be "copied" to a location below, and its references be shifted alongwise automatically. I checked every documentation I've found , but that "feature" does not show up. I'm forced to copy the formula in in the C-c ' and then go to each of the references and type S-downarrow as many times. I'd thank any idea here. >> >> best regards, haroldo. >> (thanks for org-mode, it's great) >> _______________________________________________ >> Emacs-orgmode mailing list >> Remember: use `Reply All' to send replies to the list. >> Emacs-orgmode@gnu.org >> http://lists.gnu.org/mailman/listinfo/emacs-orgmode >> >> >