Calc: Second to last row

Calc: Second to last row

[Karl Voit]

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)

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)

-- 
mail|git|SVN|photos|postings|SMS|phonecalls|RSS|CSV|XML to Org-mode:
       > get Memacs from https://github.com/novoid/Memacs <

https://github.com/novoid/extract_pdf_annotations_to_orgmode + more on github

Re: Calc: Second to last row

[Nick Dokos]

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

Re: Calc: Second to last row

[Karl Voit]

* Karl Voit <devnull@Karl-Voit.at> wrote:
>
> 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".

I am happy to have found the answer to my question on my own: @>> is
the second to last row. @>>> the one before. Same holds for columns:
$>> is the second to last column. 

The solution for my example is:

| Values |
|--------|
|      1 |
|      1 |
|      1 |
|--------|
|      1 |
|      1 |
|      1 |
|--------|
|      6 |
#+TBLFM: @2$1..@>>$1=1 :: @>$1=vsum(@2$1..@>>$1)

-- 
mail|git|SVN|photos|postings|SMS|phonecalls|RSS|CSV|XML to Org-mode:
       > get Memacs from https://github.com/novoid/Memacs <

https://github.com/novoid/extract_pdf_annotations_to_orgmode + more on github