From mboxrd@z Thu Jan  1 00:00:00 1970
From: Gabor Maroti <marotig@gmail.com>
Subject: Spreadsheet: Last row in ranges
Date: Fri, 13 Mar 2009 01:09:52 +0100
Message-ID: <49B9A450.40307@gmail.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43)
	id 1LhuyZ-0005cN-Iu
	for emacs-orgmode@gnu.org; Thu, 12 Mar 2009 20:10:11 -0400
Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43)
	id 1LhuyZ-0005cB-4c
	for emacs-orgmode@gnu.org; Thu, 12 Mar 2009 20:10:11 -0400
Received: from [199.232.76.173] (port=46669 helo=monty-python.gnu.org)
	by lists.gnu.org with esmtp (Exim 4.43) id 1LhuyY-0005c8-UV
	for emacs-orgmode@gnu.org; Thu, 12 Mar 2009 20:10:10 -0400
Received: from smtp06.online.nl ([194.134.42.51]:36385)
	by monty-python.gnu.org with esmtp (Exim 4.60)
	(envelope-from <marotig@gmail.com>) id 1LhuyY-0007Mi-HQ
	for emacs-orgmode@gnu.org; Thu, 12 Mar 2009 20:10:10 -0400
Received: from smtp06.online.nl (localhost [127.0.0.1])
	by smtp06.online.nl (Postfix) with ESMTP id C825196115
	for <emacs-orgmode@gnu.org>; Fri, 13 Mar 2009 01:10:02 +0100 (CET)
Received: from localhost.localdomain (s559324e6.adsl.wanadoo.nl
	[85.147.36.230]) by smtp06.online.nl (Postfix) with ESMTP
	for <emacs-orgmode@gnu.org>; Fri, 13 Mar 2009 01:10:02 +0100 (CET)
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <http://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/pipermail/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <http://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=subscribe>
Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
To: emacs-orgmode@gnu.org

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$1..@3$1)?

Thanks,
G.