[Top][All Lists]
[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