emacs-orgmode
[Top][All Lists]
Advanced

[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.




reply via email to

[Prev in Thread] Current Thread [Next in Thread]