From mboxrd@z Thu Jan 1 00:00:00 1970 From: Nick Dokos Subject: Re: formula Date: Tue, 04 Aug 2009 10:52:55 -0400 Message-ID: <12499.1249397575@gamaville.dokosmarshall.org> References: <3678e0bb0908021558y35e887d2r481a7eb5a8ab7280@mail.gmail.com> <3678e0bb0908031653v6b1ec438kda7788e0b5df36a2@mail.gmail.com> <92686641-229C-43A6-9D9A-F49BD3EEB12B@gmail.com> <3678e0bb0908032328j379f2f66xffc2f05baebc271b@mail.gmail.com> <8D34FDAD-F585-4547-8176-EF35313637DB@gmail.com> <3678e0bb0908040723x74413f21qee4a440f41360eaf@mail.gmail.com> Reply-To: nicholas.dokos@hp.com Return-path: Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1MYLPi-0007A3-W4 for emacs-orgmode@gnu.org; Tue, 04 Aug 2009 10:54:55 -0400 Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43) id 1MYLPe-00074w-GJ for emacs-orgmode@gnu.org; Tue, 04 Aug 2009 10:54:54 -0400 Received: from [199.232.76.173] (port=42755 helo=monty-python.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1MYLPe-00074f-5s for emacs-orgmode@gnu.org; Tue, 04 Aug 2009 10:54:50 -0400 Received: from vms173003pub.verizon.net ([206.46.173.3]:54390) by monty-python.gnu.org with esmtp (Exim 4.60) (envelope-from ) id 1MYLPd-0000DR-Hp for emacs-orgmode@gnu.org; Tue, 04 Aug 2009 10:54:49 -0400 Received: from gamaville.dokosmarshall.org ([98.110.172.159]) by vms173003.mailsrvcs.net (Sun Java(tm) System Messaging Server 6.3-7.04 (built Sep 26 2008; 32bit)) with ESMTPA id <0KNU00EWYXC6H7D5@vms173003.mailsrvcs.net> for emacs-orgmode@gnu.org; Tue, 04 Aug 2009 09:53:00 -0500 (CDT) In-reply-to: Message from Haroldo Stenger of "Tue, 04 Aug 2009 11:23:30 -0300." <3678e0bb0908040723x74413f21qee4a440f41360eaf@mail.gmail.com> List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org To: Haroldo Stenger Cc: emacs-orgmode@gnu.org, Carsten Dominik Haroldo Stenger wrote: > > Carsten , > > I take for granted that a filed formula is a column formula , like the one I > was using. > That's incorrect: look at Carsten's modification of your TBLFM line: > #+TBLFM: $3=@-1$3 + @+0$1 - @+0$2::@2$3=0 ^^^^^^---- this is the field formula. The field formula initializes the top cell of the "balance" column. The column formula (what you had before) then applies to the rest of the column. > 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 ? > You are probably getting an error and somehow missing it: here is what I get without the field formula: ,---- | Debugger entered--Lisp error: (error #("Row descriptor -1 used in line 4 crosses hline" 15 17 (fontified t font-lock-fontified t face org-meta-line))) | signal(error (#("Row descriptor -1 used in line 4 crosses hline" 15 17 (fontified t font-lock-fontified t face org-meta-line)))) | error("Row descriptor %s used in line %d crosses hline" #("-1" 0 2 (face org-meta-line font-lock-fontified t fontified t)) 4) | org-table-find-row-type([dline hline dline dline dline dline dline dline dline hline] 2 dline t 1 1 4 #("-1" 0 2 (face org-meta-line font-lock-fontified t fontified t))) | org-table-get-descriptor-line(#("-1" 0 2 (face org-meta-line font-lock-fontified t fontified t))) | org-table-get-range(#("@-1$3" 0 5 (fontified t font-lock-fontified t face org-meta-line)) nil 3) | org-table-eval-formula(nil #("@-1$3 + @+0$1 - @+0$2" 0 21 (fontified t font-lock-fontified t face org-meta-line)) noalign nocst nostore noanalysis) | org-table-recalculate(t) | call-interactively(org-table-recalculate) | org-ctrl-c-ctrl-c(nil) | call-interactively(org-ctrl-c-ctrl-c nil nil) `---- HTH, Nick