Re: [O] Bug: table/calc: subscr() fails with *bold* headline

[Nicolas Goaziou]

Hello,

Karl Voit <address@hidden> writes:

> I've found a bug when using subscr() to copy a value from a previous
> row. If the corresponding headline is in *bold* letters, the formula
> does not work:
>
> | *Value* | Previous Value |
> |---------+----------------|
> |       1 |                |
> |       2 | #ERROR         |
> |       3 | #ERROR         |
> |       4 | #ERROR         |
> #+TBLFM: @3$2..@>$2 = subscr(@<$1..@>$1, @# - 1)

This is not a bug in Org.

Calc probably considers *Value* as an invalid operation (missing
operands). You can simply ignore the header line

  subscr(@<<$1..@>$1, @# - 1)

or turn any suspicious value as a number

  subscr(@<$1..@>$1, @# - 1);N

Regards,

-- 
Nicolas Goaziou