From: Carsten Dominik <dominik@science.uva.nl>
To: Richard G Riley <rileyrgdev@googlemail.com>
Cc: Thomas Baumann <dtbaumann@yahoo.de>, emacs-orgmode@gnu.org
Subject: Re: Re: spreadsheet in org
Date: Mon, 8 Sep 2008 19:07:10 +0200 [thread overview]
Message-ID: <6088737A-C295-4508-9575-5D6CE909C6F8@uva.nl> (raw)
In-Reply-To: <t7abei7kkk.fsf@googlemail.com>
On Sep 8, 2008, at 4:56 PM, Richard G Riley wrote:
> Thomas Baumann <dtbaumann@yahoo.de> writes:
>
>>>>> 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 :-;)
>>>
>>
>> Fortunately, there is _no_ auto-recalculation, it would slow down
>> things significantly on large tables with complex formulas.
>
> Well, clearly one would be able to turn it off in the case of
> excessive
> load. In my case its unfortunate, rather than fortunate, since the
> spreadsheets I have (or want to convert) are small and there is
> negligible slowdown. To have to remember to refresh the entire
> spreadsheet is a burden - not a large one I agree, but one which if
> forgotten could lead to catastrophic financial reports :-;
Hi Richard,
how about this code (can even go into .emacs):
(run-with-idle-timer 1.0 'repeat
(lambda ()
(and (eq major-mode 'org-mode)
(org-at-table-p)
(org-table-recalculate 'all))))
This will recalculate each time you are idle for more than 1 second
with cursor inside the table.
This may get you into trouble when you have a formula that produces
and error, in which case you can protect the call with a condition-
case, or you can write yourself a function that does turn this feature
on and off.
>>
>>
>>> 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 |".
>>
>> tab into the field and start writing... believe me, it works (org
>> 6.06b
>> and all versions I used since the tables were introduced.)
>
> As I said above, when I tab in and start writing it adds to the
> existing
> text. I do believe it might be different for you, but believe me, it
> does not for me...
What is the setting of org-table-auto-blank-field ?
If it is t and the feature Thomas describes does not work, you have
indeed got interference from some other package.
- Carsten
prev parent reply other threads:[~2008-09-08 17:07 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
2008-09-08 10:48 ` Thomas Baumann
2008-09-08 14:56 ` Richard G Riley
2008-09-08 17:07 ` Carsten Dominik [this message]
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=6088737A-C295-4508-9575-5D6CE909C6F8@uva.nl \
--to=dominik@science.uva.nl \
--cc=dtbaumann@yahoo.de \
--cc=emacs-orgmode@gnu.org \
--cc=rileyrgdev@googlemail.com \
/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.