Re: [O] Spreadsheet error: invalid reference when using @> in range

[Nicolas Goaziou]

Hello,

Karl Voit <address@hidden> writes:

> |     |             20 | 21 | 22 | 23 | 24 |
> |     | :=vsum(@3..@>) |    |    |    |    |
> |-----+----------------+----+----+----+----|
> |     |                |    |    |    |    |
> |-----+----------------+----+----+----+----|
> |     |              1 |  1 |    |    |  1 |
> | Foo |              2 |    |    |    |    |
> | Bar |                |    |  2 |  3 |    |
> |-----+----------------+----+----+----+----|
> |     |                |    |    |    |    |
> |-----+----------------+----+----+----+----|
> | Bar |                |  4 |  1 |    |    |
> | Foo |                |    |  2 |    |  2 |
> | Bar |                |    |  3 |  5 |    |
> | Foo |                |  1 |    |    |  5 |
> |-----+----------------+----+----+----+----|
>
> I got: Spreadsheet error: invalid reference "vsum(@3..@>)" when I
> try to apply the formula.

I cannot reproduce the problem.
>
> Also tried and also failed with same message:
> vsum(@3$2..@>$2)
> vsum(@I$2..@>$2)
> vsum(@I+1$2..@>$2)

Same here.

> Bonus question: when I want to apply the formula to @2$2 and *all*
> table elements rights of it until the last column, is there a way to
> define this without having five separate formula?

  @address@hidden>=vsum(@3..@>)


Regards,

-- 
Nicolas Goaziou