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.
next 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
* 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 external index
https://git.savannah.gnu.org/cgit/emacs.git
https://git.savannah.gnu.org/cgit/emacs/org-mode.git
This is an external index of several public inboxes,
see mirroring instructions on how to clone and mirror
all data and code used by this external index.