Re: Calc: Second to last row

[Nick Dokos <ndokos@gmail.com>]

Karl Voit <devnull@Karl-Voit.at> writes:

> Hi!
>
> I would like to refer to the second to last row of a table.
>
> The following example should demonstrate my issue. What I expect is
> that the following formula is filling @2..@5 with "1" and in the
> last row, there is the sum of all "1".
>
> It is important to me to ignore the number of horizontal lines since
> their number varies in my case.
>
> | Values |
> |--------|
> |        |
> |        |
> |--------|
> |        |
> |        |
> |--------|
> |        |
>
> #+TBLFM: @2$1..@>-1$1=1 :: @>$1=vsum(@2$1..@>-1$1)

This should be:

#+TBLFM: @2$1..@>>$1=1 :: @>$1=vsum(@2$1..@>>$1)

>
> Expected result:
>
> | Values |
> |--------|
> |      1 |
> |      1 |
> |--------|
> |      1 |
> |      1 |
> |--------|
> |      4 |
>
> Actual result: "user-error: Several field/range formulas try to set
> @8$1".
>
> With a fixed number of horizontal lines, the sum would be:
>
> #+TBLFM: @>$1=vsum(@2$1..@III$1);T
>
> So how can this be accomplished for an arbitrary number of
> horizontal lines?
>
>
> At my side: Org-mode version 8.3.4 (release_8.3.4-33-gd522fc)

-- 
Nick