[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Orgmode] Spreadsheet: Last row in ranges
From: |
Gabor Maroti |
Subject: |
[Orgmode] Spreadsheet: Last row in ranges |
Date: |
Fri, 13 Mar 2009 01:09:52 +0100 |
User-agent: |
Thunderbird 2.0.0.19 (X11/20090105) |
Dear All,
A quick spreadsheet question. I just wanted the compute the sum of an
entire column by using
| 1 | |
| 2 | |
| 3 | |
#+TBLFM: @1$2=vsum(@1$1..$LR1)
It doesn't do the trick (neither in v6.24a nor in v6.24c): the value of
@1$2 is 3, 12, 29, 120, etc., after multiple application of the TBLFM
line. Thus it looks to me that the $LR1 syntax is not really welcome in
ranges. Is it so?
Anyway, is it possible to compute the sum of a column apart from the
slightly cumbersome vsum(@address@hidden)?
Thanks,
G.
- [Orgmode] Spreadsheet: Last row in ranges,
Gabor Maroti <=