From mboxrd@z Thu Jan 1 00:00:00 1970 From: Tassilo Horn Subject: Spreadsheet field referencing problem Date: Thu, 01 Oct 2009 09:27:53 +0200 Message-ID: <87tyyjbmkm.fsf@thinkpad.tsdh.de> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Return-path: Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1MtG5U-0008Km-Sw for emacs-orgmode@gnu.org; Thu, 01 Oct 2009 03:28:28 -0400 Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43) id 1MtG5Q-0008ED-QY for emacs-orgmode@gnu.org; Thu, 01 Oct 2009 03:28:28 -0400 Received: from [199.232.76.173] (port=47527 helo=monty-python.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1MtG5Q-0008D0-95 for emacs-orgmode@gnu.org; Thu, 01 Oct 2009 03:28:24 -0400 Received: from mx20.gnu.org ([199.232.41.8]:28276) by monty-python.gnu.org with esmtps (TLS-1.0:RSA_AES_256_CBC_SHA1:32) (Exim 4.60) (envelope-from ) id 1MtG5P-0007Qz-I5 for emacs-orgmode@gnu.org; Thu, 01 Oct 2009 03:28:23 -0400 Received: from lo.gmane.org ([80.91.229.12]) by mx20.gnu.org with esmtp (Exim 4.60) (envelope-from ) id 1MtG5O-0006dg-Pf for emacs-orgmode@gnu.org; Thu, 01 Oct 2009 03:28:23 -0400 Received: from list by lo.gmane.org with local (Exim 4.50) id 1MtG5J-0002nF-Fn for emacs-orgmode@gnu.org; Thu, 01 Oct 2009 09:28:17 +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 ; Thu, 01 Oct 2009 09:28:17 +0200 Received: from tassilo by p54af2762.dip0.t-ipconnect.de with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Thu, 01 Oct 2009 09:28:17 +0200 List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-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 a table like this: | Datum | Anzahlung | Sonderzahlung | Monatsrate | Restbetrag | |------------------+-----------+---------------+------------+------------| | | | | | 79000 | |------------------+-----------+---------------+------------+------------| | <2009-10-30 Fri> | 7000 | 0 | 0 | | | <2009-11-15 Sun> | 0 | 0 | 1000 | | | <2009-12-15 Tue> | 0 | 0 | 1000 | | In the last column "Restbetrag" I want to have a column formula, so that I get these values: | 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 | So the formula should take the value from the cell above, and substract the sum of the other values in that row. So I came up with the formula #+TBLFM: $5=@-1 - vsum($2..$4) but recalculating the table gives that: | Datum | Anzahlung | Sonderzahlung | Monatsrate | Restbetrag | |------------------+-----------+---------------+------------+--------------------| | | | | | Restbetrag | |------------------+-----------+---------------+------------+--------------------| | <2009-10-30 Fri> | 7000 | 0 | 0 | Restbetrag - 7000 | | <2009-11-15 Sun> | 0 | 0 | 1000 | Restbetrag - 8000 | | <2009-12-15 Tue> | 0 | 0 | 1000 | Restbetrag - 9000 | How do I get it right? Bye, Tassilo