No, $LR1 inserts the *value* of that field.
You can do this:
| 1 | 6 |
| 2 | |
| 3 | |
#+TBLFM: @1$2=vsum(@1$...@i-1$1)
Org imagines a hline at the end of a table, in your
case this would be the first hline in the table, so
@I-1 refers to the last row.
HTH
- Carsten
On Mar 13, 2009, at 1:09 AM, Gabor Maroti wrote:
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(@1$...@3$1)?
Thanks,
G.
_______________________________________________
Emacs-orgmode mailing list
Remember: use `Reply All' to send replies to the list.
Emacs-orgmode@gnu.org
http://lists.gnu.org/mailman/listinfo/emacs-orgmode
_______________________________________________
Emacs-orgmode mailing list
Remember: use `Reply All' to send replies to the list.
Emacs-orgmode@gnu.org
http://lists.gnu.org/mailman/listinfo/emacs-orgmode