From: Richard G Riley <rileyrgdev@googlemail.com>
To: Thomas Baumann <dtbaumann@yahoo.de>
Cc: emacs-orgmode@gnu.org
Subject: Re: Re: spreadsheet in org
Date: Mon, 08 Sep 2008 10:23:36 +0200 [thread overview]
Message-ID: <ms7i9nnj07.fsf@googlemail.com> (raw)
In-Reply-To: <m3iqt7jc8w.fsf@norvel.baumann-gauting.site> (Thomas Baumann's message of "Mon, 08 Sep 2008 10:03:11 +0200")
Thomas Baumann <dtbaumann@yahoo.de> writes:
> Richard G Riley <rileyrgdev@googlemail.com> writes:
>
>> 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?
>
> C-c'
> gives you a nice interface to the table formulas, making names
> almost obsolete
I dont see how - names make the formula readable. How does this buffer
makes anything much easier in terms of cell referencing?
>
>> The wages field : how to generalise this to allow for rows to be
>> added/deleted in the emp1,emp2 block?
>
> $wages = vsum(@-I..@-II)
> will do the trick (sum between hlines)
> apart from that, if you add rows using M-S-down your formulas will be
> adjusted automatically.
Thats nice - thanks.
>
>> 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?
>
> As the manual says: C-u C-c *
That is not the same thing as auto recalculation as in excel or similar
: you must manually invoke it. This is easily forgotten (well by me :-;)
> you might also want to look at the Tbl menu
>
>
>> 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.
>
> The interface is already outstandingly smart: Try moving with the TAB
> from one field to another or use enter to stay inside the column. You
> will notice that the requested features are already present. Maybe, also
> try another couple of spreadsheets :-)
If I tab to a field above and press enter a new row appears. It is bound
to org-return. (Latest version). Also there is no preselection of the cell
contents so if I type "8" when I have tabbed to the "cashbank" field
above then I get "| 8 2040 |".
>
> Thomas
>
>
>
> _______________________________________________
> Emacs-orgmode mailing list
> Remember: use `Reply All' to send replies to the list.
> Emacs-orgmode@gnu.org
> http://lists.gnu.org/mailman/listinfo/emacs-orgmode
next prev parent reply other threads:[~2008-09-08 8:24 UTC|newest]
Thread overview: 6+ messages / expand[flat|nested] mbox.gz Atom feed top
2008-09-07 23:50 spreadsheet in org Richard G Riley
2008-09-08 8:03 ` Thomas Baumann
2008-09-08 8:23 ` Richard G Riley [this message]
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=ms7i9nnj07.fsf@googlemail.com \
--to=rileyrgdev@googlemail.com \
--cc=dtbaumann@yahoo.de \
--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.