Re: [O] Calc: Second to last row

[Karl Voit]

* Karl Voit <address@hidden> 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 @address@hidden 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