From mboxrd@z Thu Jan  1 00:00:00 1970
From: meingbg <meingbg@gmail.com>
Subject: Re: Spreadsheet bug?
Date: Fri, 24 Jul 2009 17:20:02 +0200
Message-ID: <e83e84da0907240820g6148fe22pa7d780742da1c151@mail.gmail.com>
References: <c91ecc400907230317t7b46a743seb9d3134a8bf7f9f@mail.gmail.com>
	<20090723123937.c8330ef4.andy13@gmx.net>
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 1MUMZ6-00027d-AS
	for emacs-orgmode@gnu.org; Fri, 24 Jul 2009 11:20:08 -0400
Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43)
	id 1MUMZ1-00027I-V8
	for emacs-orgmode@gnu.org; Fri, 24 Jul 2009 11:20:08 -0400
Received: from [199.232.76.173] (port=44684 helo=monty-python.gnu.org)
	by lists.gnu.org with esmtp (Exim 4.43) id 1MUMZ1-00027F-PC
	for emacs-orgmode@gnu.org; Fri, 24 Jul 2009 11:20:03 -0400
Received: from mail-ew0-f228.google.com ([209.85.219.228]:48628)
	by monty-python.gnu.org with esmtp (Exim 4.60)
	(envelope-from <svenssonaxel@gmail.com>) id 1MUMZ1-0005z7-GR
	for emacs-orgmode@gnu.org; Fri, 24 Jul 2009 11:20:03 -0400
Received: by ewy28 with SMTP id 28so898416ewy.42
	for <emacs-orgmode@gnu.org>; Fri, 24 Jul 2009 08:20:02 -0700 (PDT)
In-Reply-To: <20090723123937.c8330ef4.andy13@gmx.net>
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

> I suspect @2$3 was 4 when you evaluated the formulas, hence the 7.
> If you clear column c completely, what is the output of the evaluation then?

The same. And so now I can't reproduce my original problem... that's
good, I guess.

> A good solution is to use
> $3=vsum(@-I$-1..$-1)

That works. Thanks!


Here's another thing I'm trying:

| a |  b |   c |
|   |  7 | 210 |
|---+----+-----|
| a |  2 |  30 |
| b |  3 |   5 |
| c | -3 |   2 |
| d |  5 |   7 |
#+TBLFM: @2$2=vsum(@3$2..@6$2)::@2$3=vsum(@3$3..$LR3)

I want row 2 to contain sums for what's below. Is there a way to make
the LR-reference work here?

//meingbg