emacs-orgmode
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [O] column formulas: Row descriptor -1 used in line ### leads outsid


From: Nick Dokos
Subject: Re: [O] column formulas: Row descriptor -1 used in line ### leads outside table
Date: Thu, 04 Aug 2011 14:41:00 -0400

address@hidden wrote:

> Anyone have suggestions about how i can have a column-formula refer to
> value in previous row, but ignore the row before the first line?
> 
> Something like this:
> 
>     | 1 | 4 |   |
>     | 2 | 7 |   |
>     | 3 | 1 |   |
>     #+TBLFM: $2=random(10)::$3=(@-1$2)-$2
> 
> Evaluating this returns an error:
> 
>   "Row descriptor -1 used in line 547 leads outside table"
> 
> I tried using a lisp-expression to dispatch on the row-number, but it
> doesnt seem to consider 'if as a special-form, trying to evaluate its
> last argument anyhow.
> 
>     | 1 | 2 |   |
>     | 2 | 6 |   |
>     | 3 | 2 |   |
>     #+TBLFM: $2=random(10)::$3='(if (< @# 3) 0 (- @-1$2 $2))
> 
> but get the same error.
> 

Set the cell in the first line explicitly with a field formula (or just
a value): it overrides the column formula. Something like this:

#+TBLFM: $2=random(10)::$3=(@-1$2)-$2::@1$3 = 0

Nick




reply via email to

[Prev in Thread] Current Thread [Next in Thread]