emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed
From: Richard G Riley <rileyrgdev@googlemail.com>
To: org-mode <emacs-orgmode@gnu.org>
Subject: spreadsheet in org
Date: Mon, 08 Sep 2008 01:50:48 +0200	[thread overview]
Message-ID: <1h1vzv1pnr.fsf@googlemail.com> (raw)


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.

             reply	other threads:[~2008-09-07 23:51 UTC|newest]

Thread overview: 6+ messages / expand[flat|nested]  mbox.gz  Atom feed  top
2008-09-07 23:50 Richard G Riley [this message]
2008-09-08  8:03 ` spreadsheet in org Thomas Baumann
2008-09-08  8:23   ` Richard G Riley
2008-09-08 10:48     ` Thomas Baumann
2008-09-08 14:56       ` Richard G Riley
2008-09-08 17:07         ` Carsten Dominik

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

  Avoid top-posting and favor interleaved quoting:
  https://en.wikipedia.org/wiki/Posting_style#Interleaved_style

  List information: https://www.orgmode.org/

* Reply using the --to, --cc, and --in-reply-to
  switches of git-send-email(1):

  git send-email \
    --in-reply-to=1h1vzv1pnr.fsf@googlemail.com \
    --to=rileyrgdev@googlemail.com \
    --cc=emacs-orgmode@gnu.org \
    /path/to/YOUR_REPLY

  https://kernel.org/pub/software/scm/git/docs/git-send-email.html

* If your mail client supports setting the In-Reply-To header
  via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line before the message body.
Code repositories for project(s) associated with this public inbox

	https://git.savannah.gnu.org/cgit/emacs/org-mode.git

This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).