From mboxrd@z Thu Jan 1 00:00:00 1970 From: Henri-Paul Indiogine Subject: spreadsheet Date: Fri, 03 Dec 2010 12:05:51 -0800 Message-ID: <87ei9y62qo.fsf@gmail.com> Reply-To: hindiogine@gmail.com Mime-Version: 1.0 Content-Type: text/plain Return-path: Received: from [140.186.70.92] (port=52309 helo=eggs.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1PObtH-0003JC-6F for emacs-orgmode@gnu.org; Fri, 03 Dec 2010 15:06:00 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1PObtF-0000AN-SG for emacs-orgmode@gnu.org; Fri, 03 Dec 2010 15:05:58 -0500 Received: from mail-gy0-f169.google.com ([209.85.160.169]:53988) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1PObtF-0000A8-Ot for emacs-orgmode@gnu.org; Fri, 03 Dec 2010 15:05:57 -0500 Received: by gyg10 with SMTP id 10so19640416gyg.0 for ; Fri, 03 Dec 2010 12:05:56 -0800 (PST) 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-org Dear Orgmoders: I would like to use org-mode spreadsheet for my small business. I would like to have some type of ledger with running balance. I have done this sort of calculation with many spreadsheets e.g. OpenOffice Calc, but I am not able to do so with org-mode. This is what I would like to set up: | Date | Debit/Credit | Balance | |-------+--------------+---------| | day 1 | -10.00 | -10 | | day 2 | 50.00 | 40 | | day 3 | -20.00 | 20 | | day 4 | 40.00 | 60 | and so on. I tried the following in cell @2$3 : =$2 + @-1$2 but that does not work. Any suggestions? Thanks, Henri-Paul -- Henri-Paul Indiogine Email: hindiogine@gmail.com Running: Ubuntu Linux 10.10, Emacs 24.0.50.1, org-mode 7.3