Hello, Karl Voit <devn...@karl-voit.at> 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
