From mboxrd@z Thu Jan  1 00:00:00 1970
From: Richard G Riley <rileyrgdev@googlemail.com>
Subject: spreadsheet in org
Date: Mon, 08 Sep 2008 01:50:48 +0200
Message-ID: <1h1vzv1pnr.fsf@googlemail.com>
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 1KcU2j-0001Fw-20
	for emacs-orgmode@gnu.org; Sun, 07 Sep 2008 19:51:45 -0400
Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43)
	id 1KcU2g-0001FL-Ph
	for emacs-orgmode@gnu.org; Sun, 07 Sep 2008 19:51:44 -0400
Received: from [199.232.76.173] (port=43954 helo=monty-python.gnu.org)
	by lists.gnu.org with esmtp (Exim 4.43) id 1KcU2g-0001FI-Lt
	for emacs-orgmode@gnu.org; Sun, 07 Sep 2008 19:51:42 -0400
Received: from mu-out-0910.google.com ([209.85.134.185]:49817)
	by monty-python.gnu.org with esmtp (Exim 4.60)
	(envelope-from <rileyrgdev@googlemail.com>) id 1KcU2g-0006zc-7a
	for emacs-orgmode@gnu.org; Sun, 07 Sep 2008 19:51:42 -0400
Received: by mu-out-0910.google.com with SMTP id i2so1147469mue.6
	for <emacs-orgmode@gnu.org>; Sun, 07 Sep 2008 16:51:40 -0700 (PDT)
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: org-mode <emacs-orgmode@gnu.org>


Here is a straightforward spreadsheet:


* Test org-mode spreadsheet for cash books


|   | Name             |           Cash |
|---+------------------+----------------|
| _ |                  |    cashforward |
|   |                  |          68000 |
| _ |                  |       cashtake |
|   | cash takings     |           2340 |
| _ |                  |       cashbank |
|   | moved to bank    |           2000 |
|---+------------------+----------------|
| _ |                  |           cash |
| # | subtotal         |          68340 |
|---+------------------+----------------|
|   | emp1             |            315 |
|   | emp2             |            289 |
|   |                  |              0 |
|   |                  |              0 |
|---+------------------+----------------|
| _ |                  |          wages |
| # | total wages      |            604 |
|---+------------------+----------------|
| _ |                  | cashafterwages |
| # | Cash After Wages |          67736 |
|---+------------------+----------------|
#+TBLFM: $cash=$cashforward+$cashtake-$cashbank::$cashafterwages=$cash-$wages::$wages=vsum(@10$3..@13$3)

My questions are:

Can one not actually name a specific cell? Or must the name itself be
stored above or below the cell?

The wages field : how to generalise this to allow for rows to be
added/deleted in the emp1,emp2 block?

Or is there a totally better way to do this? I didnt see a way for all
fields to auto calculate when a certain field was changed. One has to
tab over the "#" in the left hand column. Or?

If you can suggest a neater approach please do - this is my first
attempt at an org-mode spreadsheet.

Oh yes, can one change the enter mode so that the field only edits if
you press enter first? And then it preselects the previous contents so a
single key other than cursor keys will wipe the previous contents?
Currently if I type "5" in the wages field above then, depending where
the cursor is, I get (for example) 6504.