column formulas: Row descriptor -1 used in line ### leads outside table

column formulas: Row descriptor -1 used in line ### leads outside table

[andersvi]

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.

Thanks,

-anders

Re: column formulas: Row descriptor -1 used in line ### leads outside table

[Nick Dokos]

andersvi@notam02.no 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

Re: column formulas: Row descriptor -1 used in line ### leads outside table

[andersvi]

>>>>> "N" == Nick Dokos <nicholas.dokos@hp.com> writes:

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

Thanks.