From mboxrd@z Thu Jan  1 00:00:00 1970
From: Tassilo Horn <tassilo@member.fsf.org>
Subject: Spreadsheet question
Date: Wed, 03 Dec 2008 22:34:45 +0100
Message-ID: <87abbdc58q.fsf@thinkpad.tsdh.de>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
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 1L7zNA-0000ZV-Bt
	for emacs-orgmode@gnu.org; Wed, 03 Dec 2008 16:35:04 -0500
Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43)
	id 1L7zN7-0000YX-HI
	for emacs-orgmode@gnu.org; Wed, 03 Dec 2008 16:35:03 -0500
Received: from [199.232.76.173] (port=52549 helo=monty-python.gnu.org)
	by lists.gnu.org with esmtp (Exim 4.43) id 1L7zN7-0000YU-9s
	for emacs-orgmode@gnu.org; Wed, 03 Dec 2008 16:35:01 -0500
Received: from main.gmane.org ([80.91.229.2]:55182 helo=ciao.gmane.org)
	by monty-python.gnu.org with esmtps (TLS-1.0:RSA_AES_256_CBC_SHA1:32)
	(Exim 4.60) (envelope-from <geo-emacs-orgmode@m.gmane.org>)
	id 1L7zN6-0002PJ-W6
	for emacs-orgmode@gnu.org; Wed, 03 Dec 2008 16:35:01 -0500
Received: from list by ciao.gmane.org with local (Exim 4.43)
	id 1L7zMz-0007Ba-As
	for emacs-orgmode@gnu.org; Wed, 03 Dec 2008 21:34:53 +0000
Received: from p54af2147.dip0.t-ipconnect.de ([84.175.33.71])
	by main.gmane.org with esmtp (Gmexim 0.1 (Debian))
	id 1AlnuQ-0007hv-00
	for <emacs-orgmode@gnu.org>; Wed, 03 Dec 2008 21:34:53 +0000
Received: from tassilo by p54af2147.dip0.t-ipconnect.de with local (Gmexim 0.1
	(Debian)) id 1AlnuQ-0007hv-00
	for <emacs-orgmode@gnu.org>; Wed, 03 Dec 2008 21:34:53 +0000
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

Hi all,

I have this table:

| header |
|--------|
|      1 |
|      1 |
|--------|
|      0 |
#+TBLFM: @4$1=vsum(@2..@-1)

The cell containing 0 should sum up all values of the column's rows
above.  But C-u C-c C-c gives 2, then 4, then 6, then 8...

Reading the docs I found out that @-1 won't cross hlines, so now I use
-I instead which works.  But still I don't understand the @-1 behavior.
Even if knowing that it doesn't cross hlines I'd expect it to calculate
the correct value or at least error because there's no row above @4
before the next hline.  So why is (equal @-1 @0) here?

Bye,
Tassilo