Carsten, Nick, I finally could solve the issue. I got confused by what I consider are two typos in the mails, I was mislead by 'filed formula' which I thought was something new to me, when it was really a simple 'field formula'. Moreover, column formulas (as the docs say, since I checked) start like "$3=" and not as "%3=". Finally, I understood that the only thing I had missing (which you kindly provided) was the field formula that initializes the column to zero, when instead I was trying to achieve by putting a zero directly, which (I don't know why) does not work in combination with a column formula. I just write this as feedback, not to bother anyone. And thanks a lot for your kind help. best, haroldo 2009/8/4 Carsten Dominik > > On Aug 4, 2009, at 4:23 PM, Haroldo Stenger wrote: > > Carsten , >> >> I take for granted that a filed formula is a column formula , like the one >> I was using. >> > > No. A column formula starts like %3=... and applies to all fields > in column 3. A field formula starts like @2$3=... and applies to a single > field. I did out the correct formulas into the table I sent with my last > email. > > For the rest I don't know what is wrong. > > Maybe you have some local setup binding `C-c *' to a different function? > Maybe you C-u is bound to something else? > > You can try to move the cursor into the #+TBLFM line and press `C-c C-c' > there, this should also update the entire table, as should `C-u C-c C-c' > anywhere in the table. > > - Carsten > > > > >> I upgraded to the las org-mode version. >> >> I must be doing something really wrong, since C-u C-c * doesn't >> recalculate the column, it just moves the point to the first row after the >> hline. >> >> What can be that is missing here ? >> >> best regards, >> haroldo >> >> 2009/8/4 Carsten Dominik >> Hi Haroldo, >> >> Well, I am using the newest version of Org-mode for which you'd have to >> use a filed formula for the first field in the balance column. Then using >> your >> formulas, `C-u C-c *' does fill the entire table: >> >> >> | in | out | balance | >> |-----+-----+---------| >> | | | 0 | >> >> | 30 | | 30 | >> | | 25 | 5 | >> | 100 | | 105 | >> | 500 | | 605 | >> | | 400 | 205 | >> | | | 205 | >> #+TBLFM: $3=@-1$3 + @+0$1 - @+0$2::@2$3=0 >> >> So I don't know why this is not working for you. >> >> - Carsten >> >> >> On Aug 4, 2009, at 8:28 AM, Haroldo Stenger wrote: >> >> 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 >> >> >> >> >> > >> >> >> >> >