Re: formula

[Nick Dokos <nicholas.dokos@hp.com>]

Haroldo Stenger <harold.stenger@gmail.com> 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