Matt Chastagnier <workandr...@gmail.com> wrote: > I've just started with org-mode and have done several tutorials. But I'm > stuck with this problem for 3 hours : > > > I have : > > | item | quantity | > |---------+----------| > | laptop | 4 | > | desktop | 7 | > |---------+----------| > | Total | 11 | > > #+TBLFM: @4$2=vsum(@i...@ii) > > I insert a new line [because I will want to add a new item] (M-S down) and > update the table (C-u C-c C-c) : > > | item | quantity | > |---------+----------| > | laptop | 4 | > | desktop | 7 | > | | 11 | > |---------+----------| > | Total | 11 | > > #+TBLFM: @4$2=vsum(@i...@ii) > > but my formula isn't updated automatically so the wrong field is updated. I > would like the formula to become @5$2 instead of @4$2 automatically. > I've searched during 2 hours with google but found nothing :/ ... Is it > possible to do it? Cause It's very annoying to update the formula "by hand" > (sorry for my english). >
You looked in the wrong place :-) If you look in section 3.5.1, "References", in the Org manual, you'll find ,---- | As a special case, references like `$LR5' and `$LR12' can be used to | refer in a stable way to the 5th and 12th field in the last row of the | table. `---- So make your formula #+TBLFM: $LR2=vsum(@i...@ii) HTH, 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
