From mboxrd@z Thu Jan  1 00:00:00 1970
From: Tassilo Horn <tassilo@member.fsf.org>
Subject: Re: Spreadsheet field referencing problem
Date: Thu, 01 Oct 2009 11:12:24 +0200
Message-ID: <87d457bhqf.fsf@thinkpad.tsdh.de>
References: <87tyyjbmkm.fsf@thinkpad.tsdh.de>
	<4AC46BB9.3020702@cs.tu-berlin.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 1MtHie-0003oJ-VE
	for emacs-orgmode@gnu.org; Thu, 01 Oct 2009 05:13:01 -0400
Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43)
	id 1MtHia-0003kB-BP
	for emacs-orgmode@gnu.org; Thu, 01 Oct 2009 05:13:00 -0400
Received: from [199.232.76.173] (port=52536 helo=monty-python.gnu.org)
	by lists.gnu.org with esmtp (Exim 4.43) id 1MtHia-0003jr-6U
	for emacs-orgmode@gnu.org; Thu, 01 Oct 2009 05:12:56 -0400
Received: from lo.gmane.org ([80.91.229.12]:59815)
	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 1MtHiZ-0001QW-Ke
	for emacs-orgmode@gnu.org; Thu, 01 Oct 2009 05:12:56 -0400
Received: from list by lo.gmane.org with local (Exim 4.50) id 1MtHiR-0005Rm-3t
	for emacs-orgmode@gnu.org; Thu, 01 Oct 2009 11:12:47 +0200
Received: from p54af2762.dip0.t-ipconnect.de ([84.175.39.98])
	by main.gmane.org with esmtp (Gmexim 0.1 (Debian))
	id 1AlnuQ-0007hv-00
	for <emacs-orgmode@gnu.org>; Thu, 01 Oct 2009 11:12:47 +0200
Received: from tassilo by p54af2762.dip0.t-ipconnect.de with local (Gmexim 0.1
	(Debian)) id 1AlnuQ-0007hv-00
	for <emacs-orgmode@gnu.org>; Thu, 01 Oct 2009 11:12:47 +0200
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

Stephan Schmitt <drmabuse@cs.tu-berlin.de> writes:

Hi Stephan,

> one solution would be:
>
> | Datum            | Anzahlung | Sonderzahlung | Monatsrate | Restbetrag |
> |------------------+-----------+---------------+------------+------------|
> |                  |           |               |            |      79000 |
> |------------------+-----------+---------------+------------+------------|
> | <2009-10-30 Fri> |      7000 |             0 |          0 |      72000 |
> | <2009-11-15 Sun> |         0 |             0 |       1000 |      71000 |
> | <2009-12-15 Tue> |         0 |             0 |       1000 |      70000 |
> #+TBLFM: $5=@-1 - vsum($2..$4)::@2$5=79000

Ah, so a column formula doesn't touch fields that have an own formula.

Thanks for the hint,
Tassilo